cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
PrasadAthalye
Super User
Super User

@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.

 

PrasadAthalye_0-1614343654053.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

7 REPLIES 7
PrasadAthalye
Super User
Super User

@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.

 

PrasadAthalye_0-1614343654053.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Anonymous
Not applicable

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

How I can add that semicolon separator?

Anonymous
Not applicable

It worked! Thanks a lot!

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

aemiranda
Frequent Visitor

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
New Member

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.

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.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,331)