How to use PATCH Function in Power Apps | Insert and Update data

In this video, you will learn all about the Patch Function in Power Apps. Patch allows us to insert or update one or more records in a data source, or merge records outside of a data source. Use the Patch function to modify records in complex situations, such as when you do updates that require no user interaction or use forms that span multiple screens.

You will learn how to use the Patch function to Add and Modify items in a SharePoint List, perform error handling with Patch (Formula level error management), set columns to empty value, set complex type columns (Choice, Person) in SharePoint, modify multiple records (bulk operations) in SharePoint by using Collections and Patch, Patch Form Control updates and more.

Patch syntax:
Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ])

Helpful Links 🔗:
Power Apps SharePoint Column Syntax (Lookup, Choice, Person)

PowerApps Patch Function

Patch function in Power Apps (documentation)

Multiple Screen Form Control & Patch in Power Apps

#PowerApps #Patch #SharePoint #PowerPlatform

Table of Contents:
00:00 - Introduction to Patch function in Power Apps
00:33 - Patch with SharePoint List
01:26 - Create item in SharePoint using PowerApps Patch command
04:50 - Patch complex type columns in Power Apps
07:02 - Update SharePoint item column values with Patch
12:25 - Set Blank Value & Error Handling using Patch function
15:02 - Using Patch in Gallery (Power Apps Example)
19:14 - Patch Person, Date & Text columns in SharePoint
23:37 - Bulk operations using Patch
27:56 - Multi Screen Forms using Patch
29:21 - Subscribe to Reza Dorrani channel

🤝 Let’s connect on social:

[paulskelton]

Brilliant! So many fabulous tips and great information, along with an excellent 'ideas' use case thrown in, within such a short timeframe

[shondataliaferro]

Rezza! You be teachin'! Patching, as described by others who shall remain nameless, left me so totally confused and thinking I need to avoid using this functionality altogether. This video as well as your resources have really opened up the concept for me. Thank YOU!

[dougydoe]

Great video with extremely useful content. I've been using Patch but still learnt a great deal watching this video. The various aspects and ways we could use it is really amazing. Thank you for stretching our creative skills.

[waynewei]

Thank you so much for this demo. This is one of the best videos for patch function. This varIdea and blank() really take the functionality to the next level.

[TheFunkBros]

You did it again... once again, I'm trying to figure out how to use another feature and I was stumped until this video and you covered the topics I needed which was the choice column, Thank you for doing more than the basics but covering other topics like different column types. It worked... now my form can update the field with the click of a button which triggers my powerautomate flow which completes the automation of my business service task. Thank you and Please keep doing what you're doing!

[UB-qcyk]

Awesome as usual, you never cease to amaze me. I've been using Patch for some Years now, I still learnt new tips from your video.

[jesterc]

Took me ages to work this out - should have known to come straight here - your examples and real-life solutions are epic!

[kireetiyakkali]

Thanks a lot Reza!
Probably this is the great video on Patch() function that I have ever seen.

[jamesclark]

When I used forall to bulk patch it took almost two hours to do 200 records- almost unusable

This method reduces that time by orders of magnitude

I did have to modify the patch formula to get it to work correctly

For some reason when I ran Patch(SPList, collection) it would create new items instead of changing existing items. I don’t know why

So I found a blog post by Matthew Devaney that provides this formula:
Patch(SPList, ShowColumns(collection, ”ID”), collection) and it worked exactly as I described and very quickly updated almost 200 SP list items.

I appreciate your videos and all of those extra user experience and performance tips that you always provide with them.
Again I am very happy that this works so well. 😊

[MrAbumuhammad]

This is life-saving indeed! I got a breadth of relief after learning this video. Thank you so much.

[SHAli]

Another great, clear and to the point video.
Thanks Reza

[marieraymond]

This is one of most useful videos for me. You're amazing!

[Cordycep]

thank you very much, that column CHOICE for combobox gave me a big headache for more than a week. Also, you help me undestand why I was creating 1 extra blank record whenever I patch.

[merristenzel]

You are amazing, Reza! THANK YOU! I was able to figure out how to make my app work by applying some of these formulas!

[poteaugs]

Such an amazing video... very helpful and love the examples. There are so many hassle things that are summed up by watching your content. Keep up the great work and thank you for helping us out!

[kayodeojo]

Thanks a lot Reza, I really needed this you are the best!!

[luciozanarotto]

This video and others are wonderful. You are great Reza, congratulations!

[oluwatobiyusuf]

Thanks for the great refresher on Patch function.

[barunroyghatak]

Thanks Reza this video is really worthful for beginners.

[mauricioetienne]

Amazing video Reza, firstly I would really like to thank you for all I have learned from you! 🙌🏻 This has really made me set new ambitious goals for my next couple of years…


I just have trouble with the Patching & Updating of the data don’t know why. Followed exactly as your video, maybe there were some updates on coding etc

Either way thanks a lot!