web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Best way to create a c...

Power Apps

Unanswered

Best way to create a collection of distinct names from 3 different columns

(0) Share

Report

Report

Posted on by JR-BejeweledOne

5,836 Moderator

What is the best way to create a distinct collection of people when the names can be in any one of 4 different columns in the source table?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

BCLS776 8,994 Moderator on at

Like (0)

Report
How about?:
Create four collections using Distinct() on the four columns
ClearCollect() those four collections into one
Use Distinct() one more time on the combined collection to weed out any duplicates
Bryan

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

I trying to avoid that if possible.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @JR-BejeweledOne ：

I assume there is a table something like:

ClearCollect( TheCollection, {Name1:"Aof",Name2:"Bof"}, {Name1:"Dof",Name3:"Bof"}, {Name1:"Gof",Name3:"Dof"} )

Then

Distinct( Filter( Ungroup( ForAll( TheCollection, [Name1,Name2,Name3] ), "Value" ), !IsBlank(Value) ), Value )

Result:

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation