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

Sending email to multiple people from people picker in sharepoint list

Hello all,

 

I am trying to send multiple emails to people selected in a sharepoint people picker field called 'Approval needed by'. I can see that multiple emails are being pulled from the sharepoint list in my 'Get item' action but I am not sure how to parse/ seperate these emails into different variables. 

 

Here are the emails shown in the Odata

 

questionforum.JPG

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Sending email to multiple people from people picker in sharepoint list

Hi @Anonymous,

 

Please refer to screenshot below to create the flow:

Capture.PNG

 

Please make sure you have add a semicolon after the dynamic content in the "Append to staring variable" action.

 

 

 

Best regards,

Alice

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Sending email to multiple people from people picker in sharepoint list

Hi @Anonymous,

 

Do you want to get each single email address from the multiple selected person column "Approval needed by" in the item?

 

If you want to get each single email address from the "Approval needed by" column in the item, please refer to screenshot below to create the flow:

Capture.PNG

 

When an item is created in the list, the flow would run successfully as below:

Capture.PNG 

 

 

 

Best regards,

Alice

Anonymous
Not applicable

Re: Sending email to multiple people from people picker in sharepoint list

Hi Alice,

 

Thanks for the reply. 

I can't seem to get approvals to send to the individual emails. When I put the 'start approval' within the apply to each, it only sends to one email. When the 'start approval' is outside the apply to each, I am not able to select the output of the compose action (shown in picture below). Please could you advise on a workaround. Thank you

 

questionforum2.JPG

Community Support Team
Community Support Team

Re: Sending email to multiple people from people picker in sharepoint list

Hi @Anonymous,

 

Please refer to screenshot below to create the flow:

Capture.PNG

 

Please make sure you have add a semicolon after the dynamic content in the "Append to staring variable" action.

 

 

 

Best regards,

Alice

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,912)