Send Approval to SharePoint Group Members Using Power Automate

Last week, I wrote a detailed blog post about sending an approval to a Microsoft 365 Group in Power Automate. After publishing it, one of my subscribers reached out and asked, “Is it possible to send approval emails to SharePoint Group members as well?”

It’s quite similar, we need to get the members’ email from the SharePoint Group first, and then send the approval request to them.

In this tutorial, I will tell you how to send approval requests to SharePoint Group members using Power Automate.

Send Approval to SharePoint Group Members using Power Automate

For this example, I have a SharePoint list named Project Tasks. Whenever a new item is created, an approval request should be sent to all members of a specific SharePoint Group.

Request approvals from Sharepoint groups in Power Automate

Now follow the steps below:

  1. Open Power Automate, create an automated cloud flow with a trigger (When an item is created). Select your SharePoint site and document library.
Assign approval task to a SharePoint group with Power Automate
  1. Then, add the Send an HTTP request to SharePoint action form from the Office 365 Groups connector, and provide the following parameters:
    • Method: GET
    • URI:
_api/web/siteGroups/getByName('DMS Members')/users

(Replace “DMS Members” with your SharePoint group name.)

Send Approval to SharePoint Group Members
  1. Next, add a Select action to extract all the member email addresses from the response.
    • From: body(‘Send_an_HTTP_request_V2’)?[‘value’]
    • Map: item()?[‘mail’]
Send Approval to SharePoint Group Members MS Flow

This step will create a clean array containing only the members’ email addresses.

  1. Now, add the Start and wait for an approval action. Provide parameters below:
    • Approval type: Approve/Reject – First to respond
    • Title: Task Approval Request: @{triggerOutputs()?[‘body/Title’]}
    • Assigned to: @{join(body(‘Select’), ‘;’)}
    • Details:
A new task has been created in the Project Tasks list.

Task Title: @{triggerBody()?['Title']}
Created By: @{triggerBody()?['Author/DisplayName']}
Created On: @{formatDateTime(triggerOutputs()?['body/Created'], 'dd-MMM-yyyy hh:mm tt')}

Please review and take appropriate action.
Assign approval task to a group of users in Power Automate
  1. Add a Condition action. In the Condition, set:
outputs('Start_and_wait_for_an_approval')?['body/outcome'] is equal to Approve
Assigning Power Automate flow approvals to SharePoint Groups
  1. In the True section, add the Update item action and provide the parameters below:
    • Site Address: Your SharePoint site
    • List Name: Project Tasks
    • Id: Use the ID from the trigger
    • Status: Approved
    • Comments:
✔️ Approved by @{body('Start_and_wait_for_an_approval')?['responses'][0]?['responder']?['displayName']}
with @{body('Start_and_wait_for_an_approval')?['responses'][0]?['comments']}
(@{formatDateTime(body('Start_and_wait_for_an_approval')?['responses'][0]?['responseDate'],'dd/MM/yyyy hh:mm:ss tt')})
Create and test an approval workflow with Power Automate
  1. In the False branch of the condition, add Update item action:
    • Site Address: Your SharePoint site
    • List Name: Project Tasks
    • Id: Use the ID from the trigger
    • Status: Rejected
    • Comments:
❌ Rejected by @{body('Start_and_wait_for_an_approval')?['responses'][0]?['responder']?['displayName']}
with @{body('Start_and_wait_for_an_approval')?['responses'][0]?['comments']}
(@{formatDateTime(body('Start_and_wait_for_an_approval')?['responses'][0]?['responseDate'],'dd/MM/yyyy hh:mm:ss tt')})
Send An Approval To A Sharepoint Group In Power Automate

Test the Flow to Send Approval to SharePoint Group Members

Go to your Project Tasks SharePoint list. Create a new item.

Test the Flow to Send Approval to SharePoint Group Members

Wait a few seconds for Power Automate to trigger. All members of the DMS member group will receive the approval request directly in their inboxes.

Send Approval to SharePoint Group Members using Power Automate

Once any one member responds, the approval result will be updated in the list automatically.

How to Send Approval to SharePoint Group Members using Power Automate

That’s how you can send an approval to SharePoint Group members using Power Automate by fetching all group member emails and assigning the approval dynamically.

You may also like:

Power Apps functions free pdf

30 Power Apps Functions

This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.

Download User registration canvas app

DOWNLOAD USER REGISTRATION POWER APPS CANVAS APP

Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App