Looking for a similar concept? Take a look here powerusers.microsoft.com/t5/General-Power-Automate/Is-filtering-array-possible-in-Select-Map-field/m-p/1258343 where I have demonstrated how to achieve the solution using two methods. Dynamic content in the expressions in order to calculate dates based on another Array or by even using a string value. No video for that one. If folk would like to see it, please like this and comment and I will put something together to explain.
Words cannot describe my joy right now. I've been banging my head against the wall until I saw this video about 10 times tonight. I had a non-functioning flow with all sorts of nested loops that was taking ages to run. Now I have an incredibly clean flow that does a ton of stuff in just 8 seconds. You, Sir, are a genius. Many, MANY thanks
Thanks Gregory, once you’ve mastered select on data operation, apply to each is a thing of the past. Check out this video th-cam.com/video/G3Q1WuZTWuY/w-d-xo.html
Dear Damian, I would like to express my sincere thanks for the fantastic tip you shared in your video. I’ve been trying for over a week to find a quick solution for filtering data from a SharePoint list and combining the necessary values with the same ID. Up until now, my attempts involved multiple processes, and the automation was taking several minutes to complete. Thanks to your advice, I was able to streamline all the processes, achieving everything in less than 2 seconds. I truly appreciate you sharing such a phenomenal tip. I look forward to your future videos!😊
Cheers. I love efficiency. So if you stumble across challenges, let me know. I’ve got an efficiency themed playlist too th-cam.com/play/PLzq6d1ITy6c3O4AghFQgBkG5CUleOrw3q.html&si=zOU_-jRXkHaMCQ-6
Learned more than I wanted. I had to physically duplicate your run to figure out the your were doing a lookup into the array at the end. I created my Combo Keys as {Name}%20-%20{Type}. It took me awhile to figure out I had spaces that I had to add to my lookup expression. Great Stuff! Thanks for the learning.
Great vid! You helped me with an array operation in the Power Automate community before and ever since I've been using expressions whenever I can and subscribed to your channel. Thanks for sharing your knowledge!
Incredible how powerful Power Automate is. Thank to your videos I can create a template .XLSX . I thought for months it is not possible. Additional - for many operations office scripts are faster than PA (eg. adding rows to the file). I am experimenting with parsing data to excel script, do the job then parse output to next step. If you like OS as well, I wait for your videos, because really appreciate your way of thinking!
Thank you for your kind words. I do have several office script examples. It is a really flexible tool and perfect for the power automate integration. If you have a specific use case, drop me an email to ideas@damobird365.com and I can add it to my list of to dos. I always appreciate the ideas. Thanks. See here -> th-cam.com/play/PLzq6d1ITy6c2_qM_ocYDtEaENrqi92YmM.html
That's really cool. Thank you for sharing this! I have one tip for you: There is an easier way to get a dynamic content to the expression field. Go to the expression view, write one letter into the expression field, switch to the dynamic content view and select the desired variable, switch back to the expression view and remove the letter insered before.
Ingrid, that's a fantastic tip! I have recently discovered this too and agree it's much easier than hoping to get lucky with the copy/paste. I will share this in one of my next videos. Thanks for sharing.
Nothing specifically wrong with an apply to each other than performance/efficiency on larger datasets. So if that applies to your solution keep this in mind. You can also watch my video on json and understand when first() might help keep your flow tidier.
I don’t but it could be achieved with an apply to each (row) and a select - I think. Use a variable and union to bring each select together. You can’t use concurrency.
First off Your videos are helping loads and thanks however i did stumble on an issue when the json rows are different for example name is blank/null on the first row but on the 5th it is complete. my select action breaks - json schema has the name but the input is missing the name on some rows. Can you point me to a video or help please as cant see how to fix, i also removed name from the required section of parse json.
Most likely a typo. If you use a ? In the expression it will return null if not found. If you remove the ? You will get an error that the key isn’t found and the flow will fail. Check your history for the field/key name and try again.
Looking for a similar concept? Take a look here powerusers.microsoft.com/t5/General-Power-Automate/Is-filtering-array-possible-in-Select-Map-field/m-p/1258343 where I have demonstrated how to achieve the solution using two methods. Dynamic content in the expressions in order to calculate dates based on another Array or by even using a string value. No video for that one. If folk would like to see it, please like this and comment and I will put something together to explain.
Words cannot describe my joy right now. I've been banging my head against the wall until I saw this video about 10 times tonight. I had a non-functioning flow with all sorts of nested loops that was taking ages to run. Now I have an incredibly clean flow that does a ton of stuff in just 8 seconds.
You, Sir, are a genius. Many, MANY thanks
Thanks Gregory, once you’ve mastered select on data operation, apply to each is a thing of the past. Check out this video
th-cam.com/video/G3Q1WuZTWuY/w-d-xo.html
Dear Damian,
I would like to express my sincere thanks for the fantastic tip you shared in your video. I’ve been trying for over a week to find a quick solution for filtering data from a SharePoint list and combining the necessary values with the same ID. Up until now, my attempts involved multiple processes, and the automation was taking several minutes to complete.
Thanks to your advice, I was able to streamline all the processes, achieving everything in less than 2 seconds.
I truly appreciate you sharing such a phenomenal tip. I look forward to your future videos!😊
Cheers. I love efficiency. So if you stumble across challenges, let me know. I’ve got an efficiency themed playlist too th-cam.com/play/PLzq6d1ITy6c3O4AghFQgBkG5CUleOrw3q.html&si=zOU_-jRXkHaMCQ-6
Learned more than I wanted. I had to physically duplicate your run to figure out the your were doing a lookup into the array at the end. I created my Combo Keys as {Name}%20-%20{Type}. It took me awhile to figure out I had spaces that I had to add to my lookup expression. Great Stuff! Thanks for the learning.
Seeing that Microsoft touts Power Automate as a low/no code solution, content like this is critical to non coder-types like myself.
Keep them coming!
Cheers Peter! If you think of any other challenges, feel free to drop me a DM via social media DamoBird365 or email ideas@damobird365.com.
Thank you for making this video! Excellent content and explanation 👏👏👏
Excellent work Damian!!! I really appreciate you taking the time and re-recoding this video...thanks a million!
Great vid! You helped me with an array operation in the Power Automate community before and ever since I've been using expressions whenever I can and subscribed to your channel. Thanks for sharing your knowledge!
Thank you very much Emmanuel. I appreciate your kind feedback.
Wow! This is a really necessary scenario. In the meantime, I'm half a step closer to solving my scenario!
Thank you for this! I managed to use this concept to left join two data sources instead of using loops
Awesome! That’s brilliant. Major efficiency to be had. Thanks for sharing.
Saved my project!!! thanks
Great content, extremely efficient Just adopted to my own case. Thanks for sharing Damian.
Great video Damien! Loads of great examples of expressions. I need to bookmark this and refer to it in the future 😅
Thanks very much Matt 😍
Amazing was trying to figure this out for a very long time, but you have solved this puzzle very easily.. really appreciate it..Thanks
Great info thanks
Incredible how powerful Power Automate is. Thank to your videos I can create a template .XLSX . I thought for months it is not possible. Additional - for many operations office scripts are faster than PA (eg. adding rows to the file). I am experimenting with parsing data to excel script, do the job then parse output to next step. If you like OS as well, I wait for your videos, because really appreciate your way of thinking!
Thank you for your kind words. I do have several office script examples. It is a really flexible tool and perfect for the power automate integration. If you have a specific use case, drop me an email to ideas@damobird365.com and I can add it to my list of to dos. I always appreciate the ideas. Thanks. See here -> th-cam.com/play/PLzq6d1ITy6c2_qM_ocYDtEaENrqi92YmM.html
That's really cool. Thank you for sharing this!
I have one tip for you: There is an easier way to get a dynamic content to the expression field.
Go to the expression view, write one letter into the expression field, switch to the dynamic content view and select the desired variable, switch back to the expression view and remove the letter insered before.
Ingrid, that's a fantastic tip! I have recently discovered this too and agree it's much easier than hoping to get lucky with the copy/paste. I will share this in one of my next videos. Thanks for sharing.
This was quite the process. As a beginner, what is wrong with Apply to Each?
Nothing specifically wrong with an apply to each other than performance/efficiency on larger datasets. So if that applies to your solution keep this in mind. You can also watch my video on json and understand when first() might help keep your flow tidier.
Do you have anything on doing a cross join / Cartesian product ?
I don’t but it could be achieved with an apply to each (row) and a select - I think. Use a variable and union to bring each select together. You can’t use concurrency.
First off Your videos are helping loads and thanks however i did stumble on an issue when the json rows are different for example name is blank/null on the first row but on the 5th it is complete. my select action breaks - json schema has the name but the input is missing the name on some rows. Can you point me to a video or help please as cant see how to fix, i also removed name from the required section of parse json.
@@leegarrett1908 cheers for kind words. If you use a ? In your expressions, nulls are returned instead of the expression failing.
The Repurposed Array portion isn't working for me. It's returning the columns but the values are "null". Any ideas on what I'm doing wrong?
Most likely a typo. If you use a ? In the expression it will return null if not found. If you remove the ? You will get an error that the key isn’t found and the flow will fail. Check your history for the field/key name and try again.