Forum Discussion
Automating Reminders for Approval Flows
This was almost identical to what I was needing so i set my flow up to be the same. the only difference is that my Do Until is on the right side instead of left and I put the set variable to true after my Condition statement after starting the approval. The flow works fine except the reminders never stop coming. It's like it doesn't see the variable is set to true for some reason. I've tried butting the set variable above the Condition, in the condition and after it. I found that the Do Until variable is equal to should be just "true" and not "bool('true')" and that made it work just fine. Thank you!
Joe
I did create exactly the same flow and it works perfectly except for one thing. The do until flow runs for one last time after I approve the request and the approval variable is set to true. Technically the do until loop should not run when we approve the request and the approval variable is set to true, but somehow the loop runs one last time and send me a reminder email and closes the flow. Can someone help me understand if i am missing something here .
- I would guess your interval is rather short for testing purposes? Your interval has to be longer than your timeout.
My apologies for such a quick first reply... I now know what you mean now and fortunately I think I've found the solution. The logic in this flow is missing an important step. You see, since the Do Until is running in parallel with the Start Approval, it Must complete at least one delay loop as there is nothing telling it otherwise. Once the Do Until is started it doesn't know the condition of the Set Variable until it is done sending the email. Sooooo... there needs to be a Condition between the Delay and sending the Email. Of course you need a column in your list to compare. I have a column called Approved and it is set to Pending when item is first created. Then set to Yes if Approved and No if Rejected. My Condition says to check this column and if it is still set to Pending, THEN send the Email. I've attached what it looks like and I really hope it works. Let me know what you find! - Joe
Hi, I am sorry for the late reply. Had some busy time at office and couldnt come back here and give you an update.
I tried your first advise and yes it did work but the Do Until loop just could run once and sent only one reminder and completed the flow. I was not able to use this to send multiple reminder for the same request.
On the other side, As you suggested in your latest reply, I added a condition just after the delay. I had no issue testing however only one reminder email was sent out after 10 min delay and completed the DO Until flow. There was no second reminder sent out. I am not sure is I am doing anything wrong here.
Is there a way we can make this do until loop run and keep sending the reminder until I approve the request.
Thank you in advance.
Varun Kumar
Unfortunately this didn't work either. It simply chooses to continue running the first pass of the DoUntil regardless of the status. I even got MS on the phone and they couldn't not resolve. But not to fear, the next best solution was to simply remove the DoUntil in the first Flow and create a separate Recurrence Flow that checks the list every two days for items still in "Pending" status and then send out a reminder on those. See my image attached. This has been working just fine for me now. I just don't think the DoUntil is 100% up to par yet.
