Power Platform Community Forum Thread Details

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:

Building Power Apps