cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Miguel_MESP
Helper II
Helper II

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

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

3 REPLIES 3
PrasadAthalye
Super User
Super User

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

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

How I can add that semicolon separator?

It worked! Thanks a lot!

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (54,539)