How to Send Email to SharePoint Group in Power Automate?

Recently, I was working with Power Automate, where I was required to send an email to a SharePoint group automatically. In Power Automate, this can be done with the help of a connector called Send an HTTP request to SharePoint, which helps to retrieve the email address of a SharePoint group.

In this tutorial, we will learn everything about “Power Automate send email to SharePoint group“. You will also get to know how to get SharePoint group members email addresses using Power Automate.

Send Email to SharePoint Group using Power Automate

In a SharePoint site, by default, a few SharePoint groups will be presented on the site, like Owners, Members, and Visitors.

But for this demo, I have created a custom SharePoint group and added a few users to the group by following the below steps:

To create a new SharePoint group, follow the below instructions:

1. Open the SharePoint site, Click Settings -> Select Site permissions -> Then, click on the Advanced permissions settings link.
2. Under the Permissions tab, select the Create Group -> In the Create Group page, provide a group name, Choose the permission level, and click the Create button.
3. Then, the new SharePoint group is added.
4. To add members: Open the created group-> Click on New menu -> Select Add users to this group -> Invite people -> Click Share.

Now, we will create an instant cloud flow in Power Automate that will send an email to users of the above SharePoint group.

Follow the below steps:

1. Navigate to https://make.powerautomate.com to open your Power Automate home page -> Click on + Create -> Select an Instant Cloud Flow and assign a name to it -> Choose the trigger’s flow “Manually trigger the flow” and click on the Create button.

Unfortunately, SharePoint groups do not have their associated email address. So, to get a list of SharePoint group members and their emails, we need to use an HTTP request to the SharePoint API.

In the next step, we will use the “Send an HTTP request to SharePoint” to get SharePoint group members in Power Automate.

2. Add a new step and choose to Send an HTTP request to SharePoint flow action. Configure the required parameters:

• Site Address – From the dropdown, select the SharePoint site address.
• Method – Choose the GET method from the dropdown
• Uri – Add the Uri field that is placed in the below code.

_api/web/sitegroups(27)/users
             [OR]
_api/web/siteGroups/getByName('Developer Group')/users

Here, we can retrieve SharePoint group member’s data with their email address by providing MembershipGroupId or the SharePoint Group name.

Where,

1. sitegroups(27) is a MembershipGroupId.
2. Replace ‘Developer Group‘ with the name of your SharePoint group.

To view the MembershipGroupId:

• In the Advanced permissions settings page, open a specific SharePoint group -> In the URL, you can find MembershipGroupId.

Refer to the image below.

Hence, HTTP action will only return the SharePoint group members with a lot of data. So, we need to fetch each user’s email address from the given output.

3. Click on the Next step and select the Select action. Then, write the below expression in the From field.

outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['results']

In the Map section, use the below expression to get the email values:

item()?['Email']

Now, we have retrieved the array of email addresses from SharePoint group members. We need to separate the list of email addresses to use these email addresses.

4. Here, add a Compose flow action to convert the array to a delimited list of emails. Configure the below parameter:

• Inputs: Click the field -> Select Expression -> Insert the below expression.

join(body('Select'),';')

Here, I was separating the emails with a semicolon [;] delimiter.

5. To send an email to the SharePoint group using Power Automate, click the Next step and select the ‘Send an Email(V2)‘ action.

• To – Pass the output of the compose flow action.
• Subject – Enter the Subject line for the mail.
• Body – Enter a detailed description of the mail.

6. Now, it’s time to Save and run the flow. Click on Save. Then, Click on Test -> Select Manually -> Click Test.

7. Once the flow runs successfully, it will send an email notification to the users in the SharePoint group. You can check the email in the below screenshot.

This is how to get SharePoint group members’ email addresses in Power Automate and then send emails to the SharePoint group using Power Automate.

Send Emails to Multiple SharePoint Groups using Power Automate

In the same way, you can also send an email to multiple SharePoint groups using Power Automate.

For example, here you can see I have two SharePoint groups, like the one below, with a few members added to them.

Follow the steps that are mentioned in the above example to get the email addresses of the SharePoint group members [Developer Group].

1. Next, add an Initialize variable flow action to initialize the email address from the SharePoint group. Set the below details:

• Name: Provide the name for a variable.
• Type: Select the datatype of a variable as ‘Array.’
• Value: Take Output of Select flow action.

2. After that, add one more Send an HTTP request to SharePoint flow action to get members from the second SharePoint group. Ensure to provide the following details:

• Site Address – From the dropdown, select the SharePoint site address.
• Method – Choose the GET method from the dropdown
• Uri – Add the Uri field that is placed in the below code.

_api/web/sitegroups(29)/users

Hence, sitegroups(29) is the MembershipGroupID for that particular group.

3. Then, add Apply to each control loop to get the SharePoint group’s values, like members and email addresses.

• Select an output from previous steps: Take the below insert code value.

body('Send_an_HTTP_request_to_SharePoint_2')?['d']?['results']

4. Inside the Apply to each loop, take an Append to array variable flow action. Configure the below details:

• Name: Select the name that is taken from the drop-down.
• Value: Add the value that is given in the below code.

item()?['Email']

5. Then, add a Compose flow action to join the variable of email address retrieved from the two SharePoint groups.

• Inputs: Click Expression -> Add the below code in it.

join(union(variables('Dev Email Address'),variables('Dev Email Address')),';')

6. To email the group members, click the Next step and select the ‘Send an Email(V2)‘ action.

• To – Pass the output of the compose flow action.
• Subject – Enter the Subject line for the mail.
• Body – Enter a detailed description of the mail.

7. Now, its time to Save and run the flow. Click on Save. Then, Click on Test -> Select Manually -> Click Test.

8. Once the flow runs successfully, the SharePoint group members will receive an email notification as like displayed below.

This is how to send emails to all members of the SharePoint group in Power Automate in Microsoft 365.

Conclusion

By following this complete tutorial, you should be able to get a SharePoint group member’s email address in Power Automate and then send emails to the SharePoint group using Power Automate.

You may also like:

• Power Automate Send Email Based on Form Response
• Power Automate Send Email From Shared Mailbox
• Save Office 365 Email Attachments to OneDrive for business using Power Automate
• How to Extract Numbers from Email Subjects in Power Automate?
• How to Save Email Attachment to SharePoint using Power Automate?

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 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 (12 times). I have also worked in companies like HP, TCS, KPIT, etc.