Trying to pass email addresses from a list collector

[Bidduam]

I have a catalog item that asks for a list of users, I'm using a list collector that is accessing the sys_user table.

What I want to do later in my flow is the send a notification to all users added to the list collector field on the catalog item

The field is called:

u_shared_staff

I am sending the notification via a fire event action in a flow. I've added the "u_shared_staff" data pill, but it doesn't dot walk to the email field, therefore it is adding to parm2 the sys id's of the users, not their email addresses and it therefore obviously doesn't actually send them the email.

Ideas?

[Community Alums]

Hi @Bidduam ,

This thread should give you an idea to procced : https://www.servicenow.com/community/developer-forum/how-to-send-notifications-to-users-selected-in-...

[Bidduam]

@Community Alums this is not really the solution I'd like to use sorry. I'd like to keep this in the flow if possible, even if it is a script on the flow action. There must be a way to use the users email addresses via the flow?

[Viraj Hudlikar]

Hello @Bidduam 

In your flow you will need to first grab the user sys_id then lookup with sys_id is one of "X" and run a for each loop store all email of user in variable in string format with comma seperated format then use that flow variable while you are triggering event in param2.

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[Ankur Bawiskar · Accepted solution]

@Bidduam 

let the data pill pick sys_ids and it should work with sysIds as well of the users

If those sysIds have email address then email will be sent in email logs provided you are sending it correctly in event parm1 or parm2

share your flow screenshot

You can use flow variable and store all the user sysIds and then use this flow variable to set the recipients

If my response helped please mark it correct and close the thread so that it benefits future readers.