Saving Power Apps Data with the Patch Function

Welcome to this comprehensive guide on saving data with the Power Apps Patch function. In this video, we dive deep into the usage of the Patch function, teaching you how to utilize it effectively to create and edit records in your Power Apps applications. Starting off with setting up a gallery, we then move on to creating a new item using the Patch function. We cover patching various types of columns, including text, number, date, and Yes/No. You'll also learn how to patch from different controls such as text input, date picker, and toggle, giving you the flexibility to move beyond hardcoded values. Towards the end, we tie everything together by showing you how to edit an existing item with the Patch function. This guide is designed to equip you with the knowledge and skills needed to use the Power Apps Patch function effectively. Whether you're new to Power Apps or looking to level up your skills, this video has something for you. Make sure to drop your questions and feedback in the comments section!

0:00 Start
0:47 Setting up a gallery first
3:08 Create a new item with Patch
4:16 Patching a Text Column
6:03 Patching a Number Column
6:55 Patching a Date Column
7:35 Patching a Yes No Column
8:34 Patching from a Text Input
10:04 Patching a Number from a Text Input
11:31 Patching a Date from a Date Picker
12:03 Patching a Yes/No from a Toggle
13:24 Edit an existing item

[chrisbunting]

I watched/read a dozen explanations on how to do this before finally finding my way here. This is the first example that made everything perfectly understandable to mere mortals. Thank you.

[Speeds]

Every time I watch your videos. I think, what a great explanation. Shane, thank you for everything, appreciate you so much. Your knowledge, your explanations and your humour. Thanks mate, you’re a star !

[LatinoTropico]

Hi Shane. If using SQL Server for this demo, just a reminder that the table in the database has to have a Primary Key which has Identity turned ON, for the button to work adding a new record.

[mikatapio]

I rebelliously made my first 2 apps in production using Forms and Submit even though I found out quite early Shane prefers Patch over them. Now, I've decided to step down from the barricades and use the patch function, because it will allow me to create much more user-friendly input screen and help me adjust the visualization of everything. Though if this doesn't serve my purpose I am going back to Forms and Submit. To be continued.

[upgradeaerialphotos]

Hey Shane, this is a great return to the basics for the new generation of Power Apps users! Perhaps, for a follow-up video, you can discuss steps that can be taken to prevent duplicate entries in a datasource when using the Patch function. Thanks for all you do!

[marieraymond]

You saved my life with this video. I was struggling for days to update using a form, and it's using the GALLERY that's the trick. THANK YOU!!!!

[smartwatchicon]

what a awesome video Shane, I finally starting to get the hang of the patch function, all thanks to your video tutorial. I managed to create my own form, which is a milestone for me, I did however wanted to add attachments as our sales reps would like to add photos or video clips, so I added a new form, deleted all the fields, and kept attachments, then added 'editform'.updates after the curly brackets and closed the patch. works like a charm thank you very much.

[dougydoe]

Great refresher on the fundamentals on Patching. I thoroughly enjoyed it. Thanks for sharing.

[oluwatobipaul]

thank you Shane for this refresher video.

[jeanpierreragequit]

it reminds on the very first video i had to watch on the same channel. Always instructive to refresh my knowledge !!

[joaomanoel]

Always helping me with something. Thank you Shane!

[s]

Hi - I would love to see a video (if one doesn’t already exist) - on best practice when dealing with both new items and editing existing items. What’s the default property of the input controls? How do you toggle between showing the selected items’ value when editing and blank them when creating new records?

[Dude]

Great video, thanks! I can't wait to go and get rid of that ugly form control!

[donaldhersey]

1000 thanks - Shane scales up the capability kung fu perfectly here

[simonball]

Another great video Shane. Always good as a quick guide/refresher. Many thanks.

[ashleyhoff]

As a Power Apps Newbie, this is a great easy to follow video.

I'm assuming that using patch will make using a SQL view for display and then using the underlying table to save easier?

[mathiashaaland-jensen]

Great video that really helped me with the Patch function!

[iwfmfms]

Thanks for the video, how to use a function with more than 100 characters of text

[sudhirsimson]

Thank you for sharing the Best Practices. Appreciate it.

[sininv]

hi Shane, this is a great explanation for Patch, can I know where to view the var formula that you mentioned? Thank you