This Power Automate tutorial explains how to send emails to multiple recipients from a SharePoint list using Power Automate or Microsoft Flow.
I have a SharePoint list called Event List; when the event is added to the SharePoint list, we will send an email to the attendees. The SharePoint list contains the following columns:
- Title (event name)- Single line of text
- Event date- Date and time
- Attendees -Person (multiple selections enabled)
- Organizer -Person
For this, we will create an automated cloud flow in Power Automate that will trigger when an item is created in SharePoint. Based on the Attendees we have provided, the email will go to them automatically.
Now let’s create a flow that will send an email to multiple recipients.
Send emails to multiple recipients from SharePoint list in Power Automate
Here we will see how to send emails to multiple recipients from a SharePoint list in Power Automate.
Before you start creating the flow make sure you have created the SharePoint list with the above column. Then follow the below steps
Step 1: Log in to Power Automate, then click on the +Create icon in the left navigation -> select Automated Cloud flow
Then provide the flow name, and select the When an item is created action. Then click on Create button.
When an item is created, action is added to the flow. Then provided the below information:
- Site address: Select or provide the SharePoint site address.
- List name: Then provide the list name.
Step 2: Next, we will initialize the array variable that will store the recipient email address, so click on the +New step -> select Initialize variable action. Then provide the below information:
- Name: Provide the name of the variable.
- Type: Provide the type of variable as an Array.
Step 3: Next, we will append the email to the array variable, so click on the +New step -> select Append to array variable action. Then provide the below information:
- Name: Select the variable name from the dropdown.
- Value: Select the Attendee’s email from dynamic content. That will automatically add Apply to each action, as we are working will an array of emails.
Step 4: Next, we will use the join method to convert the array to a string separated by ‘;’ So, click the +New step -> select Compose action. Then provide the below information:
- Inputs: Provide the below expression:
Step 5: Now we will send an email to multiple recipients, so click on the +New step -> select Send an email (V2) -Outlook. Then provide the below information:
- To: Provide the above compose action from dynamic content.
- Subject: Provide the subject of an email.
- Body: Provide the body of an email.
Step 6: Now run the flow manually; for this, save the flow, click on the Test icon ->select the Manually option, -> click on the Test button. After that, create an item in the SharePoint list. After that, you can see your flow run successfully.
Then you can see Attendees will get an email like the one below.
This is an example of how to send email to multiple recipients from a SharePoint list using Power Automate.
In this Power Automate tutorial, we saw how to send email recipients from a SharePoint list using Power Automate.
You may also like:
- How to find text in a string using Power Automate?
- How to convert string to Date using Power Automate?
- Create XML file from CSV in Power Automate
- How to count rows in a SharePoint list using Power Automate?
- Code View hyperlink rewritten: Send an email (V2) action Dynamic Content in Power Automate
After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (9 times). I have also worked in companies like HP, TCS, KPIT, etc.