cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Approval reminder - Multiple Approvers

Hi All,

 

I have a flow with an approval step where both approvers must approve to move forward. I'd like to add a reminder if the approval hasn't been completed but I only want to send the reminder to the approver who has NOT already completed the approval. All the suggestions I've seen would send a reminder to everyone on the approvers list even if they had completed their approval.

I think the issue is that in order to know the approver response I need to have my do until loop after the approval step, yet to send a reminder I need to be running something in parallel with the approval step.

Anyone have any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Approval reminder - Multiple Approvers

Hi @robofski I have recently done this exact thing with someone I've been mentoring. I'm in the process of creating a video, so I'll hurry up and try to finish it off.

 

It basically starts from the automation which I've created in this video:

https://www.youtube.com/watch?v=8mA5wiSusow

 

The difference is that my approvers are stored within a string, and are then removed from the string each time someone approves. I've attached the actual export to this post to get you going while I record it.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
If you liked my response, please consider giving it a thumbs up. THANKS!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

View solution in original post

14 REPLIES 14
Highlighted
Frequent Visitor

Re: Approval reminder - Multiple Approvers

Hi @robofski ,

Can you do cascaded approval? after the first one then to the next one? I don't think there is a way to retrieve who hasn't approve it at the moment.

You can try connecting thru CDS and see if list of approvers and status of each will be there thru Approval ID, but I doubt there will be and you need premium license.

Highlighted
Super User
Super User

Re: Approval reminder - Multiple Approvers

Hi @robofski I have recently done this exact thing with someone I've been mentoring. I'm in the process of creating a video, so I'll hurry up and try to finish it off.

 

It basically starts from the automation which I've created in this video:

https://www.youtube.com/watch?v=8mA5wiSusow

 

The difference is that my approvers are stored within a string, and are then removed from the string each time someone approves. I've attached the actual export to this post to get you going while I record it.





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
If you liked my response, please consider giving it a thumbs up. THANKS!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Approval reminder - Multiple Approvers

@Charlon_thanks for the feedback, I had thought that too just wanted to see if anyone had any other suggestions.  Appreciate the comment, at least I think I'm on the right track!

Highlighted
Advocate I
Advocate I

Re: Approval reminder - Multiple Approvers

@MattWeston365Awesome thanks Matt, I'll take a look!

Highlighted
Advocate I
Advocate I

Re: Approval reminder - Multiple Approvers

I'm a flow novice but I can understand what you're doing there, very creative, would never have come up with that on my own!

 

Excellent work @MattWeston365 

Highlighted
Super User
Super User

Re: Approval reminder - Multiple Approvers

Thanks @robofski if you need any further help please feel free to shout





Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
If you liked my response, please consider giving it a thumbs up. THANKS!


Proud to be a Flownaut!





Community Leader: Black Country PowerApps & Flow User Group

Highlighted
Frequent Visitor

Re: Approval reminder - Multiple Approvers

Have you done the video yet. My approvals are made with "email with options" because I have to attach a file to it. But I would like to send a reminder to the person that hasn't approved yet.

Highlighted
Advocate I
Advocate I

Re: Approval reminder - Multiple Approvers

Yes, I used Matts video posted above and got my approval reminders working.  Only thing to be mindful of is the flow keeps running until the reminder period times out even if there is no reminder to send but it’s a small price to pay for a great solution.

Highlighted
Frequent Visitor

Re: Approval reminder - Multiple Approvers

@MattWeston365 Hi Matt! Is this video available? Looking forward to it!

Helper II
Helper II

Re: Approval reminder - Multiple Approvers

@MattWeston365 

 

Hi there, I've been following through with your flow and integrating it into my approval process, but I noticed something weird here, maybe I done something wrong, but it seems that it's not working the way it's expected. In my case, I send to 2 people to respond, BUT the initial approval will only send to 1 person. After a minute without responding, we BOTH get the reminder email, but I never got that initial request. After 5 minutes, my colleague responds, THEN I get that initial approval email for approve/response. Is there a particular part of the flow I should take a closer look at?

 

Highlighted
New Member

Re: Approval reminder - Multiple Approvers

Did you solve this? I have the exact same situation.

Highlighted
Advocate I
Advocate I

Re: Approval reminder - Multiple Approvers

This video shows how you can use the CDS to query who hasn't approved from a multi approver approval, very cool. https://www.youtube.com/watch?v=ZupQ0AbDl0I&list=PLbnVz9lSb1K5i3xgjuPzTMD-I33H6Gaqf&index=2 

Highlighted
New Member

Re: Approval reminder - Multiple Approvers

Thank you so much! It works!

 

The only downside is that CDS is a premium function and you need to pay 15$/month for each user. 

https://flow.microsoft.com/en-us/pricing/

Highlighted
Advocate I
Advocate I

Re: Approval reminder - Multiple Approvers

@dawah good point about the licensing, but you only need to license the account that is running the flow.  If you've got lots of users writing flows with this requirement then yep I could see it getting expensive! 

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (6,132)