web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send email from sharep...
Power Automate
Unanswered

Send email from sharepoint once a approver complete all his approvals

(0) ShareShare
ReportReport
Posted on by 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.

Ahemed_0-1688396472162.png

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)
  • S-Venkadesh Profile Picture
    1,214 Super User 2026 Season 1 on at

    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

    SVenkadesh_0-1688406419257.png

    Please consider giving it a thumbs up!

    Click "Accept as Solution", if your problem has been resolved.

     

    Regards,

    S.Venkadesh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 304

#2
David_MA Profile Picture

David_MA 245 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 243 Most Valuable Professional

Last 30 days Overall leaderboard