For Each - INCREASE CurrentItem variable without reaching END step

(0) Share

Report

Posted on by Davidx23

145

Good day Everyone,

First, is this possible?

I'm trying to update something and i wanna do it through PA, everything is perfect just one step away from heaven.

The CurrentItem does not increase because it doesn't reach the END action because i placed a 'EXIT LOOP' right behind it. Is it possible to increase? or there's another way to make it without using foreach?

Please help.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

UK_Mike on at

Like (0)

Report

Remove the " exit loop " surely ? then it will iterate through list...

Was this reply helpful? Yes No
Davidx23 145 on at

Like (0)

Report

UK_Mike

Thing is i need to match the ID value with the CurrentItem Value in order to update it in DB.

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report

Well ive no idea about Sql but that flow is doing exactly what you said to do, Exit the loop after 1 iteration.
You could try a regular loop, specify the times to loop or loop to the List.count...

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report

Are you saying Exit Loop is taking it out of both loops, and not just the second Loop?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report

Next takes is to the Next iteration, but End naturally does the same thing.
Example:

For each
'Do something
Next
End

For Each
'Do something
End

They are the same thing. Next is typically used when you are trying to skip the rest of the steps in the loop based on a conditional statement.
Ex.
For each
If %CurrentItem.Name% = John
Next
End (if)
'Do something (will only occur if %CurrentItem.Name% is not John)
End (for each)

Exit Loop cancels out a loop completely, so as I read it, you are telling it to only iterate once on the second loop, because you are telling it every time to exit this loop.

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report

Just had a second glance at the screenshot, If theres only 1 file in the current item it would end anyway...🤔

Was this reply helpful? Yes No
Verified answer

Davidx23 145 on at

Like (0)

Report

Guys,

I did find the solution by my own, just rebuilt the flow and make the consult in a Store Procedure by its row's ID, updated the same way and that was bbq chicken.

Thanks anyway and i'll share the flow if may be helpful for someone else.

Was this reply helpful? Yes No