How to send as a one email for multi people field in Power Automate?

Initial Setup

Create a list ‘TestFlow’ with a Title and a People field SecondarySiteOwners. Note: Make sure you set the Allow multiple selection

Create a Flow will the Item Added event trigger

1: Add an action to initialize a String variable.

 2: Add an action to initialize an Array Variable.

3. Add Apply Each loop to loop though the Secondary Site Owners. In the inner action add an action to append array,

Note: in the Value fill the following expression.

items(‘Apply_to_each’)?[‘Email’]

4. Now do the join in the array variable with the join character as ‘;’ (semicolon).

5. Now assign the new output of Join to the String variable for you to use to add to CC or TO line of your email.

Now your ‘SiteOwners’ String variables will have the following values with ‘;’ delimited string.

“AdeleV@M365x146530.OnMicrosoft.com;DebraB@M365x146530.OnMicrosoft.com;DiegoS@M365x146530.OnMicrosoft.com”

Happy Coding!

About Pankaj

I am a Developer and my linked profile is https://www.linkedin.com/in/pankajsurti/
This entry was posted in Power Automate. Bookmark the permalink.

1 Response to How to send as a one email for multi people field in Power Automate?

  1. Gretchen says:

    I have two fields that are multiple people. CC and BCC. I can get it to work for only one of them but not both. I tried to set up parallel tracks following these steps but I’m guessing it is the apply to each section that is giving me issues. Any help would be appreciated.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s