Compare collections to find duplicates

[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

[theapurva]

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/6975...

[WarrenBelz · Accepted solution]

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

[Rg129]

Thank you so much! You made it simple.