Array variables - unique values

[prasadvenkat]

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? 

[SamPo · Accepted 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]

thanks.. that works

[NazIM]

What action would you place this formula under?

[SamPo]

You can place it wherever you want to display or use the output. The simplest option is to use the 'compose' action. You could also use a variable of type 'array'.

[Achavan]

hi

i have used the same above but not able to get unique array.

[SamPo]

@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'))

[rishiverma12]

https://www.dynamics365crm.org/post/microsoft-automate---flows-remove-duplicates-from-an-array-varia...

[Powerplatform01]

@prasadvenkat 

Hey you can watch this video to resolve your issue.

Also request you to please subscribe this power Automate channel

https://youtu.be/HFghBAYX-oQ

[Powerplatform01]

@prasadvenkat 

Request you to please subscribe my power Automate channel

https://youtu.be/HFghBAYX-oQ

[KashifZH]

very clever, thanks!