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 czcams.com/video/G3Q1WuZTWuY/video.html
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 -> czcams.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.
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
czcams.com/video/G3Q1WuZTWuY/video.html
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.
Wow! This is a really necessary scenario. In the meantime, I'm half a step closer to solving my scenario!
Excellent work Damian!!! I really appreciate you taking the time and re-recoding this video...thanks a million!
Great info thanks
Thank you for making this tutorial and explaining every click and keypress in so much detail!
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 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.
Thank you for making this video! Excellent content and explanation 👏👏👏
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.
Great content, extremely efficient Just adopted to my own case. Thanks for sharing Damian.
Saved my project!!! thanks
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 video Damien! Loads of great examples of expressions. I need to bookmark this and refer to it in the future 😅
Thanks very much Matt 😍
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 -> czcams.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.
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.