Answered

Find Duplicates in one collection and notify user

(0) Share

Report

Posted on by sngledev

I am stuck on how to find duplicates in my collection. In my column called 'New Column' you can see duplicates, I just need to notify the user that there are duplicates. How would I write a formula for this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

365-Assist 2,327 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Here is a great video from Shane Young that will help PowerApps Duplicates - Avoid, highlight, and even delete - YouTube

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sngledev ,

Have you solved the question? If you just would like to "notify" users of duplicates, the solution from the video scenario 3 would help, and you even don't need to apply it all. Please just try and modify the TemplateFill property of the Gallery with below formula to highlight the duplicates:

If(CountRows(Filter(colFinalsolution, 'New Column' = ThisItem.'New Column')) > 1, Yellow, White)

Best regards,

Was this reply helpful? Yes No
sngledev 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for the late response but this is the approach I took and it helped thank you.

Was this reply helpful? Yes No