cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jaina
Level: Powered On

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
Super User
Super User

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

8 REPLIES 8
Super User
Super User

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

jaina
Level: Powered On

Re: MS Flow Approval Notification

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

PrasadAthalye
Level: Powered On

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?

SamuelFerreira
Level: Powered On

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!

Super User
Super User

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
WilliamVingaard
Level: Powered On

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.

singletrackvale
Level: Powered On

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.

joberagcanas
Level: Powered On

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!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users Online
Currently online: 312 members 5,769 guests
Please welcome our newest community members: