Power Automate | Apply to Each | Why?

Power Automate | Apply to Each | Why? | Arrays and Objects

Рет қаралды 36,371

Күн бұрын

This video demonstrates how to use Power Automate to work with arrays and objects from SharePoint lists. It covers the concepts of get item, get items, apply to each, select, join, and expressions. It also shows how to avoid or understand common errors and how to manipulate data efficiently.
[00:00:00] The purpose and overview of the demonstration
To show how to avoid or understand apply to each
To use expressions, select, and join actions
To work with people pickers and multiple choice fields
[00:00:41] The SharePoint list and its columns
A list of 10 items with various columns
Industry column is a choice type with multiple selections
Account manager column is a people picker with multiple selections
[00:01:37] The get item and get items actions
Get item returns a single item from a list
Get items returns a table of data from a list
The output of each action and how to examine the JSON
[00:03:54] The apply to each and compose actions
How to use compose to output dynamic values
How to use apply to each to loop through an array
How to examine the expressions and understand the syntax
[00:06:35] The variable and append to string actions
How to use variable to store a string
How to use append to string to add values to the string
How to compare the efficiency of variable vs select
[00:08:12] The select and join actions
How to use select to filter an array and output only the values
How to use join to combine the values of an array into a string
How to avoid the extra semicolon at the end of the string
[00:11:46] The first expression and integer indexes
How to use the first expression to get the first object from an array
How to use integer indexes to get a specific object from an array
How to avoid the error of selecting values from an array
[00:15:46] The industry column and multiple choice values
How to use the industry column as an input to an apply to each or a select
How to use the value key to get the values of the multiple choice field
How to use the join expression to create a string of the values
Other JSON related videos:
• How to write expressio...
• JSON Array in Power Au...
Please buy me a coffee www.buymeacoffee.com/DamoBird365 ☕

Пікірлер: 59

@blessedtheotokos3899 15 күн бұрын

great! love it clear clear clear!

@ashishkn95 28 күн бұрын

I love you! This is exactly I was looking for! Thank you!

@markweyman Жыл бұрын

Thanks for covering this topic, it’s something I often struggle with and will be bookmarking this so that I can go back over the lessons you’ve covered today.

@DamoBird365 Жыл бұрын

Cheers Mark.

@munkybutler1 6 ай бұрын

Brilliant video Damo, makes things a lot clearer. I will be bookmarking this 😊

@einfachmachengmbh Жыл бұрын

Great Video! Gave me a good understanding preventing some annoying Loops. Thanks Damien!

@abhi1779 29 күн бұрын

Brilliant video. Awesome explanation

@patrick2131 Жыл бұрын

Excellent! I really like how you're focusing on Power Automate topics. Very helpful (and I am subscribed🙂)!

@GaryCarmen Жыл бұрын

I will be sharing this video with our Power Automate users. Great video, thanks Damien

@DamoBird365 Жыл бұрын

Cheers Gary 👍

@Lamouettekamikaze Жыл бұрын

Loving your content. Thank you.

@emmanuelmaceda2475 Жыл бұрын

Great vid as usual! I also rarely use the Join data operation because often times, the requirement is to return unique values from an array. I use the join in conjunction with union to perform such tasks. Have a great weekend!

@DamoBird365 Жыл бұрын

I see you’ve watched it 👍 I’m definitely more a fan of expressions but happy to sneak a extra action in there for the demo. Union is great for distinct values or bringing arrays together for sure. Thanks again Emmanuel.

@pauljoneseyboy9615 8 ай бұрын

fantastic quality content, thanks so much it helped a lot

@clayjames8539 Жыл бұрын

This is a super helpful video. I was having difficulty with multiple value people columns and incorporating them in power automate. For example, I couldn't get it to send just one email to the multiple people as recipients listed in the item column.

@DamoBird365 Жыл бұрын

Nice one Clay, delighted you found this video as I only recorded it last weekend. I really hoped it would help folk out. Thanks for letting me know. 👍

@kathleencarrao9356 3 ай бұрын

Thank you so much, it helped me a lot!!

@DamoBird365 3 ай бұрын

Thanks Kathleen 👍

@user-qm8kf2ko2g 6 ай бұрын

thank you for the video! my questions is how can I take from value in jeson file, when I dont have dynamic function "value"? unfortunately our SharePoint using library, not list. I use "get file properties" "when an item or file is modifie" because Cant use "get item(s)"

@clayjames8539 Жыл бұрын

Thanks!

@Wzxxx 3 ай бұрын

Thank You so much. I do Power BI stuff but sometimes Automate is helpful but absolutely counter intuitive for a user. All of my collogues just resign for using it. Simple ideas take hours to implement without a real knowledge. Simple task and you need to know the language which is not explained anywhere. All these ?, () and strange code. Need to build some iteration in order to GET items from API. Nice tutorial. After all tutorials from You it will be much easier to go through that nightmare.

@DamoBird365 3 ай бұрын

Thank you very very much 👍

@ricardobunge5957 Жыл бұрын

Love the shirt - it's brilliant!

@DamoBird365 Жыл бұрын

Microsoft were giving them away at events but a kind colleague sent me it for raising her awareness of Graph API. I love it too 👍

@UncleBubba Жыл бұрын

Nice clear explanation. Thanks.

@DamoBird365 Жыл бұрын

