Easily Avoid Apply to Each Loops | Power Automate

This video is to show you just how easy it is to avoid Apply to Each loops in Power Automate. You no longer have to cycle through time-consuming processes that you can simply avoid and speed up your flows. I'll show you just how simple it is to get the first and/or subsequent rows without needing the apply to each action.
#powerautomate #powerplatform #dataverse
Chapters:
00:00 - Why would we do this?
00:30 - A walkthrough of the problem
01:46 - How to get the first row and specific column
6:32 - How to get subsequent rows and specific columns
9:55 - Deleting that annoying Apply to Each!

[@imstillbreathing1]

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

[@FlowJoeVideos]

You are so welcome!

[@dgpblogster]

Brilliant as always! Thanks for sharing

[@FlowJoeVideos]

Thank you!!

[@ZePowerDiver]

Practical and easy, thanks Joe!

[@FlowJoeVideos]

Thanks for the comment!

[@franknielsen3219]

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

[@FlowJoeVideos]

Happy to hear that!

[@philippvanderheide7494]

You deserve yourself a sub :)
Great explanation!

[@FlowJoeVideos]

Thank you!

[@nikolaidedenkov8414]

Great one, appreciate it a lot!

[@FlowJoeVideos]

Glad it helped!

[@hidayaths6718]

Great vedio Thank you Joe

[@hidayaths6718]

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

[@yambodji]

good job!

[@FlowJoeVideos]

Thank you!

[@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.

[@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.

[@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" 💪