I am trying to get only the unique values from array variable (of strings) into a list so I can create html and email. Is this possible to get this through an expression?
Solved! Go to Solution.
@prasadvenkat use the 'union' expression to combine the array with itself to get a result of unique values. For example:
union(outputs('myArray'),outputs('myArray'))
Hope this helps
Sam
@prasadvenkat use the 'union' expression to combine the array with itself to get a result of unique values. For example:
union(outputs('myArray'),outputs('myArray'))
Hope this helps
Sam
thanks.. that works
What action would you place this formula under?
hi
i have used the same above but not able to get unique array.
@Achavan It looks like you're trying to wrap your array variable in another array.
Remove the array function and just use:
union(variables('Customer Array'),variables('Customer Array'))
Hey you can watch this video to resolve your issue.
Also request you to please subscribe this power Automate channel
very clever, thanks!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
43 | |
18 | |
15 | |
14 | |
13 |
User | Count |
---|---|
69 | |
37 | |
28 | |
21 | |
19 |