I’ve got a favour to ask! If you enjoy this, please double check that you’ve liked the video and subscribed to the channel! Thats a small way you can help me carry on doing this ❤🙏🏾 really appreciate you! 🩷 Subscribe: th-cam.com/users/DamoBird365 ☕ BuyMeACoffee: buymeacoffee.com/DamoBird365 🔗 LinkedIn: linkedin.com/in/DamoBird365 🐦 X (Twitter): x.com/DamoBird365 📱 TikTok: tiktok.com/@DamoBird365 🙋♂ Feedback: forms.office.com/r/4EqE7VHVfH
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.
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!
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.
Quite helpful. Thanks for sharing this with everyone :-) The question I have is, how would you then generate a company/industry relation from the sharepoint list, assuming a there were multiple industries and a company was in multiple industries?
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.
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?
Yes there is 👍👍 with Xpath. I have an example here 👉 Boost Your Power Automate Skills with Complex Arrays, Select, XML, and Join Techniques th-cam.com/video/afqvGAb20Dw/w-d-xo.html
@@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 👍🏼
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)"
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.
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.
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
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 th-cam.com/video/pwJ73jFEtDQ/w-d-xo.html
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?
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
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.
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?
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.
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 😂
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.
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.
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
I’ve got a favour to ask! If you enjoy this, please double check that you’ve liked the video and subscribed to the channel! Thats a small way you can help me carry on doing this ❤🙏🏾 really appreciate you!
🩷 Subscribe: th-cam.com/users/DamoBird365
☕ BuyMeACoffee: buymeacoffee.com/DamoBird365
🔗 LinkedIn: linkedin.com/in/DamoBird365
🐦 X (Twitter): x.com/DamoBird365
📱 TikTok: tiktok.com/@DamoBird365
🙋♂ Feedback: forms.office.com/r/4EqE7VHVfH
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.
Cheers Mark.
beautiful explanation. thank you
Great video! Just what I needed. Thank you!
I will be sharing this video with our Power Automate users. Great video, thanks Damien
Cheers Gary 👍
Brilliant video. Awesome explanation
Brilliant video Damo, makes things a lot clearer. I will be bookmarking this 😊
I love you! This is exactly I was looking for! Thank you!
Great Video! Gave me a good understanding preventing some annoying Loops. Thanks Damien!
Excellent! I really like how you're focusing on Power Automate topics. Very helpful (and I am subscribed🙂)!
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!
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.
Quite helpful. Thanks for sharing this with everyone :-) The question I have is, how would you then generate a company/industry relation from the sharepoint list, assuming a there were multiple industries and a company was in multiple industries?
Thanks!
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.
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. 👍
Nice clear explanation. Thanks.
Thanks Matt - you are pretty impressive on the guitar and harmonica 😎 thanks for stopping by 👍
@@DamoBird365 Thank you :D And thanks for taking the time to visit my channel and listen. Glad you liked it
Thank you so much, it helped me a lot!!
Thanks Kathleen 👍
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?
Yes there is 👍👍 with Xpath. I have an example here 👉 Boost Your Power Automate Skills with Complex Arrays, Select, XML, and Join Techniques
th-cam.com/video/afqvGAb20Dw/w-d-xo.html
@@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 👍🏼
Loving your content. Thank you.
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)"
great! love it clear clear clear!
Is there any to get all multiselect people value through expression other than integer method or apply toeach?
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.
fantastic quality content, thanks so much it helped a lot
I just started to learn powerauto for an automated Excel to Sharepoint flow. Do you have any courses for sale?
I don’t but maybe I need to look into that one day. Where do you usually learn?
@@DamoBird365 Primarily Udemy and Coursera.
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.
Thank you very very much 👍
Awesome video this has just helped me so much
Cheers Adam - much appreciated 👍
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
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
th-cam.com/video/pwJ73jFEtDQ/w-d-xo.html
@@DamoBird365 Thank you so much for your reply! I'll check it out!
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?
take() learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#take
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
I guess you’re using item() and not item()?[‘name’]
@@DamoBird365 no i am using item()?['name']
Strange that i still get the { }
But thanks for your answer
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.
@@DamoBird365 yes only the names but the text mode requires me to insert valid json and does not allow only the item expression
@danielweikertsn1615 you can have a single name in text mode or you need to add them to an array or object.
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?
Love the shirt - it's brilliant!
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 👍
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?
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.
Do you want to create a new version if it already exists? I’m curious.
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.
@@joyolohita1448 let me know if it helps
Thx for covering index by integer and array issues. I’m sure you’ve done this, namely, handling nulls?
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 😂
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.
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
It would be worth asking on the forum powerusers.microsoft.com/ and provide more detail on what you’ve tried 👍
Thanks for putting this together! My brain hurts.😅
Haha. Hope it helped you. 👍
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....
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.
Power automate cloud excel how to check each column
Kindly advise
Thank you
Hi Lokesh, I don’t understand your question? Can you rephrase? I would otherwise definitely recommend the forum powerusers.microsoft.com/
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