PowerApps Duplicates - Avoid, highlight, and even delete

[@francisbriones6447]

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!

[@ShanesCows]

Glad to help your Francis. :)

[@angrybatvoice]

Nothing but respect for your duplication investigation.

[@ShanesCows]

Thanks and sorry for the slow reply. I missed a chunk of comments somehow so trying to clean that up now. So many comments. 😀

[@caraziegel7652]

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

[@ShanesCows]

Glad it was helpful!

[@upgradeaerialphotos]

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

[@ShanesCows]

Hope you like it! The comments do drive what i make. :)

[@greglastname9577]

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.

[@soliderarmatang5664]

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

[@ShanesCows]

You are so welcome!

[@philippseis6893]

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

[@ShanesCows]

Happy to help. Have a great day!

[@ulises0502]

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

[@ShanesCows]

😀

[@dvk003]

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

[@ShanesCows]

My pleasure!

[@patrickfillion7193]

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.

[@ShanesCows]

You can do it!

[@NKBobcat]

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

[@ShanesCows]

Hope it helped!

[@alines7399]

Shane, thanks from Brazil!

[@ShanesCows]

Thank you! Have a great day Aline.

[@alfredodhiambo8657]

Thank You Shane. This video has really helped me

[@ShanesCows]

Awesome!

[@khalidmullawns]

Thank you Shane, this is what I was looking for

[@ShanesCows]

Great to hear.

[@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

[@ShanesCows]

I love the combination thinking Derek! That is exactly what I strive for with my students. Learn little pieces so you can assembly them in great ways later.

[@ravindraudbalker9998]

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.

[@ravindraudbalker9998]

Set ( varRecord, LookUp ( 'Cascade Config List', Technology = DataCardValue2.Text && Category = DataCardValue3.Text && SubCategory = DataCardValue4.Text ) ); If ( IsBlank(varRecord.ID), SubmitForm(SharePointForm1), Notify("Data already exists. Please check and try again...", Error)) );

[@ShanesCows]

Awesome

[@josephsmith5531]

Another great video, thank you.

[@ShanesCows]

Glad you enjoyed it

[@yuvaraaju]

Great teaching Shane.

[@ShanesCows]

Thanks 🤩

[@altino91255268]

Hi Shane! Thanks for another video!

[@ShanesCows]

You bet!

[@julireid9574]

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?

[@ShanesCows]

You cannot change the Gallery.Selected record but what if in TemplateFill you said If(ThisItem.ID = varRecord.ID, Green, White) then varRecord would be in charge. :)

[@julireid9574]

Shane Young after I made that comment I used varRecord.id in an if statement that filters the gallery to only show the existing duplicate if varRecord .id is not blank. That works even better in my app because there are lots of items in that gallery and this will force the matching item to the top of the list.

[@asifkhawaja]

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

[@ShanesCows]

You bet!

[@MrZeeshanstudent]

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

[@ShanesCows]

Glad to help. 😀

[@priyankagajbhiye8752]

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?

[@ShanesCows]

You would have to write a Power Automate cloud flow to clean up your list. This video kzbin.info/www/bejne/jGK3mXSCltupnJI doesn't show exactly what you want but kind of the opposite, getting all the duplicates together. Maybe you can use it to build what you want or at least get ideas.

[@rayromych5534]

Nice video, Thank You!

[@ShanesCows]

Glad to help. 😀

[@barbloke1566]

Great work Shane, keep em coming! 😄

[@ShanesCows]

Thanks. Will do!

[@SinisterBowfishingTM]

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"

[@aishwariyagupta619]

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.

[@ShanesCows]

I don’t have it handy but just make sure you are setting the variable back to false as needed.

[@jyothisrinivas6637]

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.

[@ShanesCows]

Depends on your data source and operators but probably.

[@matthewgoldring]

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?

[@ShanesCows]

That is the disambugation operator. It is a way to help PowerApps better understand when you have two elements with the same name. I never use it, instead I avoid the conflicts. 😀 But you can.

[@junelbuitizon3378]

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

[@pavankalyanbn9153]

thank you shane a great video helped me a lot

[@ShanesCows]

Awesome thanks 🙏

[@kikebarahona3097]

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

[@ShanesCows]

It is the visible property of the label

[@Andy-up1tt]

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

[@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?

[@vanessacalalang1833]

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!

[@ShanesCows]

I don't. Sorry. 😑 It is possible, just a pain to do.

[@pirathipaagnanasekaran6839]

@@ShanesCows Great Video! I need help in preventing double bookings as well :( please help!

[@Fernando_Calero]

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

[@ShanesCows]

Gald you got it.

[@Itsprincessa01]

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

[@edwinjonah]

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.

[@matthewfritch9491]

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

[@davidgraf8012]

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?

[@ShanesCows]

This method would work. Check before they patch the datasource

[@davidgraf8012]

@@ShanesCows - What would I check? Another question - how do you keep two people from editing the same record?

[@papithasekar9567]

Thank you! Great video

[@ShanesCows]

Glad you liked it!

[@eastenwoolf5352]

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

[@ShanesCows]

Add the logic when the click the save button and only submit the form if no duplicate is found

[@corby8678]

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

[@ShanesCows]

Sorry, I am not sure how.

[@Symium]

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

[@ShanesCows]

You have to use the method from this video to check and see if they have done it already or not.

[@Symium]

@@ShanesCows thanks a lot

[@ashwinidas7142]

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

[@ShanesCows]

You would need to write logic to do the updates. I am not much help.

[@ashwinidas7142]

@@ShanesCows Is there a way without selecting gallery to get the values in the form?

[@zolisawelani9338]

Thanks a lot. You saved me!

[@ShanesCows]

Glad to help. 😀

[@zanrleonardo]

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

[@ShanesCows]

Sorry I am slow to reply. For help on projects connect to www.PowerApps911.com

[@NeelMonk]

Hi Shane, Is it possible to do this in SharePoint

[@ShanesCows]

Yes, I thought the video showed the demo using SharePoint?

[@lucilaneo]

THANK YOU!!!

[@ShanesCows]

You're welcome!

[@shreenikascreation7340]

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

[@ShanesCows]

This video is the best explanation I have of that concept.

[@pvvsrvinay]

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

[@ShanesCows]

Use a variable to control the visible property and then manipulate the variable

[@pvvsrvinay]

Shane Young Thank you for the quick reply. Issue is resolved. Thanks a lot :)

[@anandasanyal]

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.

[@anandasanyal]

It worked !!! Remove(Project, Filter(Project, ID=GalleryPrj.Selected.ID)); Remove(ProjectsCol, Filter(ProjectsCol, ID=GalleryPrj.Selected.ID)); But I need to refer TempID, as I need to delete from another List. Let's see..

[@ShanesCows]

Good job!

[@suneelrvishwakarma]

Hi, can we do this SharePoint list?

[@ShanesCows]

This video use SharePoint for all of the demos.

[@zeeshanmushtaq7437]

Can you make a video to create custom connectors?

[@ShanesCows]

I don't do a lot of that so not sure the video would be very good. :( Sorry

[@vilaymaortega7477]

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

[@ShanesCows]

Sorry 😟

[@giorgiosurian2190]

u are the best

[@giorgiosurian2190]

you just are

[@ShanesCows]

Thanks! 😎

[@Itsprincessa01]

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

[@divyas7123]

duplicate avoide using forall..?

[@fibonacci9445]

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 😁

[@ShanesCows]

I got nothing. 😳 Maybe some flow magic but not even where to tell yo your start.

[@dandrem.4074]

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

[@ShanesCows]

Sorry you are having issues but not sure I agree it is harder then JS.