Manipulating data is one of the most frequently used functions of #PowerAutomate.
UNION and FilterArray are particularly powerful. Union merges everything once and filter array searches for the things we want. If you take 2x the same table at UNION, it behaves like a distinct.
Marcel Lehmann 
Leave a Reply