cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
prasadvenkat
Helper II
Helper II

Array variables - unique values

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
SamPo
Power Participant
Power Participant

@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

View solution in original post

11 REPLIES 11
SamPo
Power Participant
Power Participant

@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

NazIM
Frequent Visitor

What action would you place this formula under?

SamPo
Power Participant
Power Participant

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'.

 

hi

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

Screenshot_3.png

 

 

SamPo
Power Participant
Power Participant

@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
Microsoft
Microsoft
Powerplatform01
Post Patron
Post Patron

@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

@prasadvenkat 

Request you to please subscribe my power Automate channel

https://youtu.be/HFghBAYX-oQ

 

KashifZH
Frequent Visitor

very clever, thanks!

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (5,562)