Forum Discussion
Automating Reminders for Approval Flows
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
- Joseph CollinsFeb 05, 2018Brass Contributor
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.
- Varun Venkatesh KumarFeb 09, 2018Copper Contributor
Hi Joe,
That flow worked beautifully. Thank you very much for the help.
Thank you
Varun Kumar
- Luc LabelleMar 06, 2018MVP
Great post !