PowerApps Duplicates - Avoid, highlight, and even delete

In this video, you will learn how to deal with Duplicates in Power Apps. We will cover using LookUps to avoid creating them, then the in operator to find and highlight them (along with deletion) and then finally we will close with a little GroupBy fun.

[francisbriones]

I've been watching your PowerApps tutorials and it's very helpful for me as an IT Admin in our Company that's developing a PowerApps Program. Thanks Shane!

[angrybatvoice]

Nothing but respect for your duplication investigation.

[caraziegel]

Thanks for sending me here - i was more thinking of just using the SP list title field to enforce it - after seeing a comment you made on a post somewhere about setting the title field as a concatenation of whatever other values make it unique. i just want to enforce it in a dummy-proof way

[greglastname]

Shane! Just implemented your 3rd example to highlight duplicates in a gallery. Just fabulous. Will also try in a table. VEry much appreciate your lessons. Wish there was a way to also do this in a power Apps table.

[upgradeaerialphotos]

Thank you! I just asked for this like a week ago and you already have a video!! Amazing work!

[philippseis]

I'm very glad i found this one. Thanks Shane!

[soliderarmatang]

Shane, THANK YOU!!! Your videos are an amazing help! This helped me fix my duplicate inserts from collection to CDS table.

[ulises]

Gracias Shane, me han servido bastante tus videos para mi trainig en Power Apps. Un saludo desde Mexico!

[alfredodhiambo]

Thank You Shane. This video has really helped me

[altino]

Hi Shane!

Thanks for another video!

[khalidmullawns]

Thank you Shane, this is what I was looking for

[dvk]

Excellent Video Shane!!! Once again, your´re the Best!! Thank´s!!

[patrickfillion]

Very interesting. I am starting to learn the PowerAutomate and searching for potential duplicates in Dynamics when a user created a record in Portal was one of the things to check for. So, I think this video will be quite useful to do that.

[priyankagajbhiye]

Hi Shane, Thanks for the informative video. But any way to remove duplicates from the Microsoft list. If I m not using this method to save the data. Once i submit my data goes to list. So how can i avoid duplicates there?

[derek_shannon]

Rock on, Shane. In combination with your "Favorites" video, this is very helpful for establishing relationships between tables--For instance, you could set the default property of a checkbox to TRUE if it was in a collection related to another item. Endless possibilities for sure, while also seconding your call to watch out for performance issues ;-D

[NKBobcat]

The exact issue I am working on with my current application. Looking forward to viewing this.Thank you!

[asifkhawaja]

Shane! Great video as usual. Will help a lot in an upcoming project. Thanks.

[DataisKing]

Hi Shane,
I'm trying to remove duplicates that are in a SharePoint list. Both records have the same Employee Name and Pay Type. The ID is the only difference between the 2 records. Any ideas?

[aishwariyagupta]

Hi Shane! This video is too good. Followed it step by step along with the PopUp Screen video which you had done. Could you please tell your "UpdateContext" code? Since my pop up screen is showing even when there is not a duplicate record.

[vanessacalalang]

Hi Shane, Thank you for all your amazing videos. I learned heaps and continue learning. Have a question please, I'm building a calendar app and I want to be able to show conflict booking if there's any, show duplicate based on start date/time and end date/ time, and be able to delete the duplicate. Do you have easier tips on how to do it? Thanks!