Retrieve email address from an Multiple Person field from a collection?

  • 23 October 2019
  • 2 replies
  • 318 views

I would like to retrieve the retrieve email address from an Person field from a collection.

 

My idea as below:

Firstly, I used "Query List" to query a SharePoint list, and select column output and output to a Workflow variable (type: collection).

 

After that, I used "For each" to throught the workflow variable and would like to retrieve email address from the selected column Person field (which allow multiple value). But I stuck on this step. any idea?

 

Alternatively, any ot


2 replies

Userlevel 4
Badge +9

To get the email from your people field, just create a "Person" variable and with the action "Set workflow variable", you can select the format by clicking on the X.


And here you go :smileywink:

Thanks for your reply.


 


But I would like to concat the email in a single variable from multiple items in the list.


Please see the attached image, and my goal should like this:
user1@contoso.com;user2@contoso.com;user3@contoso.com;user4@contoso.com;user5@contoso.com;

Reply