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.
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.
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.
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.
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 ua-cam.com/video/pwJ73jFEtDQ/v-deo.html
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 ua-cam.com/video/afqvGAb20Dw/v-deo.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 👍🏼
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?
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.
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)"
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?
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.
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.
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.
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
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.
Brilliant video. Awesome explanation
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 👍
I will be sharing this video with our Power Automate users. Great video, thanks Damien
Cheers Gary 👍
Brilliant video Damo, makes things a lot clearer. I will be bookmarking this 😊
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.
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!
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. 👍
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
Excellent! I really like how you're focusing on Power Automate topics. Very helpful (and I am subscribed🙂)!
great! love it clear clear clear!
Thank you so much, it helped me a lot!!
Thanks Kathleen 👍
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
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 👍
Awesome video this has just helped me so much
Cheers Adam - much appreciated 👍
Loving your content. Thank you.
fantastic quality content, thanks so much it helped a lot
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
ua-cam.com/video/pwJ73jFEtDQ/v-deo.html
@@DamoBird365 Thank you so much for your reply! I'll check it out!
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
ua-cam.com/video/afqvGAb20Dw/v-deo.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 👍🏼
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
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.
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)"
Thanks for putting this together! My brain hurts.😅
Haha. Hope it helped you. 👍
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?
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?
Thanks!
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.
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.
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.
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.
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 👍
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