Displaying a comma/semicolon separated list of emails

I’m doing this on a custom object, odds are you will want this on campaign member. So where you see ‘worker’, use ‘campaign member’.

4 steps

  1. lookup the records and add to sObject collection
  2. loop through them
  3. use an assignment element to add the loop variable email to a text variable
  4. display the text variable in a screen

overview_1.png

most of the magic happens in the assignment element, where i add the email to a text variable with a semicolon, and use a constant to add a line break

assignment element
assignment_1.png

constant
constant.png

and here is the result

result_email.png

If you want to get fancy and let users select records from a list view and only export those, you can do that using the approach illustrated by Sir Andrew Fawcett here : https://andyinthecloud.com/2014/06/04/more-power-to-your-flows-in-summer14/

 
0
Kudos
 
0
Kudos

Now read this

Preventing duplicate junction object records

Native dupe management only allows you to reference a single lookup field. So it cannot prevent duplicate junction object records. By using a (new in spring 20) before save flow to concatenate the two IDs into a single text field, you... Continue →