PowerApps Duplicates - Avoid, highlight, and even delete 

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!

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

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.

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

Nothing but respect for your duplication investigation.

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

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

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

Great work Shane, keep em coming! 😄

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

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.

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

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

Thank you Shane, this is what I was looking for

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

Thank You Shane. This video has really helped me

Hi Shane! Thanks for another video!

Another great video, thank you.

Great teaching Shane.

Shane, thanks from Brazil!

thank you shane a great video helped me a lot

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!

hello thank you very much for this video, may i know for check for duplicate set up dont create duplicate section where did you define the varShowEdit. and also how do i show the warning page only if varShowEdit is true ? thank you

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.

Nice video! I have a question though. I have recently started to see duplicates in forms that are filled through PowerApps into SharePoint lists. The form resets each time a submission is sent, but then I find a duplicate with the same time of creation, as if two submissions were sent from PowerApps to SharePoint. Any idea why this might be happening? I've noticed it in a few of my apps and can't figure out why.

Thanks Shane, another interesting vid! Quick question..at 10:06 you accidentally typed [@inpDescription]. What is this [@ELEMENTNAME] thing that appears, and why is it different to ELEMENTNAME?

Awesome video Shane. This really has helped me quite a bit. One question, Is there a way to set a lookup to ensure a duplicate record does not exist over multiple days? For example, if you had a lookup with StartDate of 1/5 and an EndDate of 1/7 for a reservation how would you go about ensuring a record could not be patched in for a start date of 1/6? Here is what I have so far: Set(varRecord, LookUp('Cabin Reservations', StartTime >= StartDate && EndTime

Thank you! Great video

Nice video, Thank You!

Thanks Shane for a solution i was looking for long time, so that i can handle composite key on multiple columns. If i put the code on sharepoint integration on save button, no need to create another button.

Do you have a video discussing the Powerapps using a barcode scanner and how you can find the duplicates with the scanned data so it tells the user "This entry already exists"

Thanks a lot. You saved me!

Thank You Shane..! have a question on this. Is it working / delaying of identification duplicates records when my data set have more than 5,000 records and my app settings data row limit is set to 500.

Thanks a lot very helpful that what ask in comment you explain lot more than I ask great

How to compare record to record, in such a sense that all records will check whether it has already record in a sharwpoint list?

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?

Hi Shane, would you have an alternative or workaround to get distinct values from sharepoint list without delegation and without using collections and/or Flow? reason is my sharepoint list has more than 50,000 rows, and I'd like to create something like a realtime dashboard where I need to show the summary in a gallery. My users hate the idea of preloading into collections as it will still cause latency while collecting, so I've been exploring if we can hack this using formulaic alternatives. Been able to solve my countrows dillema using the with() function i saw somewhere on web, so I'm somewhat hopeful that there's also a genius out there who's been able to figure out a way to use distinct() for sharepoint without delegation 😁

Hi, i'm getting this error the reset function can only be used with a resettable control

Great videos Shane. How could I prevent filling in a form twice by a user? my data source is sharepoint

THANK YOU!!!

Thank you Shane, another nice video. I want to delete an Item from gallery and list. I'm using SharePoint Edit form, On a button OnSelect using following code, getting delegation warning, also item is not getting removed. Remove(ProjectsCol, Filter(ProjectsCol, ID=TempID)); Remove(Project, Filter(Project, ID=TempID)); ID is unique in my List, TempID is a variable where I'm storing ID of the selected item. what am I doing wrong here? Thank you for your help.

Shane, did you worked on Project with powerapps? I get a error when i wanna get a item by flow... can help me out...

How do we do this if we are using the Submit form button in the standard phone application creator?

In a scenario where you DO have a gallery and a duplicate is found rather than automatically updating the existing item, could you use the information in varRecord to automatically select the item in the gallery so it's data would show and the user could decide if they wanted to edit it and if so how would you do that?

Hi SHane, is there a part of the video that I do not understand, when the message of the duplication with which you make it visible before the submit is made? help mi please

Hi Shane, Thank you for the video. I am new to Power Apps Can you tell me how to hide that rectangle and show it back when Update button is clicked ? Regards Vinay

Half a day struggling with the Pop Up that didn't show up, everything was "correct" as far as I could see, but no, I set the variable to true first with Set and to false with UpdateContext. #PowerAddicts

Dear Sir Please can help : i want to type in textinput and save in database excel sheet in (hindi fonts ) just like google translate text box when completed my typing it save in excel sheet

I m using SQL Db,The changes made in the existing Db should be able to update on different db. How to do that? Thanks

Shane - What if you have two or more people using the same application and you want to avoid them putting in duplicate records into a SharePoint list?

Hi Shane, I always follow your videos, its Of course great Video .. In my case I have the Display Gallery in which I need to Distinct the Duplicate Records of a Lookup Field. Please help me out

u are the best

Can you make a video to create custom connectors?

duplicate avoide using forall..?

Hi Shane, Is it possible to do this in SharePoint

Hi, can we do this SharePoint list?

Its not working for me for some reason, continue struggling with this issue

I used your video to avoid duplicates, but i get the reset error

I hate Powerapps...this is the most difficult program on earth and I know Javascript.