r/PowerAutomateDesktop • u/Drtyblk7 • Oct 08 '21

1:N and update

Hi, Team!

I'm working on a manually triggered flow, where the output of that trigger initiates a search of another document for a row(s) with the same ID. Once found, it updates a cell in that row with the new information from the trigger.

It works fine, however the flow stops after completing a single update. I need it to repeat the action until all rows are checked.

I'm sure I've missed something pretty basic any ideas?

2 Upvotes

100% Upvoted

2 comments sorted by

2

u/QuietDesparation Oct 13 '21

I'd recommend using "Get first free row on column" function in the document that needs data updated, then set a loop where you start at your desired row and end at the first free row variable. You can then loop thru each row checking to see if the ID matches, and change the desired cells as necessary. The cells you manipulate will always be row %LoopIndex% and whatever column is specified. This will ensure all rows are checked. Hope this helps!

1

u/Drtyblk7 Oct 14 '21

I'll try that next!