Unanswered

Remove duplicate records of column in gallery

(0) Share

Report

Posted on by Joaoandrebs

361

I need to remove duplicate records from a gallery that displays this data, but I cannot lose the essence of this formula, which is essential for the use of my application.

1. The column I need to remove the duplicates is 'Station with APA'

2. I tried with distinct at the beginning of the formula but it gave an error at the end, disappeared all the data in the gallery o.O

If(
 !IsBlank(ComboBox1_1.Selected.Value);
 Filter(
 ListaEditavelOperacoes;
 Len(ComboBox1_1.Selected.Value) = 0 || Time = ComboBox1_1.Selected.Value
 );
 Filter(
 ListaEditavelOperacoes;
 Ativo = "23;j4;2i35j2;3'51j3902jr'23j"
 )
 )

my code,

thanks!!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

madlad 2,637 Moderator on at

Like (0)

Report

What exactly did you try for distinct? It's a very useful function in this scenario, and to get it working would likely be the best route.

Was this reply helpful? Yes No
rsinha 2 on at

Like (1)

Report

Hi @Joaoandrebs
Kindly try using the Distinct functions right before both the filters, I did have similar sort of problem in past, and I used Distinct before Filter and it worked.
Kindly try and let me know.

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (1)

Report

Hello, @Joaoandrebs, If you are using the table's columns to map to text labels inside your Gallery, distinct won't work because distinct return a one column table.

Try this:

If(
 !IsBlank(ComboBox1_1.Selected.Value);

With({UniqueList: Distinct(
 Filter(
 ListaEditavelOperacoes;
 Len(ComboBox1_1.Selected.Value) = 0 || Time = ComboBox1_1.Selected.Value
 ),YourColumn))}; Filter(ListaEditavelOperacoes,YourColumn in UniqueList))

;
 Filter(
 ListaEditavelOperacoes;
 Ativo = "23;j4;2i35j2;3'51j3902jr'23j"
 )
 )

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No

cwebb365 3,294 Most Valuable Professional on at

Like (3)

Report

Don't forget distinct() is not delegable. So if your datasource is a large one, you will be limited in it working correctly with more than the set delegation setting (500 by default). You would have to connect to pre distinct values through views or other means outside of powerapps in order to utilize distinct if you return many values.

If your filter can always be less than the delegation limit you can always pull those values into a collection, then run distinct on that collection to get unique filtered values however.

Was this reply helpful? Yes No
Joaoandrebs 361 on at

Like (0)

Report

@AhmedSalih @cwebb365 firstly, thanks for reply,

Ahmed, I tried your code but it still keeps showing the repeated items

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@Joaoandrebs, you need to use ... in UniqueList.Value

Was this reply helpful? Yes No