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 / Power Automate Approva...
Power Automate
Answered

Power Automate Approval Reminders only to Pending approvers

(0) ShareShare
ReportReport
Posted on by 61

Hello,

I have seen numerous solutions where you add a parallel branch with a Do Until condition to send out Approval Reminders. This process works awesome for a single approver. I have not found a solution where this could work for multiple approvers but only send out reminders to approvers who have not completed their tasks. I had seen a solution where Dataverse was being used to query the Approvals Response table, but for reasons beyond my control, I don't have access to  the Dataverse. I did a search in the community but did not come up with any conclusive results. Would anyone have an idea on how this can be accomplished? I did try putting the Create and wait for approval in an apply to each loop for each approver, with a variable to terminate the loop, but I ran into a challenge where it does not come out of the Do Until loop, as it probably gets confused as to which iteration of the variable to check.

I can provide more details if needed. If anyone has any ideas, I would love to see.

 

Thanks,

Dhruv

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    69,485 Most Valuable Professional on at

    Other than querying Dataverse or running each approval for each user in a separate parallel branch there is no way to know which approvers have already responded to an Everyone must approve approval.

  • dhruvmathur Profile Picture
    61 on at

    I know, it is frustrating, the way Approvals are designed. I think I was finally able to get this to work. I ended up getting one of my Service Accounts Read access to the Approvals Response table in the dataverse and then using that SPN to run the Dataverse action. I am still in the process of testing to make sure it works. Appreciate your answer.

  • lynn_parsons Profile Picture
    16 on at

    Did you get the query to Dataverse approval response table to work?  I'm having trouble figuring out how to reference the owner column which appears to be where the approver is being stored.  It looks like the column is called ownerid but that's not working for me.  I probably just don't know he right syntax to reference it.  Any help most appreciated.

  • Pstork1 Profile Picture
    69,485 Most Valuable Professional on at

    There are a couple issues getting the approval responses.  First you need to use Create Approval instead of Start and Wait for an approval so you can get the Approval ID in the parallel branch where you send reminders. Then the next issue is that the Owner field is a lookup so the value is a GUID.  If you want the name of the responding account you have to handcode the JSON to use @item()?['_ownerid_value@OData.Community.Display.V1.FormattedValue']. Here's a screenshot that shows how to retrieve the Owner and the response in an DO Until loop with a delay.

    image.png

     

  • lcwidak Profile Picture
    22 on at

    I did what you did but nothing worked, is there a way to send people reminders if we are waiting for a response from them is there still nothing to do besides Dataverse? Are there any videos to explain how to do Dataverse so I can send reminder emails.

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 791

#2
Valantis Profile Picture

Valantis 582

#3
Haque Profile Picture

Haque 529

Last 30 days Overall leaderboard