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)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (3)

Report
@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

Thanks Randy.

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

Like (1)

Report

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

Thanks Kristóf.

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

Like (1)

Report

@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

Great call out @RandyHayes You are right.

Was this reply helpful? Yes No
MihirL 8 on at

Like (0)

Report

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

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

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