Thanks Matt - you are pretty impressive on the guitar and harmonica 😎 thanks for stopping by 👍

@UncleBubba Жыл бұрын

@@DamoBird365 Thank you :D And thanks for taking the time to visit my channel and listen. Glad you liked it

@adamtravers3196 8 ай бұрын

Awesome video this has just helped me so much

@DamoBird365 8 ай бұрын

Cheers Adam - much appreciated 👍

@djjamba14 3 ай бұрын

Fabulous video! Is there a way to use the same technique but for multiple records (Get ItemS) and not just one person column from one record (Get Item)? i.e. do you know if there's a way of plucking out a single column from an array of objects that's already inside the Select with a bunch of other mapped values?

@DamoBird365 3 ай бұрын

Yes there is 👍👍 with Xpath. I have an example here 👉 Boost Your Power Automate Skills with Complex Arrays, Select, XML, and Join Techniques kzfaq.info/get/bejne/l8yhqapyx5iUdKs.html

@djjamba14 3 ай бұрын

@@DamoBird365 - Thanks for the fast reply! Yes, someone had mentioned I should look at xml and xpath but I haven't got there yet so hopefully you will save me a ton of research 😃 Will check your link out and thanks again 👍🏼

@fredericnicholson80 9 ай бұрын

Thanks for this video. I encountered one trouble maker for apply each: List files in folder! any tips on how to approach these two together?

@MusicHitsNumberOne 5 ай бұрын

Hello! Tks for your video! I'v the issue "The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array." when i use the update item with the field responsible in sharepoint of type person or group. How to fix this issue please?

@StephanOnisick 11 ай бұрын

Great Explanations. One Question: When I am doing a test and I don't want to go through the entire number of items, how do I create a variable that only gets a few items of that value array?

@DamoBird365 11 ай бұрын

take() learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#take

@ChrisTsafos 11 ай бұрын

Thanks for putting this together! My brain hurts.😅

@DamoBird365 11 ай бұрын

Haha. Hope it helped you. 👍

@niclaatz Жыл бұрын

I would really love to see a video on how to append existing file names in SharePoint if the filename already exists. I am really struggling with this, and I just want to append the file name with (1),etc. like Windows does.

@DamoBird365 Жыл бұрын

Do you want to create a new version if it already exists? I’m curious.

@PUNITHBG Жыл бұрын

Is there any to get all multiselect people value through expression other than integer method or apply toeach?

@DamoBird365 Жыл бұрын

You can use select action. The name of the multi select is the input, then turn on text mode via icon to n right, then select the value. That will give you an array of values which you can then join.

@geralddahl9159 Жыл бұрын

Thx for covering index by integer and array issues. I’m sure you’ve done this, namely, handling nulls?

@DamoBird365 Жыл бұрын

Hi Gerald, you can insert a ? Into any level of an expression so that if it’s not found it returns null. The flip side is, if you don’t include a ? the expression will fail, as will your flow. I agree that I’ve demo’d it somewhere. 10 points if you know what video and can share a link 😂

@geralddahl9159 Жыл бұрын

At first I thought item()?[‘Student’] would work but I think it has to be item()?[0]?[‘Student’] etc. Such a relief to overcome failure due to null. Not sure if you’re a curling fan but Scotland and Canada might meet in World Championships this weekend in Ottawa. I often Power Automate while viewing a slow moving sport to glance at while test flows run. Bottom line, the flow skills I’m gathering help a lot at work. Happy Easter - I’m grateful for Christ’s atoning love.

@dianezpilon2805 5 ай бұрын

This was a helpful video. Question, I have an issue where whenever I compose an array, it multiples the result by the total. In you example you had 10 Company names. For me, my output would be an array where a single company name is listed 10 times. So there there are 100 items; Company A listed 10 times, Company B listed 10 times, and so on. How do I prevent this? My goal is to concatenate several values in a single SharePoint record into a single string. In other words, create a calculated column value for each record in a SharePoint list using Power Automate. Thank you

@DamoBird365 5 ай бұрын

I think you want to use union and filter array. Something a bit like : Transform Excel Data into HTML Table and Email: Power Automate #PowerAutomate #Outlook kzfaq.info/get/bejne/pt16apabq6vYdIU.html

@dianezpilon2805 5 ай бұрын

@@DamoBird365 Thank you so much for your reply! I'll check it out!

@surajdevasthali6107 Жыл бұрын

Hi Thanks for this Video but I still did not get how to extract Manager DisplayName from multiple manager field and put into HTML Table for per record

@DamoBird365 Жыл бұрын

It would be worth asking on the forum powerusers.microsoft.com/ and provide more detail on what you’ve tried 👍

@elcoquirivera4503 Жыл бұрын

I just started to learn powerauto for an automated Excel to Sharepoint flow. Do you have any courses for sale?

@DamoBird365 Жыл бұрын

I don’t but maybe I need to look into that one day. Where do you usually learn?

@elcoquirivera4503 Жыл бұрын

@@DamoBird365 Primarily Udemy and Coursera.

@nathandowling-justice8609 Жыл бұрын

Sounds good....but moving waaaaay too fast for me to make sense of it....I think i'm more at the beginner/curious and experimenting stage....

@DamoBird365 Жыл бұрын

Make sure you bookmark it and come back when you’ve started getting nested apply to each actions 👍 if you think there’s a need for a video as a newbie, give me a shout.