cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Flow Approval Reminder Notification every "x" hr

Hi.

 

Good Day!

I have an approval flow using MS Flow in Sharepoint List. I wanted to set a condition where as the approval email will notify for example every 5 hrs and will only stop unless the approver have responded. Is it possible? Thanks! 🙂

 

-Jaina

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: MS Flow Approval Notification

@jaina:

 

I demonstrate one technique of sending approval reminder emails below.

My example uses a loop and an approval action in parallel.  I also use a variable.  After the approval is complete, the variable is updated to "Complete.  The loop runs in parallel with the approval and runs until the variable is equal to "Complete".

When the loop starts, it waits 5 hours.  If the variable equals "Pending", a reminder email is sent.  This will continue until action is taken on the approval.

The email should include a link to the approval center (same link for everyone).

 

Please post here if you have additional questions.

 

zReminder1.jpgzReminder2.jpg

 

If this solves your issue, please mark your question as Solved.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

12 REPLIES 12
Highlighted
Super User III
Super User III

Re: MS Flow Approval Notification

@jaina:

 

I demonstrate one technique of sending approval reminder emails below.

My example uses a loop and an approval action in parallel.  I also use a variable.  After the approval is complete, the variable is updated to "Complete.  The loop runs in parallel with the approval and runs until the variable is equal to "Complete".

When the loop starts, it waits 5 hours.  If the variable equals "Pending", a reminder email is sent.  This will continue until action is taken on the approval.

The email should include a link to the approval center (same link for everyone).

 

Please post here if you have additional questions.

 

zReminder1.jpgzReminder2.jpg

 

If this solves your issue, please mark your question as Solved.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Highlighted
Frequent Visitor

Re: MS Flow Approval Notification

Hi @ScottShearer thank you so much for this solution! 🙂

Highlighted
Advocate I
Advocate I

a Re: MS Flow Approval Notification

@ScottShearer

This looks interesting. I have a question. I have 2 levels of approvals.. So I can not terminate the flow if first approver takes action. Also My flow loops back if 2nd approver has approved. 

 

In such cases how to exit parallel branch?

Highlighted
Regular Visitor

Re: MS Flow Approval Notification

@ScottShearer Awesome Solution! 

 

I've tried a lot of different ways and tutorials, 

This was the first that worked perfectly!

 

Tks!

Highlighted
Super User III
Super User III

Re: MS Flow Approval Notification

@SamuelFerreira

 

Thanks!

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted

Re: MS Flow Approval Notification

The only issue with this, is that your approval can have up to a 5 hour delay, as potentialy the delay just kicked in as the user approved. It will then have to wait the 5 hours before checking the loop value again and ending the loop.

Also I am not sure people appreciate getting a reminder every 5 hours.

 

An alternative is to just put a 5 minute delay inside the loop instead. Then you should place the condition after the loop and set the timeout of the loop to the amount of time you want to wait before checking to send a reminder, to avoid spamming people. You would have to do this for each reminder though.

Highlighted
Regular Visitor

Re: Flow Approval Reminder Notification every "x" hr

The problem with this solution and many I've seen similar to this is what happens if you have items after these in the flow that need to happen after approval.  The do loop has to complete and cancel out before anything else will run in the workflow.  So in a real example where the delay would be 1 or more days, if an action needs to happen after approval, it won't be hit until that delay is complete and the do loop cancels out.

There are also problems when you have multiple levels of approval needed.

MS needs to have approval reminders as part of the approval widget so they can work smarter.

Highlighted
Regular Visitor

Re: Flow Approval Reminder Notification every "x" hr

I've got this working however, I have an issue when there are multiple approvers. I already set the variable as an array which will send it to multiple reviewers (list is dependent to what company is requesting for approval). The missing part is to check whether the approver responded or not.

 

Is it possible that I will only remind the one who didn't respond yet? If yes, how can you do it?

 

Thanks!

Highlighted
Helper III
Helper III

Re: Flow Approval Reminder Notification every "x" hr

@singletrackvale , @WilliamVingaard  I have created an approach that eliminates your concerns. The status of the approval is checked every hour (for example), but the email is sent only once a day (for example). 

 

Check out how to do this in my blog https://teylyn.com/2020/01/07/timing-microsoft-powerautomate-approval-reminders/

Highlighted
Frequent Visitor

Re: Flow Approval Reminder Notification every "x" hr

I have an approval flow that send an email to approver when a new item is added into sharepoint list. I need to forward the approval  process to second approver if first appover doesn't respond after 5 days .

Please help i need urgently .

 

 

 

Highlighted
Frequent Visitor

Re: MS Flow Approval Notification

@ScottShearer 

 

Please help me !!!

I have an approval flow that send an email to approver when a new item is added into sharepoint list. I need to forward the approval  process to second approver if first approver doesn't respond after 5 days .

 

Highlighted
Helper III
Helper III

Re: MS Flow Approval Notification

@darsh Please don't ask your question in someone else's post. You will reach more people and get results faster if you start your own question.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (5,892)