How to Use a "List" Field in Flow Designer?

[MatheusR]

I’m facing an issue in Flow Designer: I need to send emails to some users, but the email information is stored in a field with the "list" format.

Currently, I’m using the Lookup Record action to retrieve user data, but the returned values are in sys_id format. These sys_ids are stored in a variable in Flow Designer. After that, I need to query another table to get the emails corresponding to these sys_ids and, finally, use these emails in the Send Email action to send the notifications.

Does anyone know how I can properly achieve this?

 

[Jon23 · Accepted solution]

Hi @MatheusR,

• After Step 1: Look Up Records, do a 'For each'. (assuming these are the records with your email addresses)
• Loop through each record returned and append the email address to your variable.
• Use the variable containing all the email addresses in your notification. 

Example:

[Ankur Bawiskar]

@MatheusR 

you can use For each after lookup records

Then iterate over and use Send Email for each of the loop

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

[Ankur Bawiskar]

@MatheusR 

Thank you for marking my response as helpful.

As per new community feature you can mark multiple responses as correct.

If my response helped please mark it correct as well so that it benefits future readers.