Patch vs Update vs UpdateIf in PowerApps (which one to use)

[@MrAll2001]

One guy spent few hours to make a video and saved thousands of hours for others. Thanks

[@sherriangell6429]

Thanks! One of the best videos I have seen. UpdateIf is my new superpower.

[@aasheira]

Alireza, you really made it so easy to understand and went straight to the point with very easy-to-create data to prove the concept. I was feeling down about Power Apps until I watched this video; now I feel much better. I love how you speak very clearly, and go slowly; that makes it very easy to follow and not have to rewind the play to be able to catch the information. I love the way you make your videos, everything is outstanding and excellent. Keep up the good work 😀

[@dougmenzies8538]

I had worked all day trying to patch and update in my app. This video solved everything for me. Thank you so much for taking the time to create and share this video. I got a little choked up when my app worked.

[@Hypothermia1337]

Big thanks! UpdateIf was the grail i was looking for! So simple and yet very powerful! Thank you Alireza!

[@primepableo]

Of all the many many videos i watched and researched, this was the only helpful resource that completed the project I am working on. Thank you very much Ali! ✨✨

[@DutchNorthAtlanticAlliance]

FINALLY, MY HERO, this is what I was looking for.. ChatGPT en Bing were both useless.. THIS is what I needed.. Much much muchh thanks bro!!! Just bought your course on Udemy too, hooyah Canada!!!

[@ramitkishoresaha9437]

This is a great video, so clear explanation. Glad I watched it.

[@somaliya]

This is a super helpful clip. I didn't know that updateIf is so powerful. I agree with you that the naming is not reflecting the functionality of the function.

[@AlexandrePaivaBR]

Happy to have found this video. Congratulations.

[@djstone5518]

Always the best whether Udemy or KZbin. And yes should be PatchIf. Many thanks Ali. Great video!

[@sherifnabil50]

When i meet someone named Reza i will automatically assume they know Powerapps. But you are the PhD level Reza with this video!

[@AnuragKumar-sz6yw]

Very Well explained!!!!

[@ronbakker1300]

I like these videos that clarify the fundamentals of a control

[@aescamilla]

Very clear explanation and to the point video, thank you for making this video Ali... and yes, PatchIf makes more sense 😄

[@mansb.7574]

Thanks for the nice and comprehensive explanation. As we say it in Farsi, Afarin, Aaali bood !

[@akshaynm]

Hello Ali, as always very fantastic video 😊. I am thinking about the same thing that what is the difference between patch and updateif and when to use them. You explained the concepts in deep 🙂. Thanks a ton as always..!! 🙏🏻🙏🏻

[@shely1618]

Great video, awesome thought process and presentation 👍👍

[@saigonpilots7063]

Wow. You did it like a prof! New sub!!!

[@michalwabnik8851]

Is Updateif a delegable funtion ?

[@dgjanes917]

Nope. kzbin.info/www/bejne/sHqxhXSLf9aEnsk

[@sergipinol3476]

no, it is not... so be careful with UpdateIf with large Datasets... this is the MAIN disadvantage of UpdateIf and the worst part is that there's NO warning at all when used it.

[@LakesidePhil]

Hallo and thx for the very good explanation. Can UpdateIf Create a new dataset if the given condition doesnt exist, similar to Patch?

[@loveandhate441]

Thanks ! So, if I have a DropDown control (related to another SP list) in my form, I can't use SubmitForm, but Patch only ? Correct ? Or perhaps to use SubmitForm for populating MOST of the fields and THEN Patch to fill this ONE DropDown (related to another SP list). Feasible or not ?

[@MMKhat-gl8km]

Hi, I have this error when I submitform my list from power apps: network error when using the patch function: requested operation is invalid. I use submitform to sent my data. Can you help me please.

[@jl1399]

What if the record that you currently have open is the record that you wish to update on the current form?

[@laszlogyor6628]

Thank you for your work.

[@WendersonReisss]

