Display Values of Catalog Variables in an Email using Flow Designer

[cnharris1]

Hello developers,

I know this question has been asked several times and I researched each different way but I haven't had any luck.

The backstory is that I'm building out a catalog item and once its submitted it goes through a workflow using flow designer. However, once I get the catalog variables, I want to send an email to certain individuals once the request is created, which I have that part working. The problem is that I'm trying to get all of the catalog variables in that email. I know I can just drag and drop the data pills but instead of giving me the display values, I'm getting the sys ids. So I tried using a script to pull in the catalog variables, which technically works but it only gives me the first variable and not all of them. Is there a way to get the display value of all the catalog items dropped into the email using flow designer?

Here's a copy of my script:

/*

**Access Flow/Action data using the fd_data object. Script must return a value.

**example: var shortDesc = fd_data.trigger.current.short_description;

**return shortDesc;

*/

var submitter = fd_data.trigger.request_item.variables.submitter.getDisplayValue();

return 'Requested by: ' + submitter;

var emailt = fd_data.trigger.request_item.variables.email_address.getDisplayValue();

return 'Email address: ' + emailt;

var dept = fd_data.trigger.request_item.variables.department.getDisplayValue();

return 'Department: ' + dept;

var type = fd_data.trigger.request_item.variables.project_type.getDisplayValue();

return 'Project type: ' + type;

var intiativen = fd_data.trigger.request_item.variables.initiative_name.getDisplayValue();

return 'Initiative name: ' + intiativen;

var int_desc = fd_data.trigger.request_item.variables.initiative_description.getDisplayValue();

return 'Initiative description: ' + int_desc;

var srevp = fd_data.trigger.request_item.variables.accountable_srevp.getDisplayValue();

return 'Accountable SREVP: ' + srevp;

var risksa = fd_data.trigger.request_item.variables.risks_associated_with_the_initiative.getDisplayValue();

return 'Risks associated with the initiative: ' + riska;

var resourcesd = fd_data.trigger.request_item.variables.resources_needed.getDisplayValue();

return 'Resources needed: ' + resourcesd;

var tsdate = fd_data.trigger.request_item.variables.target_start_date.getDisplayValue();

return 'Target start date: ' + tsdate;

Here's the context of what I'm using it for:

And here's what that script is returning:

Any help or guidance will be greatly appreciated!

Best regards,

cnharris

[cnharris1]

Thanks OlaN for replying! That worked!

I have two more question for you.

My first question is instead of having everything appear side by side like this:

How can I make the variables appear on a separate line like this:

Requested by: Corey Harris

Email address: coreyharris

Department: Accounting Servicing

and so on?

My last question is, if I want to add verbiage to the email and say something like Summary of Requested Items and then start listing everything out, how would I accomplish that via script?

Thanks again for your help!

Best regards, 

cnharris

[OlaN]

Hi, good to see.

Regarding the follow up questions

1. You can add a newline in the text by adding a line like this

mailtext += '<br>';  // add a newline to the text

2. Just add another text line at the beginning of your script, something like this

var mailtext = 'Summary of Requested Items' + '<br><br>';

var submitter = fd_data.trigger.request_item.variables.submitter.getDisplayValue();
mailtext += 'Requested by: ' + submitter;
mailtext += '<br>';

// and so on...

return mailtext;

[cnharris1]

Thanks OlaN that worked perfectly!