@kingslowpoke
Ok, I learned something new with this one...thanks for that:
When you do a "List rows in a table", Power Automate grabs the row ID even if you don't ask for it. So, my idea of doing a Union() wouldn't really work because the row ID's would all be unique, so splashing all of the rows against each other wouldn't yield any duplicates.
But...if we use a Select action to only grab the columns we want, then use the Union on those results, it will work:
The expression is union(body('Select'),body('Select')) - Basically, you can use Union to compare two arrays and pull the common rows...so if you compare it to itself, then you only get the unique rows. I think Intersection() does something similar, but I haven't tried that one yet.
From there, you can output the rows into whatever you want. Here, I just put them in an HTML table:
Hope that helps. Keep us posted.
-Ed
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
