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
Solved! Go to 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
you can refer the solution given by @v-jefferni here:
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
Thank you so much! You made it simple.