Power Platform Community Forum Thread Details

Hi,

In one of a SharePoint list there is a person type column having multiple data

abc@xyz.com

def@xyz.com

Pls. help me with a formula to get the following result - abc@xyz.com; 7def@xyz.com

Regards

Categories:

General topics

Hi,

I had something similar. I did the following:

1. Initialize empty string variable (do not set initial value)

2. Get Items (my example I just grabbed top 1 as I know it has multiple values in a People column)

3. Append to String Variable (note the semi colon added, and that the action will be added into for each loops. One loop for each item, one loop for each person in people column)

The email dynamic content is just 'column name' email from my SharePoint List people column. In this case my column is called 'GPO' so the dynamic content for the email of the people in that column is simply 'GPO Email'.

My completed string variable used, outside of the for each loop, looks as such:

Below is the entire flow I used for this example. I finished with a Compose action to view the complete Emails_String, but you won't need this, you can add the variable as dynamic content to an approvals/outlook connector to send approvals/emails to all people in the people list of your selected item(s).