Distinct value multi column in SharePoint list

(0) Share

Report

Posted on by Doigt1976

Hello
I am a newbie in the world of PowerApps and I am looking for a way to list all the values contained in twenty columns of a Sharepoint list.

I have tested the Distinct() function but it only works on one column.

The Group function works but does not remove duplicates or empty spaces.

I don't know how to do it.

If you have an idea, I'm interested

Sort(GroupBy(Var_Liste_CMR_1;"Personne_1";"Personne_2";"Personne_3";"Personne_4";"Personne_5";"Personne_6";"Personne_7";"Personne_8";"Personne_9";"Personne_10";"Personne_11";"Personne_12";"Personne_13";"Personne_14";"Personne_15";"Personne_16";"Personne_17";"Personne_18";"Personne_19";"Personne_20");"Personne_1";Ascending)

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Doigt1976 ,

If you are asking for distinct values of where any of the columns match in one record match any of the columns in any other record, then I do not believe that is possible without a massive formula testing each field one at a time and then trying to filter duplicates out of that.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No