Do Until never end

[johnjohnPter]

I have this Do Until, where i am checking if a variable named i = Frequency. but the do until never ends:-

although the Frequency is a SharePoint number field which = 5.

Any advice?

[grantjenkins]

You might have to do a conversion to ensure both are int values or both are strings. Maybe try wrapping you Frequency field to int and see if that resolves it.

[johnjohnPter]

@grantjenkins  i tried this but did not solve the issue:-

[CFernandes]

Hey @johnjohnPter 

I did a quick test...

In SharePoint by column Frequency is of type Number

In Power Autoamate the below is my configuration and it works.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

[johnjohnPter]

@CFernandes ok fine, but in my case i am incrementing the variable inside the Do Until, could this be the reason ?

[CFernandes]

@johnjohnPter - I guess so, it might count up to 5000 and then end the loop. What is the logic you are trying to achieve here? 

[johnjohnPter]

@CFernandes i have a SharePoint column named Frequency , i need to create sharepoint items equals to the number of frequency. so if i define Frequency = 5 >> to create 5 items. if i define Frequency = 10  >> to create 10 items and so on...

[grantjenkins]

@johnjohnPter Hopefully this is what you're looking for. I'm not sure what your trigger is, but I've just got a manual trigger then Get item to retrieve an item from the list. The key is to use the range expression as shown below.

//range
//first parameter is the starting number
//second parameter is how many consecutive numbers you want
//in the example below we would get an array 1,2,3,4,5
range(1, 5)

For this example, I have the following SharePoint List.

See full flow below. I'll go into each of the actions.

For this example, Get item retrieves the second item in the list that has a Frequency of 5.

Apply to each uses the following expression that will give us an array starting from 1, with consecutive numbers going up to the Frequency. Note that a Number column in SharePoint is returned as a float, so we need to convert it to an int as the range expression requires two int values. If the Frequency was 5 then our Apply to each will iterate 5 itmes.

range(1, int(outputs('Get_item')?['body/Frequency']))

Create item will run for each iteration giving you the number of items equal to the Frequency.

[CFernandes]

@johnjohnPter Can you try to test the below?

Classic Designer...

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.