This is so valuable that I felt compelled to respoond. I second the other poster's gratitude in being able to use this trick. I spent hours trying to figure out how to get rid of the nested apply to each that kept popping up! I cannot post the details but the overall flow that ran successfully is below:
I added the send an email notification because if you use the regular "send an email" action, the html tags will remain intermixed with the data. I wanted the flexibility of being able to send this report to external users and a distribution list as well and not just receive notifications using the default notification actions in Flow.
Thanks again and email me at firstname.lastname@example.org if you have specific questions about how I put this flow together. The reporting application of this flow is pretty signifigant.
Great thread, glad I finally found it! I have an identical Flow set up (same as screenshot above @ZoneofZen). I just have one more need and am struggling to find an answer. My filter array action currently is set to filter the array based on 1 column value, but I would like to filter on 2 columns. I tried adding another filter array action below, but got the auto apply-to-each - I then tested it anyway and did not get the desired results. With the way my Flow is set up, I think I have 2 options. Either edit the 1st Filter Array in advanced mode - here's the current filter:
I'm not sure what the syntax is to add another filter argument.
Or, I can perhaps do what I already tried...adding another Filter Array (maybe i'm doing something incorrectly).
Also, why can't we add multiple filters in the filter array action UI???
Join us for the first ever Power Platform Online Conference!
Keep your eyes open for our upcoming T-shirt design contest!
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!