Filter out duplicates in gallery

(0) Share

Report

Posted on by TimmyBoy

997

Hello,

Is it possible to filter out duplicates?

I get my data:

SortByColumns(Search(colAllData; Trim(TextInput1_8.Text) ;"Title";"field_1";"Lastname";"Firstname";"field_7";"DateText";"MonthValue";"field_12");"Title";If(SortOrder.Ascending;SortOrder.Descending))

The fields in the gallery are Labels and the names that has match our CUSTOMER fields

So in the gallery i see multi customer names
How to avoid it so i only see 1 of each other without duplicated

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

JayMagness 1,663 on at

Like
a
(0)

Report
Copy link

Link copied!

HI,

I think this is what you are looking for:

Distinct function in Power Apps - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
TimmyBoy 997 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
Hmm, it doesn't show anything with searching my way to get the data?
It shows a data table not a gallery 🙂
Any ideas?

Was this reply helpful? Yes No
TimmyBoy 997 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,
I tried the following code
But gives me only 1 result?
ForAll( Distinct( ColAllData; CUSTOMER ); LookUp( ColAllData; Trim(TextInput1_8.Text) in "field_7" ) )
how can i get more results without duplicated full names?

Was this reply helpful? Yes No