Answered

Compare collections to find duplicates

(0) Share

Report

Posted on by Rg129

Hi I hope someone can help. I have 3 collections in a gallery. Each collection has a name field and date field. How do I compare the three collections to see if there are duplicate values?

If there are duplicates I want to let the user know that there are dupes.

Collection A - name = Bob

Date = 6/15/2022

Collection B - name = Amy

Date = 7/8/2022

Collection C - name = Bob

Date = 6/15/2022

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

theapurva 970 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

you can refer the solution given by @v-jefferni here:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Display-Duplicate-Items-in-Gallery/td-p/697547

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Rg129 ,

You have three comparisons there - A-B, B-C and A-C - example of the first one

With( { wDup: ForAll( CollectionA As aDup, Filter( CollectionB, name = aDup.name && Date = aDup.Date ) ) }, If( CountRows(wDup) > 0, Notify("Duplicated") ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Rg129 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much! You made it simple.

Was this reply helpful? Yes No