Need to remove duplicates from output of applytoeach list

(0) Share

Report

Posted on by ShivaPatpi Microsoft Employee

in the above screen shot in the Compose 2 action named region - I am getting list of regions but contains duplicates.

I have to remove duplicates.

In one of the post it was said to remove duplicates use union on some variable.

I tried to do but . I tried adding Append to array variable but when I click on Name drop down list I don't see any.

what name I have to choose?

where should I initialize the variable.

It seems I can't initialize in ApplyToEach, I can only use append array variable.

Any help ?

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ShivaPatpi

Here is an example Power Automate to remove duplicates form an Array:

——————————————————
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
RobElliott 10,505 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ShivaPatpi or you can just use a Union expression which strips out duplicates from the 2 variables:

union(variables('varTown'),variables('varTownCounty'))

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ShivaPatpi ,

You could first append all regions to an array variable and then use the union() function to remove duplicate elements from the array.

Finally, you could use the Join action to extract regions.

Image reference:

Best Regards,

Was this reply helpful? Yes No
ShivaPatpi Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft , what will be the Join with value ?

Was this reply helpful? Yes No
ShivaPatpi Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

What should be the Join With ???

Was this reply helpful? Yes No
ShivaPatpi Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Also i am getting above error when i try to add Append to array variable

Was this reply helpful? Yes No
Verified answer

ShivaPatpi Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

i was able to figure it out. I was self referencing the same variable twice in the for each loop which was going in a cycle.

Was this reply helpful? Yes No