Send Mail To SharePoint List PeoplePicker Column Persons Using MSFlow

Introduction

 
In this article we will learn about sending mail to Sharepoint list multivalue peoplepicker field members using power automate.
 
Let's start.
 
Step 1
 
Click on Instant cloud flow
 
Step 2
 
After clicking Instant cloud flow in the popup select "Manually trigger a flow" option, provide flow name and click create. 
 
 
Step 3
 
Click on new step, find and select the “Get Item” action.
 
 
Step 4
 
Expand "Get Item" connector box and provide,
  1. Site Address
  2. List Name
  3. Item Id
 
Step 5
 
Click on new step, find and select the “Select” action.
 
 
Step 6 
 
Expand "Select" Data Operator Action and provide,
 
From--> Select PeoplePickerColumn (@outputs('Get_item')?['body/PeoplePickerColumn'])
 
Map--> Select PeoplePickerColumn Email
 
 
Step 7
 
Click on new step, find and select the “Join” action.
 
 
Step 8
 
Expand "Join" Data Operator Action and provide, 
 
From--> Select Output from Select Action
 
Join With--> Enter the value ";"
 
 
Step 9
 
Click on Next Step and find and select the “Send an Email V2” action.
 
 
Step 10
 
Set the email address from the output of Join Action and set the subject and email formatting as per your needs
 
 
Step 11
 
Click on Save Flow.
 
Step 12
 
To test the flow, Clist test flow button. Then click the done button and verify the email .
 
Step 13
 
Expected output
 
 

Conclusion

 
Hence we learned about how to send emails to SharePoint List PeoplePicker Column Persons using power automate. I hope this helps someone, and happy coding:)