How to Use Power Apps Patch Function

The Patch function is one of the most important functions to master when working with Power Apps. It allows you to add or update records within your data source. At some point you'll realize the form control is a limiting factor within your Power Apps development efforts. You'll start to see scenarios within your application where a form control just doesn't cut it. You may need to do some inline editing with a gallery. I like the Patch function so much more than a form control, that I just don't use the form control anymore. So, stick around all the way through this video and I'll show you all the ins and outs of using the Patch function and I'll show you all the cool ways I use it.

Darren Neese, Microsoft MVP, PowerApps Tutorial

TIMESTAMPS =======================================
0:00 - Introduction
0:47 - What the Patch function looks like
3:28 - Creating our data source (inside SharePoint)
7:45 - Adding the Patch code for new records
12:55 - Now allowing edits for existing records
16:35 - Getting existing data to show up
18:49 - Modifying Patch to edit existing records
20:24 - We need a button for new records
24:50 - Adjusting code to allow for new or edits
28:35 - Testing the application

#DarrenNeese
#PowerAppsTutorial
#LowCode

[TheMattmulherin]

Good job, not rushing through the content. You explain things very well and take the necessary time to go over everything.

[JackCastro]

Always on point with great concise, easy to understand tutorials. Thanks Darren!!

[nevinroyath]

Brilliant explanation of the Patch function Darren. So easily demonstrated. Thank you Darren! Really appreciate these short videos of each of these functions in PowerApps.

[sumitsrivastava]

Thanks a ton!! i went through several videos for using Patch Function - but yours was lucid and really helpful. Keep it up!!!

[WestTV]

Excellent patch demo video. Seen many, and this was very clear and easy to follow. I liked that he was showing how the code links up with the list and controls. Going to use this for my work.

[amrkalammansoori]

OMG! Wonderful, you made it so easy to understand. I clearly understand to use a Patch( ), and you mentioned and covered the minute details aswell like changes in the save button that should be made after getting your Set( ) variable along with adding the If( ) statement. Highly recommended for anyone who is struggling with patch function especially for beginners. Thanks alot Derren for the video.

[jimmyjohn]

You are an excellent instructor. You style is perfect.

[ckwirey]

This is outstanding. The information presented was easy to follow--no guesswork on my end regarding how you got from A to B. As a new coder just learning Power Apps for the first time, this delivery method is invaluable.

[ozarkrunner]

Crappola! After watching this short and excellent tutorial I feel like my patches are all very sloppy. I never thought to use the same patch for new and edit. Thanks for the info!

[ericgamble]

Excellent job! I have watched a number of your videos and just registered for your "Power Apps Masterclass." I'm eagerly awaiting the email to the portal. I like the way you explain things and operate with an assumption that some people have built application in different environments and only need some syntax/development environment guidance. Kudos!!!

[briangrogan]

Darrens video is the one video that made me understand what Patch does and how to use it in Power Automate. Very clear and easy / fun to watch. I took notes because the instruction was so easy but very powerful This one video will help me in my current job

[andreasvanbergen]

Thank you Darren for sharing this info. Just a very small remark, (and I know I am a person that can be really on the details 🙂), nothing big, not really important...but here it is: The camera that is recording you is slightly moving from time to time. Maybe you have putten the camera on the desk that you are working on and is moving sometimes a little bit while typing? That's it....but certainly a great video, you are a real master in taking the audience step by step through the proces! Thank you so much! 👍

[jdvroum]

The best video about the patch. I just search how to focus the gallery on the last item created or updated ? Thanks a lot

[taaee]

Darren, nice explanation. Wiaitng for the next project like "Ticket System".. 🤣 👍

[BikeBallers-vlog]

Wow thanks for the video help a lot in its simplicity ❤

[ranimaharaj-sharma]

Excellent !!.. Thanks for the tutorial

[lospenguin]

Great job 🦅. Enjoy the vids. Form control can def be a pain when you need to customize the user interface.

[lukasztoczyski]

As always amazing content and explanation 💪

[garimaajain]

You explained everything so nicely. I am new to Powerapps and built my first app looking at this video. A small suggestion if I may, please try to zoom in on th code while you are typing in the video, so it becomes a little easy to read it. Thanks again.

[ptr_mic]

I always preferred Patch to Forms. It gives much more control.