Recently, I was creating a new flow to use as a approval flow following a simples list on my SharePoint.
The ideia is, while an item is with "Pending" or "Select" value, the loop makes a follow up every 1 hour (at the screenshot is 30s jut to test), but after I change the field to another option, the loop continous and don't get out of it. I've been tried a lot of different ways, and get only to ways:
#1 the loop goes forever, and the value that I change is irrelevant
#2 the loop repeat just 1 time and goes out of it
I guess the dynamic content "Capacity requir..." evaluated in the Do Until is taken from the Trigger and is not updated, unless you declare a variable before the do until, initialize it with the value coming from the trigger, use this variable in the Do Until instead, include inside the Do Until a Get item, then set the variable value to the dynamic content "Capacity requir..." obtained from "Get item".
In such a case, I would also move "Send email" after the Do Until, ensuring it is executed due to the status changed, and not due to Do Until reached any of the limits.
Hope this helps
The “Do Until” action would be executed only when “When an item is created” trigger is triggered. You change the field to another option means that you update the item in SharePoint list, but the “Do Until” action would not be triggered again, the field value would not be updated and the “Do Until” action would be exeuted every 1 hour.
You could consider change the “When an item is cretaed” trigger into “When an item is created or modified” trigger, the “Do Until” action would be executed when the item is created or modified in SharePoint list, but it would arise another flow run. You shoud view another flow run rather than previous one to check if the loop has gotten out of it.
Your suggestion doesn't work for me, I've tested this but when I change the value, a new flow is created and I can't leave that.
Above is the new flow that I create. When I create a new item, the flow goes to the IF Yes condition because the value is empty and makes a loop, but when I change the value, a new flow starts and goes to IF No because now the field is filled properly but my point is, the old flow still running. The correct flow is the "Do until" field needs to continuous validate the specific field and go out if the condition is false and this thing don't happen
Look out for new contribution recognition badges coming SOON!
Join us for the first ever Power Platform Online Conference!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!