Do Until Loop Control In Power Automate

Do Until Loop Control In Power Automate

No comments

In this tutorial, we’ll discuss how the Do Until loop control works in Power Automate flows. We’ll also get familiar with the needed variables along the process. 

The Do Until control in Power Automate is a loop that repeatedly forces an action until a certain condition becomes true.

Creating An Instant Flow

First, let’s create a manually triggered flow. Click Instant – from blank under New.

Do Until loop

Then, set the name to “Do Until Example. Choose Manually trigger a flow and click the Create button.

Do Until loop

Let’s add a Text input within the flow.

Do Until loop

Then add a Number input.

Do Until loop

After that, change the value of the inputs to the following.

Do Until loop

Adding A Do Until Loop In Power Automate

Let’s now add an action. Click New step.

Do Until loop

Then, click Control.

Do Until loop

Choose the Do until control.

Do Until loop

Before we execute the Do until function, let’s create a variable.

A variable is simply just a storage space for specified values.

Click the plus icon below the instant flow and click Add an action.

Then, choose Variable under the Built-in connectors.

Click the Initialize variable action.

Let’s initialize a variable called Counter and set its type to Integer. The initial value of the Counter variable should be zero.

Configuring The Do Until Loop Action

For the Do Until loop, we’re going to keep posting the message in Slack until the Counter variable becomes equal to the number that the user types in. So, let’s now add the action.

Do Until loop

Search and select the Slack connector.

Do Until loop

Choose Post message.

Do Until loop

Select budget as the channel to send the message to.

For the Message Text, choose the concat function.

Then, let’s concatenate the message itself with the counter. Under the Dynamic content tab, choose Message.

Do Until loop

Add a space and select Counter.

Lastly, click the OK button.

Incrementing The Variable

We need to increment this loop because if we don’t, it will never end. So, let’s add another action.

Select the Variable connector.

Then choose the Increment variable action.

It will require the name of the variable, which is Counter.

And we’ll increment it by one.

Now, we have everything in place. We have a trigger element to initialize a variable. It will then post a message and increment the variable to one. It will continue the cycle until the Counter variable becomes equal to the number that the user has entered.

Testing The Do Until Loop

Let’s test it to see if it works properly. Click Save.

Then click Test.

Select the I’ll perform the trigger action and click Test.

Click Continue.

Enter your message and the number of times you want it to be posted. Then click the Run flow button.

Click Done.

Upon seeing the green checkmarks, it’s certain that everything has worked properly.

As we can see, the loop iterated 10 times. For the first loop, we’ll see that the concatenated Counter value within the Message Text is 0. That’s because the initial value that we set for the variable is 0. We can then check the next loop by clicking Next.

For the next loop, we’ll see that the Counter value within the Message Text is 1. That’s because we added an increment after the first loop.

Then, we incremented the second loop again.

Therefore, the Counter for the third loop becomes 2.

The cycle will continue until the condition becomes true. In this case, it will keep going until the counter is equal to 10. And that’s how the Do Until loop works.

If we go to Slack, we should see the ten messages within the #budget channel.

The key thing to note here is we need to make sure we have a way to end our loop. If, for example, we forgot to add the incrementing of the variable, then the flow would totally fail and we would repeatedly get spammed at Slack. The output would look like this.

For instances like this, we’ll need to go back to our actual flow and select the current flow run.

Then just cancel it manually.

This will stop the spamming in our Slack channel.

Conclusion

To conclude, the Do Until loop control allows us to create iterations within Power Automate once a certain condition in our flow becomes true. There are many other scenarios where we can use this control. We can use it to remind someone every 10 minutes to approve something. We can also keep looping through until people stop submitting expense reports.

If we follow the logical approach, we can do wonders and automate many things using this control. Hopefully, you were able to clearly understand how this powerful control works in Microsoft workflows.

All the best,

Henry

***** Related Links *****
Power Automate Apply To Each Action In Workflows
Microsoft Flow Tutorial – Instant Vs. Automated Flow
Power Automate Switch Control Action In Workflows

***** Related Course Modules *****
Microsoft Power Automate Masterclass
Power Apps Masterclass
Power Platform

***** Related Forum Post Links *****
Quickbooks Desktop Connectors
SharePoint List Flow
How To Refresh My Data Automatically
For more Power Automate Connnectors support queries to review see here….

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.