- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2022 01:03 PM
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.
Solved! Go to Solution.
- Labels:
-
Service Catalog
-
Service Portal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2022 08:32 PM
Hi
Thank both for your responses, but I was unable to find a solution using flow designer so I end it up using the notification outside flow designer. I create a notification and I called the variable for the list collector.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2022 02:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2022 02:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2022 03:03 PM
var lst = fd_data.trigger.request_item.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());
}
}
return arr;
can you try this ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2022 03:07 PM
Hi
Just tried and is not returning any value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2022 03:08 PM
can you try putting some logs ? inside for loop and and log of arr too and check please ?