Send one e-mail to multiple selection person or group column

[Anonymous]

Hello all,

I have a power automate where I'm trying to send a notification to a group of users based on a sharepoint list column.

That column is person/group type and allows multiple selection.

I need to send a single e-mail to all users on that column and the number of e-mails on the column isn't always the same so I can't use select and call the array positions.

Help please 🙂

[PrasadAthalye · Accepted solution]

@Anonymous You can declare a string variable to capture all emails and then finally use that in string variable like below... Ensure that within Append to string variable you add semicolon towards the end as a seperator.

[Anonymous]

Hey, can you show me what you put inside the append to string box? 

How I can add that semicolon separator?

[Anonymous]

It worked! Thanks a lot!

[aemiranda]

Hi, how do you resolve this issue? Can you show the images of what you did?

[aemiranda]

I already solve the issue. It was really simple.

1. Initialize a variable type string

2. Create an Apply to action. The value must be the 'person or group' field from sharepoint.

3. Inside the reply to action, create an append to string variable action: the name must be the variable type string and the value must be the 'Person or Group field' email item.

4. Place in the field 'to' in the send email action the name of the string variable.

[FredCyr]

I'm new to Power Automate but this topic interest me a lot!

I have the exact same situation were I have multiple name in a "Notification" column and I would like to send an email when the item is modified. Can someone describe step by step (in details) of what I should do? I would greatly appreciate.

[aemiranda]

1. Initialize a variable type string

2. Create an Apply to action. The value must be the 'person or group' field from sharepoint.

3. Inside the reply to action, create an append to string variable action: the name must be the variable type string and the value must be the 'Person or Group field' email item.

4. Place in the field 'to' in the send email action the name of the string variable.