What happens if you set the Delay to one day and the user responds to the approval in the middle of all that? Does the loop break immediately? Or will it still finish the delay duration before it breaks the loop?
Hi Brian than you for this, it was really helpful. i have multiple approval stages, would i create a branch for all of them or just set the variables to be true at the end of all the approvals?
Hey there! Nice video! Iv an doubt, about the approval process in power automate, is possible works with the field of approver empty. For example, i'v 2 step of approval, but i wnat that the second step only be tarted when the first step of approval is equal "approve or empty". Its possible?
Thanks Brian, that was clear and informative. It also solved my problem. Is there any way to add a link back to the original approval email that you can think of?
Actually, on second thought, I forgot you can actually get the Response LInk field from the approval to give the user a direct link after the fact. This can be accessed by breaking your approval up into a Start Approval and Wait for Approval actions.
Hi, thanks for this simple video, I've done similar flow work, but when I am choosing the reminder delay to be 1 day, it is not sending the next day, but if I choose 1 minute it works.
Hello M H, I am sure by now you already figured out the issue, but in case anyone else ever comes across the same problem: When you choose Do Until, you can actually change the settings. By default, it should be set to Count 60 and Timeout PT1H. This means, that the Do Until will either stop after 60 times it ran or after PT1H while PT1H stands for 1H, you can change those settings to make your Flow according to your needs. For any additional information on this topic, just search for "Power Automate - Do Until Change Limits". R&Y
Hi, I need some assistance. I attempted to implement the 'Do Until' loop with delay and condition controls, similar to your example. My goal is to automate daily email reminders (up to a maximum of 30 days) to users/approvers with pending approvals. However, despite my efforts, the user/approver only receives one email reminder. Here's a summary of my trials: -In the first trial, a delay of 30 minutes worked well, promptly sending an email to my approver reminding them of pending approvals. -In the second trial, using a delay of 1 day, only one email reminder was sent, and none were sent until now. -During the third trial, with a delay of 28 days, no email reminders were received, as I initiated the flow on April 8th. All this trials are initiated on April 8. Hope you can help me, thank you.
@@PragmaticWorks I had followed all the steps mentioned above and found that the first-time approval emails come but reminder emails don't work. But flow is running.
Hi Brian, thanks for this? I have a pretty complex flow where the Approval actions are sitting inside an "Apply to each". I noticed we cant insert variable into these - what would you suggest?
Hi Brian, thanks, very clear! Just one question, how would it be if I have several approvers (one approves, then goes to another person to approve, etc). I can't have initiate variable for each, right? Thanks!
If someone approves it before the Delay step finishes, the flow will continue running until the delay step is completed. If you had a delay of 2 weeks or 1 month, that's a long time for the flow to be running.
@@PragmaticWorks I want to send a reminder every week for 2 times max with a timeout of 14 days. The first step is a 7 days delay. If the approver already approved it during the first day of the delay, my flow has to wait another 6 days before it can continue. Is there anything to do about it? I want the do until loop to stop immediately and continue the flow.
I tried this and if I approve before the reminder is sent out, the next action will not happen until the delay time is done. So this didn’t work for me :( . Does anyone have any ideas ?
This is a major drawback with this method. The need to wait for the reminder period even if a response was received after 5 minutes. This functionality really should be built in.
Hi Brian, Can you please make video on making Organization chart in power apps with the functionality of showing the count of male and female candidate Under a manager depending on the current selected Manager
Why has it taken me until now to realise the value of "Do Until" :D Legend Brian, thanks dude
I was looking for this solution for a long time. Thanks!
Thank you so much Brian! It is a very simple solution for approval reminders. You rock!
Happy to help!
Sir , i can't Thank you enough for this video , i spent days looking for this solution , you are A LEGEND ♥, Subscribed :D
Thank you Brian! Very nice approach! Great work!
Thank you very much. This is a very good solution!
Awesome content as always Brian!
Thanks for the demo Brian. LOL Status = "You Suck" at the 7:25 mark. That sounds like a test that I would run to entertain myself.
LOL. I forgot I had that test record in there :). Got me - Brian
What happens if you set the Delay to one day and the user responds to the approval in the middle of all that? Does the loop break immediately? Or will it still finish the delay duration before it breaks the loop?
Thank you
Hi Brian than you for this, it was really helpful. i have multiple approval stages, would i create a branch for all of them or just set the variables to be true at the end of all the approvals?
Thanks , good example
You're welcome! Glad you enjoyed it!
Hi Brian, thanks a lot. So how about if I want to skip to the next approver if it timed out?
Shouldn't the second step by "Start and Wait for an approval"? Otherwise, won't the variable be set to true before we receive a response?
Hey there! Nice video! Iv an doubt, about the approval process in power automate, is possible works with the field of approver empty. For example, i'v 2 step of approval, but i wnat that the second step only be tarted when the first step of approval is equal "approve or empty". Its possible?
Brilliant!
Thanks Brian, that was clear and informative. It also solved my problem. Is there any way to add a link back to the original approval email that you can think of?
You could if you query the tables that store the approval.
Actually, on second thought, I forgot you can actually get the Response LInk field from the approval to give the user a direct link after the fact. This can be accessed by breaking your approval up into a Start Approval and Wait for Approval actions.
THank you for the Video, I have tried in Switch cases but after adding reminder of one day, it doesn't move to the next case
Hi, thanks for this simple video, I've done similar flow work, but when I am choosing the reminder delay to be 1 day, it is not sending the next day, but if I choose 1 minute it works.
Hello M H, I am sure by now you already figured out the issue, but in case anyone else ever comes across the same problem:
When you choose Do Until, you can actually change the settings. By default, it should be set to Count 60 and Timeout PT1H.
This means, that the Do Until will either stop after 60 times it ran or after PT1H while PT1H stands for 1H, you can change those settings to make your Flow according to your needs.
For any additional information on this topic, just search for "Power Automate - Do Until Change Limits".
R&Y
Thank You!
You're welcome!
Hi Brian, Why are you creating a parallel branch for reminder notification ? Can we not do in the same branch or sequence of steps ?
One branch is asking for the approval and the other parallel is doing reminding. If you merged it, it wouldn't fire the right timing on the reminders.
I'm definitely struggling with how to do this for multiple approvals in a row, with an approve or reject email after each.
Hi, I need some assistance. I attempted to implement the 'Do Until' loop with delay and condition controls, similar to your example. My goal is to automate daily email reminders (up to a maximum of 30 days) to users/approvers with pending approvals. However, despite my efforts, the user/approver only receives one email reminder.
Here's a summary of my trials:
-In the first trial, a delay of 30 minutes worked well, promptly sending an email to my approver reminding them of pending approvals.
-In the second trial, using a delay of 1 day, only one email reminder was sent, and none were sent until now.
-During the third trial, with a delay of 28 days, no email reminders were received, as I initiated the flow on April 8th.
All this trials are initiated on April 8.
Hope you can help me, thank you.
Very nice Mr. Brian, I was wondering if you can confirm that multiple approvals also will work.
Yes, absolutely. You can send them in one approval or stack them.
@@PragmaticWorks I had followed all the steps mentioned above and found that the first-time approval emails come but reminder emails don't work. But flow is running.
It is working, Thanks
Hi Brian, thanks for this? I have a pretty complex flow where the Approval actions are sitting inside an "Apply to each".
I noticed we cant insert variable into these - what would you suggest?
how do create the reminders for the following approval in the same flow
Hi Brian, thanks, very clear! Just one question, how would it be if I have several approvers (one approves, then goes to another person to approve, etc). I can't have initiate variable for each, right? Thanks!
You would have multiple branches at each approval stage
Hi, does this method work for sequential approval type?
Sure, you can string approvals together at "this time" however more coming soon to help that scenario.
@@PragmaticWorks good to hear, please do a video for sequential approval reminder. It's the project that I'm working on.
Even if I approve in time It is sending reminder email. Could you please help on this.
If someone approves it before the Delay step finishes, the flow will continue running until the delay step is completed. If you had a delay of 2 weeks or 1 month, that's a long time for the flow to be running.
Yes of course. Totally customize the pattern to your own business case but you're right.
@@PragmaticWorks I want to send a reminder every week for 2 times max with a timeout of 14 days. The first step is a 7 days delay. If the approver already approved it during the first day of the delay, my flow has to wait another 6 days before it can continue. Is there anything to do about it? I want the do until loop to stop immediately and continue the flow.
I tried this and if I approve before the reminder is sent out, the next action will not happen until the delay time is done. So this didn’t work for me :( . Does anyone have any ideas ?
This is a major drawback with this method. The need to wait for the reminder period even if a response was received after 5 minutes. This functionality really should be built in.
Hi Brian, Can you please make video on making Organization chart in power apps with the functionality of showing the count of male and female candidate Under a manager depending on the current selected Manager
Good idea, but I don't have premium license :(