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

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (12,010)