web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Send email from sharep...

Power Automate

Unanswered

Send email from sharepoint once a approver complete all his approvals

(0) Share

Report

Report

Posted on by Ahemed

23

Hi,

I need to send an email to the approvers who has completed their approvals, and email should not trigger to the one whom we have sent the email already.

I have Status column in SharePoint of type dropdown with Approved/Reject.

here we need to send an email to Approver when all his status is filled with Approved or reject.

likewise, I have nearly 450 approvers for whom I have to send an email when his records are completed.

Note: Email should trigger only when all are completed

Ex: Approver Ahemed has 5 records, so email should trigger when all 5 records status is completed.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

S-Venkadesh 1,214 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Ahemed ,
To meet the requirement, you can follow the steps below:

1. Trigger the flow using the "When an item or a file is modified" trigger.
2. Add an action to query the items based on the triggered item's EmpId and Status equal to null. You can use the "Get items" action with a filter query like this:

EmpId eq '@{triggerOutputs()?['body/EmpId']}') and (Status eq null)

3. After the "Get items" action, add a condition to check the count of retrieved items

length(outputs('Get_items')?['body/value'])

4. If the count is zero (meaning no items were retrieved), add an action to send an email notifying that all approvals completed
Please consider giving it a thumbs up!
Click "Accept as Solution", if your problem has been resolved.

Regards,
S.Venkadesh

Was this reply helpful? Yes No

Join the conversation