cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaina
Responsive Resident
Responsive Resident

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
ScottShearer
Most Valuable Professional
Most Valuable Professional

@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

16 REPLIES 16
ScottShearer
Most Valuable Professional
Most Valuable Professional

@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

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

@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?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

@ScottShearer Awesome Solution! 

 

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

This was the first that worked perfectly!

 

Tks!

@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
Anonymous
Not applicable

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.

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.

Anonymous
Not applicable

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!

@singletrackvale , @Anonymous  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/

darsh
Frequent Visitor

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 .

 

 

 

@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 .

 

@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.

 

i have created function to setup reminder email, and one question is can i get  approval link at reminder email content?

ScottShearer
Most Valuable Professional
Most Valuable Professional

@hong_yip 

It would be best if your were to start a new post with your question.  When you post, please include a screen shot of your Flow.

 

 

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

Scott
mcmoney29
Regular Visitor

This seems like an old thread but I found a much simpler way to renotify users for approvals if anyone is still looking:

 

1. Initialize a Boolean variable as a success flag that raises when an approval is completed (either approved or rejected). This variable can be reused for each approval.

2. Then put your approval inside a 'Do Until' loop.

3. Add two set variables after the approval but still inside the loop (as shown in picture). The first one sets the success flag to FALSE and the second to TRUE.

mcmoney29_0-1682511414238.png

4. Go to the approval's settings and change the timeout duration to however long you want before the user is reminded using ISO 8601 Format.

mcmoney29_2-1682511642677.png

5. Go to 'configure run after' for 'Set False' action and set it to run only if the approval times out.

6. Go to 'configure run after' for 'Set True' action and set it to run only if 'Set False' is skipped.

mcmoney29_3-1682511795710.png

 

And that's it! If the approval is not completed within the timeout duration then the flag will be set to false and the loop will repeat, sending another approval. When a new approval is sent the old one still exists but won't affect the flow if accepted/rejected. (i.e. user can only accept most recent approval sent to them).

 

 

 

hello, can you share the expression for true at Success Flag is equal to true part?

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22   Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2   Anil_g2   SharonS2  

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (2,135)