web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapps - Find dupli...
Power Apps
Unanswered

Powerapps - Find duplicates in Sharepoint list of over 2000 items

(0) ShareShare
ReportReport
Posted on by

I have a Sharepoint list with over 2000 items, so need to think about delegation.

I have 3 columns, an internal code, description and barcode.

Some internal codes have more than one barcode and I want to know which barcodes are duplicated.  The duplicated barcodes have different descriptions, so are clearly an error.

 

What is the best way to find the duplicates?

 

One way might be to adapt code like this.  However, I'm worried about performance, so would like to avoid ingesting the list into a collection.  I currently use the lookup function.

http://powerappsguide.com/blog/post/delegation---how-to-overcome-the-5002000-row-limit-with-collections

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 445

#2
WarrenBelz Profile Picture

WarrenBelz 386 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 321 Super User 2025 Season 2

Last 30 days Overall leaderboard