How to Send Emails to Multiple Recipients from a SharePoint list using Power Automate?

This Power Automate tutorial explains how to send emails to multiple recipients from a SharePoint list using Power Automate or Microsoft Flow.

Scenario:

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

Send Emails to Multiple Recipients from a SharePoint list using Power Automate

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.

Table of Contents

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

How to send email to multiple recipients from sharepoint list using Microsoft flow

Then provide the flow name, and select the When an item is created action. Then click on Create button.

How to send email to multiple recipients from sharepoint list using MS flow

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.

power automate send email to multiple recipients from sharepoint list

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.

Microsoft power automate send email to multiple recipients from sharepoint list

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.

Using Microsoft power automate send email to multiple recipients from sharepoint list

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:

join(variables('Recipents'),';')

Using power automate send email to multiple recipients from sharepoint list

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.

How to send email to multiple recipients from sharepoint list using power automate

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.