If you want to find all the distinct records in your data-source like a SharePoint list, there is no “Distinct records” action or distinct expression that you can use in Power Automate (earlier called Microsoft Flow) .
There is a simple way to do it using the union expression . This expression returns all the common items in two arrays. So, if we you use the union expression for an array on itself , it will return basically all the items, but the items that are there multiple times will be returned only once. Voila! You just found out the lookalike of ‘Distinct’ function in Power Apps.
Here is a screenshot of a simple flow with an array [1,2,4,1] and the compose action with the union expression –
Here is the expression I used.
union(variables('array1'),variables('array1'))
If you have any questions, please let me know in the comments.