Great explanation! I have a gallery that I need more than one status at the same time using checkbox box. For instance: 10 status "In progress" and I need 5 Status be "Complete" at the same time. Is it possible use this with Patch to Update partially?

[@navyareddy988]

If we have more than 2000 records , udateIf is not working. Please suggest the approach. Thanks in advance.

[@AlirezaAliabadi]

UpdateIf doesn't support delegation. I have an entire course for delegation. I cannot suggest a quick fix unless you are very specific about the problem.

[@MrGaztab]

Hey, great video. So, say I've got 8 text boxes and I want to patch them all to Dataverse, I'm better using UpdateIf? As at the moment I'm having to write individual patch statements for each box.

[@sujeetpandey712]

You are the best!!!

[@rebeccamayer3602]

Basically I have a multi tab form (4 pages) and a dashboard displaying a table where you can view/edit the selected form. Initially I had the issue of everytime I edited a form it created a new item instead of updating existing row… I resolved this by assigning a variable to selected item and then using that variable on submit button. The problem I now have is the submit button is the same for if I’m creating a new form or selecting edit form so now when I try and create a new form it’s editing the previous row!!! I have tried to fix this by adding an IF function on the submit button but I am getting errors! PLEASE PLEASE PLEASE can someone help me as I’m loosing all hope! IF('Non Fraud new'.Mode=0, Patch( 'Disputes List 2.0', varSelectedItem, Form1.Updates, Form2.Updates, Form3.Updates, Form4.Updates ), Patch( 'Disputes List 2.0', Defaults(Disputes List 2.0'), Form1.Updates, Form2.Updates, Form3.Updates, Form4.Updates )); Notify( "data submitted", NotificationType.Success ); Navigate('Sucess Screen')

[@oladman9058]

Amazing!

[@georgewahtaplah6128]

Thanks Ali, UpdateIf has been simplified and you delivered, great explanation! However I am struggling to extend this, I want to update multiple items in a SharePoint list using a gallery with checkbox used to select which rows to update. I want the user to select which records to update but using a gallery which updates the SP list items when the event fires. any tip?

[@thanghuu887]

bulk update

[@kingquadri1850]

Amazing, Thanks

[@danielkomorowski3776]

Nice video

[@kenneth_reyes]

thank you so much

[@Gilgameshx]

Hi Ali, i been practicing with flows for a lil time, and i found a funny situation and i may ask hoping some kind mate reply me. I make a query request from a db, but the json i get has a lot of illegal characters, yet i tried to format it; unfortunally i could'nt find a solution, so if you would kind enough to make a video of how to format json with illegal characters i will thank you so much. Example: [{ "" : ,"key": \"value\"}], something like that

[@mvplay8886]

Nice

[@sergipinol3476]

Be careful with UpdateIf used on large Datasets because it is NOT delegable, so not a good idea to use it when you're not sure there are more items than your delegation limit.

[@AlirezaAliabadi]

It is not an issue anymore. You can enable delegation for UpdateIf and RemoveIf in PowerApps. Check your PowerApps settings.

[@toanuk]

UpdateIf is a great, How about Attachments record in Sharepoint list. How can you use UpdateIf to Update a file to Attachments in Sharepoint list example File called, myFile.pdf In Sharepoint List called MyList( Name: Text, Attachments) In Power Apps: UpdateIf(MyList, ThisRecord.ID = BrowseGallery1.Selected.ID, { Name:myFile.pdf, //Attachments:myFile.pdf(NotWorking) Attachments: Table( { Name: "myFile.pdf", ContentBytes: myFile } ) } ); It NOT working, Why? Attachment column in a data source(Sharepoint list) you are updating expects a 'Table(Attachment)' type using 'Text' type My Question is: What is Attachments Table type.? Please help?

[@AlirezaAliabadi]

I have never done that. Typically when I work with attachments, I use Flow. But this is a good topic for another video. Thank you!