Answered

How to Only see Duplicate Records

(0) Share

Report

Posted on by wsalling

114

i have a large collection that has duplicate records. i can use this to change the color of a record if it is a duplicate value.

If(CountRows(Filter(colTest,Name=ThisItem.Name))>1,Orange,White)

Works fine. But know i only want to see the duplicate records. Can you filter a collection to show only duplicates? i know i can use distinct to get a single entry for every value.

how can you filter a gallery to show only the ones that are duplicated?

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Rebetcha 645 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wsalling ,

I will share my approach how I would tackle this. The information you have shared does not allow me to share a worked out formula with you, so you need to figure that out yourself based on your specific scenario.
The approach here is transforming your collection in a way that you can easily identify the duplicate records.
Start by making use of the GroupBy function in a way that the records that are duplicate of each other are grouped together.
The next step would be to calculate the number of records in a group (CountRows).
When you have that you can filter on all groups where the number of records is more > 1.
You now have a grouped table with only groups containing duplicates. Use UnGroup and Distinct to transform the records back to a flat table with only records that have duplicates in the collection you started out with.
Let me know if this solves your problem.
wsalling 114 on at

Like
a
(0)

Report
Copy link

Link copied!

Found a way to create a new collection then apply filter to that collection in the gallery. is there different way to do straight in gallery?
wsalling 114 on at

Like
a
(0)

Report
Copy link

Link copied!

i used GroupBy to create a new collection.
On Screen Visible:
ClearCollect(ColTempDups,GroupBy(varStatement,"Name","Other"));
then in Gallery Items
Filter(ColTempDups,CountRows(Other)>1)

This shows me what i want,but can it be done in one step in Items field?
Verified answer

Rebetcha 645 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @wsalling ,
Yes, you can do that directly in the Items property of your gallery without having to store it in a collection by combining your GroupBy and Filter in one formula.

Try this:
Filter ( GroupBy(varStatement,"Name","Other"), CountRows(Other)>1)
wsalling 114 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank You R. I beat my head on table for about an hour on this one.
Rebetcha 645 on at

Like
a
(0)

Report
Copy link

Link copied!

You are very welcome. Happy to help.
You where actually nearly there. I just combined the 2 formulas you came up with and removed the collection bit.