Easily Avoid Apply to Each Loops | Power Automate

[@imstillbreathing1]

Thanks for sharing this! It took me forever to figure this out when I first started writing flows!

[@FlowJoeVideos]

You are so welcome!

[@franknielsen3219]

Very nice video Joe. Like your videos. Very easy to understand 😊😊

[@FlowJoeVideos]

Happy to hear that!

[@club-crm1080]

Excellent! very, very clear explanation!! Thanks a lot and congratulation for your work! (I'm already subscribed!)

[@dgpblogster]

Brilliant as always! Thanks for sharing

[@FlowJoeVideos]

Thank you!!

[@philippvanderheide7494]

You deserve yourself a sub :) Great explanation!

[@FlowJoeVideos]

Thank you!

[@ZePowerDiver]

Practical and easy, thanks Joe!

[@FlowJoeVideos]

Thanks for the comment!

[@nikolaidedenkov8414]

Great one, appreciate it a lot!

[@FlowJoeVideos]

Glad it helped!

[@AmyCustomer]

Thanks, new sub here! This is a great static example but what would you do if you did not know the order in the table, or say you did a get items and used a filtered array so you wouldn't know what order they were in? Thanks in advance. Cheers!!

[@hidayaths6718]

Great vedio Thank you Joe

[@hidayaths6718]

Can you please help me how to debatch json file ( multiple employees records) in power automate.

[@bobbirowlett6728]

Thanks Joe - was easy to understand. Can you still avoid the apply to each if you want all the values returned by the list rows to be available in following steps?

[@smoeyjoe4781]

When you type [Number] it specifically gets that row, however, you still have access to all the items returned by simply removing that.

[@yambodji]

good job!

[@FlowJoeVideos]

Thank you!

[@toneyrambau7169]

Hi, what approach would you take to find the row with the dog named Luna in a table with 1000 rows when you're unsure of its position?

[@FlowJoeVideos]

Is it in dataverse or a different data source?

[@toneyrambau7169]

@@FlowJoeVideos it is dataverse

[@prkchpsnaplsaws2322]

Dang I was hoping for an answer to this... This is exactly my dilemma... How often would you know which row the form submission would even be referencing? That seems very out of place when using automation

[@FlowJoeVideos]

@@prkchpsnaplsaws2322 You can add a filter on the retrieval of data from dataverse that applies to what you're trying to achieve. i.e. filter the name column for luna so you would only have a list of dogs named that, but that would be applied before you even got to an apply to each

[@rezahusen1015]

Sir I have a question there is, I want make approval flow from MS from but data approver is from excel I already know how to make the flow, but why my action apply to each just read 256 data from my excel?. Thank in advance

[@smoeyjoe4781]

So are you looking to pull each item from excel and cycle through each to send the email? You will need to decide if you want an approval for each or batch them together and approve /decline them all, you could use adaptive cards to handle this.

[@abhi1779]

Amazing

[@smanzoli]

I use Power Automate Desktop and it's a 100% different app... it's crazy Microsoft has created 2 completely different versions of the same app

[@FlowJoeVideos]

Power automate desktop and cloud are the same brand but one is API cloud based and one is RPA. Power Automate and Power Automate Desktop are two different products under the same branding, they’re not so much different versions but rather different products for different purposes.

[@scottthompson4513]

I'm super annoyed that PA automatically creates the loop without asking. when I'm trying to use a "join" or something on a collection it instead creates a loop, and the only way to avoid it is to manually type out the action name. So stupid, ticks me off every time....and with there not being an "undo" capability, then it totally screwws up your flow

[@FlowJoeVideos]

It’s annoying sometimes, however you can modify the action that has had the loop auto-added to do something similar to what I e done then drag that action back out of the loop. You can then delete it as a work around.

[@demarc2911]

"promo sm" 💪