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,
- Site Address
- List Name
- 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:)