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

[@tinsae.a1654]

Great video! Just what I needed. 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.

[@ashishkn95]

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

[@abhi1779]

Brilliant video. Awesome explanation

[@GaryCarmen]

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

[@DamoBird365]

Cheers Gary 👍

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

[@munkybutler1]

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!

[@patrick2131]

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

[@Wzxxx]

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]

Thank you very very much 👍

[@blessedtheotokos3899]

great! love it clear clear clear!

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

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

[@DamoBird365]

Thanks Kathleen 👍

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

[@Lamouettekamikaze]

Loving your content. Thank you.

[@joyolohita1448]

I am having the same problem of sending one message to all staff for birthday. I hope to use the video to solve my Branching issues. thanks.

[@DamoBird365]

@@joyolohita1448 let me know if it helps

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

[@adamtravers3196]

Awesome video this has just helped me so much

[@DamoBird365]

Cheers Adam - much appreciated 👍

[@pauljoneseyboy9615]

fantastic quality content, thanks so much it helped a lot

[@StephanOnisick]

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]

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

[@dianezpilon2805]

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]

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 kzbin.info/www/bejne/pqitaGage6qnerM

[@dianezpilon2805]

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

[@djjamba14]

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]

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

[@djjamba14]

@@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 👍🏼

[@AnnaMallek-Bojke]

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)"

[@Vexorgthedestroyer]

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.

[@fredericnicholson80]

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?

[@clayjames8539]

Thanks!

[@ChrisTsafos]

Thanks for putting this together! My brain hurts.😅

[@DamoBird365]

Haha. Hope it helped you. 👍

[@pprtflow]

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?

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

[@danielweikertsn1615]

Not sure how you managed to get rid of the curly braces. When i use select to extract form the source ([ [{ "name": "Monkey D. Luffy", "bounty": 1500000000 }, { "name": "Roronoa Zoro", "bounty": 600000001 }] the name i get the list/array but with the curly braces next to each name

[@DamoBird365]

I guess you’re using item() and not item()?[‘name’]

[@danielweikertsn1615]

@@DamoBird365 no i am using item()?['name'] Strange that i still get the { } But thanks for your answer

[@DamoBird365]

Are you looking for an array of names? Or key : value pairs? If it’s just names, remove your key values and toggle to Text mode and reinsert your expression.

[@danielweikertsn1615]

@@DamoBird365 yes only the names but the text mode requires me to insert valid json and does not allow only the item expression

[@DamoBird365]

@danielweikertsn1615 you can have a single name in text mode or you need to add them to an array or object.

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

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

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

[@lokeshgovindharaj1367]

Power automate cloud excel how to check each column Kindly advise Thank you

[@DamoBird365]

Hi Lokesh, I don’t understand your question? Can you rephrase? I would otherwise definitely recommend the forum powerusers.microsoft.com/

[@joyolohita1448]

ActionBranchingConditionNotSatisfied The execution of template action 'Send_an_email_from_a_shared_mailbox_(V2)' skipped: the branching condition for this action is not satisfied. kindly guide me because it is making me unhappy