List Collector Variable on Catalog Item only show sys_id

[Edxavier Robert]

Hi all, 

I have a catalog item with a list collector variable. The list collector is a reference field to the sys_user_group table. My issue I am trying to get the responses on an email notification but it's only returning the sys_id of the groups. How I can get the Display Value or the actual name of the group in the email notification? I am using the flow designer to send the notification.  

[Edxavier Robert]

[Mohith Devatte]

In body are you hard coding any thing ?

or just youa re dragging variables ?

[Edxavier Robert]

Hi, 

I am just dragging the variable from step 2 into the notification body. 

[Mohith Devatte]

Ah okay so there you can fid any option to script the variable assignment beside the drag pill you need to put the code over thiere like below

var lst = fd_data.trigger.current.variables.your_list_collector_variable_name;

var splt = lst.split(',');

var arr=[];

for(var i=0; i<splt.length;i++)

{

var usr = new GlideRecord('sys_user_group');

usr.addQuery('sys_id',splt[i]);

usr.query();

if(usr.next())

{

return arr.push(usr.name.toString());

}

}

[Edxavier Robert]

Hi, 

And this goes in the body of the email?