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

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

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

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.

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 😀

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

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! ✨✨

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..!! 🙏🏻🙏🏻

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!!!

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.

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

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

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

I like these videos that clarify the fundamentals of a control

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

Great video, awesome thought process and presentation 👍👍

Happy to have found this video. Congratulations.

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

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

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.

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?

You are the best!!!

Thank you for your work.

Amazing!

Amazing, Thanks

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 ?

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

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?

thank you so much

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.

Nice

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

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')

Nice video

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

Is Updateif a delegable funtion ?

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.

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?