Show duplicate records in the gallery

(1) Share

Report

Posted on by echodapogi

516

Hi Team,

I am looking in previous discussion the forum regarding how to display duplicate data (Ex: PONumber) in the gallery but i cannot find any ideas. It sounds like simple but i cannot make it work. Can anybody help me on how to display duplicate PO number in a gallery?

I just needed to identify or ONLY SHOW duplicate records in gallery. My table is in sharepoint list (tblData)

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (3)

Report
Copy link

Link copied!
@echodapogi

Without any further details on what you have data-wise, the general concept is this in your Items property of a Gallery:

Filter( GroupBy(yourDataSource, "PONumber", "_data" ), CountRows(_data)>1 )

This would return a table of any PONumber's that are duplicated.

I hope this is helpful for you.

Was this reply helpful? Yes No
echodapogi 516 on at

Like (1)

Report
Copy link

Link copied!

Thanks Randy.

Was this reply helpful? Yes No
Krzysztof Borkowski Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

1. Put your data into a collection and load to a gallery as items. E.g. ClearCollect(colPOnumbers, tblData)
2. Set TemplateFill of your Gallery so if Title column has your PONumber it will count if it exists more than once and marks it as Red : If(CountRows(Filter(colPOnumbers, Title = ThisItem.Title))>1, Red, White)
3. You can use GroupBy(colPOnumbers, "Title", "myData") on the gallery Items property to see only once the highlighted duplicate.
4. Add a Text Label into the first record of your gallery, Text property: concat(ThisItem.myData, Text(ID), ", ") to see which records have duplicated PONumber.
5. You can finally filter those records which has more than 1 row. Filter(GroupBy(colPOnumber, "Title", "myData"), CountRows(myData) > 1 )

Was this reply helpful? Yes No
echodapogi 516 on at

Like (1)

Report
Copy link

Link copied!

Thanks Kristóf.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Kristóf

A collection?? Why duplicate all the data records into app memory?? Plus you would then need to continuously re-collect the records into the collection if you plan to make any changes to the list in which you want to reflect those changes in the gallery. Lot's of app performance issues there.

Was this reply helpful? Yes No
Krzysztof Borkowski Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Great call out @RandyHayes You are right.

Was this reply helpful? Yes No
MihirL 8 on at

Like (0)

Report
Copy link

Link copied!

I have same issue but in my case I have multiple entities like Email, Employee Name, Contact Number, Employee ID
Please suggest

Was this reply helpful? Yes No
MihirL 8 on at

Like (0)

Report
Copy link

Link copied!

I have same issue but in my case I have multiple entities like Email, Employee Name, Contact Number, Employee ID
Please suggest

Was this reply helpful? Yes No
MihirL 8 on at

Like (0)

Report
Copy link

Link copied!

I have same issue but in my case I have multiple entities like Email, Employee Name, Contact Number, Employee ID
Please suggest

Was this reply helpful? Yes No