Power Platform Community Forum Thread Details

Hi,

I have a list that looks like this:

I need to create a collection that eliminates duplicates on Column1 and keeps Column3 and 4.

Distinct() only returns one column (Column1) so I'm unsure how to proceed to add the rest of the columns...

FInal result on the example would be:

Additional info:

Column3 is blank if Column1 does not have duplicates. As column3 are options for column1.

When populated, Column3 has no duplicates.

Thanks and regards

but that post is 2 years old, so hope there is a solution for that now

Categories:

Collect list without duplicates