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.  

[Mohith Devatte]

Hello @Edxavier Roberto Caez ,

for list collector you need to do like this 

glide record to group table push the names of the groups and then pass it as a parameter in event to notification

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())

{

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

}

}

gs.eventQueue('your_event_name','your glide record object','your parameter 1', arr);

PLEASE MAEK MY ANSWER CORRECT IF IT HELPS YOU

[Edxavier Robert]

Hi @Mohith Devatte , 

Thanks for your response, but where exactly do I need to do this? Should I create a Catalog Client script? 

[Mohith Devatte]

so you are trying to send the notification in flow right ?

can you share the screenshot how you are doing it of how you are trying to populate groups ?

[Edxavier Robert]

Hi, I have a catalog Item on the Service Portal with a list collector variable

After is submitted I am sending an email notification using flow designer with the details of the form. But the field with the list collector is only showing the sys_id of the selections. 

The list collector is a reference field to the sys_user_group table where I am just selecting groups from there. 

I am using the variable data pick to add the information into the the notification