Filter for Duplicate Names (as Text) in a gallery

(0) Share

Report

Posted on by Paultys

Hi All,

I'm really struggling to make this work despite having read so many other posts on the subject.

I have a SharePoint list "Screening Records" and the list has a column "Name" which is a free text column.

I need to filter a gallery to only show items that have the same name. I've tried Groupby etc and it works, but (obviously) it groups them and I need to be able to see each individual record, but only where those records have duplicate names.

Many thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey @Paultys

as we do not have much details this is a pseudo version of the code:

// Step 1: Create a collection of duplicate names ClearCollect( DuplicateNames, Filter( GroupBy('Screening Records', "Name", "Duplicates"), CountRows(Duplicates) > 1 ) ) // Step 2: Filter the gallery to display items with duplicate names Filter( 'Screening Records', Name in DuplicateNames.Name )

You would need to modify to your needs.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Paultys 94 on at

Like (1)

Report
Copy link

Link copied!

That's perfect, I didn't think about creating a collection. That's worked a treat. Thank you

Was this reply helpful? Yes No
mmbr1606 14,615 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

great that it works 😉

Was this reply helpful? Yes No