Easily Avoid Apply to Each Loops

No video

Easily Avoid Apply to Each Loops | Power Automate

Рет қаралды 11,833

Күн бұрын

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!

Пікірлер: 28

@imstillbreathing1 Жыл бұрын

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

@FlowJoeVideos Жыл бұрын

You are so welcome!

@AmyCustomer 9 күн бұрын

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!!

@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!

@ZePowerDiver Жыл бұрын

Practical and easy, thanks Joe!

@FlowJoeVideos Жыл бұрын

Thanks for the comment!

@abhi1779 5 күн бұрын

Amazing

@dgpblogster Жыл бұрын

Brilliant as always! Thanks for sharing

@FlowJoeVideos Жыл бұрын

Thank you!!

@nikolaidedenkov8414 Жыл бұрын

Great one, appreciate it a lot!

@FlowJoeVideos Жыл бұрын

Glad it helped!

@hidayaths6718 8 ай бұрын

Great vedio Thank you Joe

@hidayaths6718 8 ай бұрын

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

@bobbirowlett6728 9 ай бұрын

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 8 ай бұрын

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

@yambodji 11 ай бұрын

good job!

@FlowJoeVideos 11 ай бұрын

Thank you!

@rezahusen1015 11 ай бұрын

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 8 ай бұрын

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 4 ай бұрын

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 4 ай бұрын

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.