You’re offline. This is a read only version of the page.
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
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.
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.
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.
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.
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.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
