PowerApps Patch Function 

Shane, your videos are awesome. I only recently started using PowerApps and have learnt so much! The pace is spot on and the delivery style makes things easy to follow and revisit. 👌

Thank you for all of your hard work on these videos! They have been extremely helpful in learning PowerApps from the ground up. Your enthusiasm and expertise make these super enjoyable to watch.

A shortcut for new SP items with a Power Apps form, I used UpdateContext and set the Default Selected value of the choice column to the variable name, then updated the variable before submitting. It works like a charm!

I kept hearing about 'patch' but wasn't really hearing WHAT it was. You explained it clearly. Thank you. Helpful video.

You may forever stay Young. Once again, spot on. I saw other videos by other people, covering the same subject, your videos are miles ahead. Thank you.

Thanks Shane, more than 2 years on and this is still gold!

Because of your videos i'm about to become a hero in my organization. Thanks from Perú, keep it up!

Another great video Shane. This is the type of instructional videos people are looking for. Very informative and again easy to follow.

Great video Shane - I had struggled to get a dropdown control to bind to a choice field from the data source until i watched this one! Really helped out with an app I'm working on where I want to allow users to filter a gallery based on a dropdown value. Thanks!

Great work Shane, your instructions and examples are brilliantly clear!

Thank you! I spent hours trying to work this out. I’ll give it a go.

Your videos have saved my bacon with a project I'm on. Thanks!

I'm fairly new to PowerApps. This was incredibly useful to me. Thank you.

Great video and fun delivery. Looking forward to your next videos.

Just love it. It gave me what I needed to finish an app I built over lunch on Wednesday. Just AWESOM⚡⚡

I simplified your DropDown Patch code by using a separate button to create a NEW record. Basically I used: Set(varRecord, Defaults(DataSource)) which enables lots of cool features such as canceling the new record and reselecting the previously selected record in the gallery...

Thank you, Shane... Your videos are great, you cut to the chase. Awesome work :-)

I enjoyed both, the little tricks and learning about patch ;-)

Hey Thanks for the great video, it really helped me understand patching. I'd like to tweak your example slightly. Is it possible to set a value (text box for instance) in the item in the gallery so that when "Edit" is selected only that item becomes editable? If I use a variable it makes all items editable, which I'm worried will cause some confusion for my users. I've tried making a new column, but then I think that will change everyone's view whenever someone toggles the value. I haven't been able to figure out how to set a value from a button. I've gotten it to work using a toggle to switch back and forth, but that isn't all that intuitive for the user either, plus the patch function is wonky and there's no way to cancel. So far your example is the best of the alternatives I mentioned above, but would really like to be able to make a single item editable at a time. Thanks

Bless your soul for these videos 🙏

Patch(Emp_Info_List, Defaults(Emp_Info_List), { Title: nT.Text, 'First name': nF.Text, 'Last name': nL.Text, 'Fav color': nFC.Selected (

Thank you so much, Shane. I learned a lot from this!

Hey Shane, you are doing amazing work! Excellent man!

I searched for it (Edit Gallery Items). Thank you Shane

Hi Shane, Thank you so much for you videos, these are awesome!! One thing where I am facing issue is, Data Source screen is not coming up the way comes up on your screen. Can you please help from where I can make it visible. It always overlaps with screens.

Finally I got the solution I've been searching for. Thanks alot

Hi Shane, Thanks! every time I learn new trick when watch the video.

Hi Shane. Great Channel! very useful, thanks. I have a question about Patch. I have one button to do a 1s patch/create record, which works well. But when clicking on a second Button, it is creating a new record instead of updating the record I created with the first Button. Both buttons are outside the form in the Layout. What should I do? Thanks

I really enjoy your videos, I have learned so much, thank you!

Shane, many thanks for the amazing video.

Dude, are you a wizard? Thanks for such a great video!

Another great video! Thank you!

Hi Shane! First of all, Great work, This videos really help! I'm stuck on a really tricky issue here. I'm working on a SharePoint list which holds hiring data. In the list, there is a column named "IsInvited" ， which is a choice type data with 2 options, "Not Yet" and "Already Invited". I build an app for this list, and on the detail screen, I insert a button to send an invitation email and to switch this item's IsInvited Choice from "Not Yet" to "Already Invited". Since the button is outside the edit form (In fact the button is on EmailPreview_Screen, we'd like the operator to see the email before he/she send it.) and it naturally can not benefit from the "ThisItem" feature like what you did here. I find it very confusing when trying to refer to the item I want to patch out side the gallery. And the patch function here is really tricky since the Choice type is a complex data type. I tried to find documents addressing this issue all over the internet, and so far there is few. I wonder if you are kind enough to do an episode to really break down the patch function to its core for us new learners. I think a lot of people will appreciate.

Shane, I just saw the "super trick" how many years later, I dunno, math is hard, anyways, super cool and thanks for all you do for us!

Wonderful and useful video, thank you very much Shane for sharing your knowledge.

Hi Shane - this was great - very helpful! In this same example that you have here, can you show how to patch an attachment back to your SharePoint list without using the Azure connection? Thanks

good job shane. I was almost hoping to see you patch a person field entry to the SP list :D

Hi Shane, Great video ! I just discovered Power Apps and I'm learning a lot thanks to you. Still I have two questions : - Is there anyway to have a unique edit and save buttons which patch all of the items at once ? - When saving, some items in the dropdown selections don't display anymore, do you have any solution ? Thanks again !

Thanks a lot Shane for this wonderful video. Learnt too many things from it. In your above example, what if I have one of the fields from 2nd SharePoint list on the same screen and i want to update both the lists with the save button? Do you already have video for that? How do my patch function will look like?

Hi Shane, I am loving your tutorials! Very helpful. I did have a question, I have 10 patch fields on my screen...do I have to reset each one individually after the update context?

Thanks Shane. great video.

HI Shane, is there a way to reference in a Gallery as dropdown items a different list instead of using Choices() and a choice column in the same Sharepoint list? I hate to maintain choices list in the "back end" and I'd rather use a Sharepoint list and create an admin screen to add new choices if needed

Shane, as usual your videos are very helpful. Any way to have the displaymode only change for thisitem when selecting edit instead of the whole gallery? Thanks in advance.

Hi, Shane, another GREAT video. I am using the toggle functions which is super sweat and all works, except I'm continuing to have a recurring issue with my screen refreshing to the initial value. I say recurring only because it's happening elsewhere. I'm actually using the toggle control with the functionality you've displayed here. it all works but when I add an item, it defaults to the previous save position. ie, if I turn it off, then when I come back it's off vs. being on which is the initial setting. Would you know how to fix or what I might be doing wrong? THANKS! Love your videos!!

I admire your videos and the explanations! Is there also a way to work with multiple select choices and patch them to the sharepoint list? The odata.type syntax works perfectly fine but does not support combo boxes and thus neither multiple answer possibilities. Have any idea if this just requires a small adjustment or that it is not possible yet?

Thank you for all the useful videos you upload, I have a question, how to update a record with PATCH referring to the current value of the field, for example to substract or sum the existing quantity of a product in an inventory record; quantity = quantity + 1

Thanks Shane for your help.

This has been a tremendous help to me, thank you so much!

Hi, Shane! Thank you for this video. Maybe this was answered somewhere already, but what's the easiest way of displaying the edit mode for just the item in the gallery where you clicked on the Edit button, so that not all items are switched to edit mode?

Is there a way to patch a date picker field to SharePoint lists? Thank you so much, your videos are very helpful!

Hi Shane, thanks for the patching assistance! If a record exists in the table you're trying to patch, what function/syntax would you use to test that so that a duplicate record isn't created?

Thanks very clear and concise!!!

Hey Shane! thanks so much for your fantastic videos - you are my go-to-guy for everything PowerApps!! I have a question - is it possible to press the edit button and only make the dropdowns/text fields editable just for that one item, rather than all items becoming editable? Thanks again from a viewer in the UK! (you even spell Colour right! :-))

Hi Shane, thanks for share all your knowledge. I have a question. How can you preserve the structure (including dropdown) and collection fields to save a new record from zero? I could do the whole video but I just need that

Awesome video, very helpful. Is it possible to patch all values of a one-column collection into a single cell of the data source record?

Hey Shane, Thanks for taking sometime and responding to my question. Here is another one. I am launching my PowerApps directly from SharePoint list and I am not creating any button on my form. I have one of my columns to be patched to another SharePoint list. Without having to create the button and by using exisitng "Save" option on SharePoint EditForm, how do I use patch function?

Shane, great stuff as always! How can I apply the UpdateContext to ThisItem only in a gallery? For example, if someone clicks edit on item 1 in a gallery, it only brings up the save/cancel button in that item only and it disables the other items or puts them in view mode only. Thanks!

Good Video. I have a performance problem with a Patch for many records. I try to bulk insert into a SQL Database for a 64 records by user.

Thanks for the video! I want to known if you can have the button out of the gallery for not repeat it in each item in the gallery. If its possible to have just one button to save all the items?

Thank you for sharing your videos Shane. I am trying to build a logging activity for my application; I have created a record when a new user sign in to the main page (On Visible) but I do not know how to patch other statements to the same record especially more than one person are using the application. I do not want to update because I have to keep tracking of what this person has been doing during the time of using the application ...

Hi Shane, this is really helpful video. I just have another question, is there anyway that we can Patch a Blank() value back to the data source? sometimes when a column is cleared, then the data source can reflect the same thing. Many thanks!!

Cool video!!! Helpful hints!!!

Shane, Your videos have been a huge help. I've been learning a lot! I have a question about Collect/Patch- Is there a way to collect data into my sharepoint file from a Text input box? For example, if my radio button which has Yes,No,N/A- If No is selected, a text input allows explanation. Can that explaination be transported into the sharepoint file?

Hi Shane, Great help to new beginners. 1 doubt I have - can patch be used on a single button to perform either edit or insert new record?

Hey Shane, I love your videos. I've learned a lot. Question: How come you use Updatecontext for the Letsedit button instead of say setting Set(varEdit, false)?? Like I said, I'm learning so no judgement, I just dont understand why or when we would use one over the other unless they're interchangeable. Thx

So informative and entertaining. Also, what if we want the edit display mode to only appear in the item where we pressed edit, instead of all?

Hi Shane! Thank you so much for this video! But when it comes to patching, is there a way for us to check on what percentage is our patch at? Or check whether the patch is completed or not and if not can we rollback? Also it would be wonderful if you could discuss the technical features of Patch (ex how many bytes does it consume during a patch, where does it go when it fails, how do we ensure that the patch pushes to the datasource) appreciate the help!

Thanks for all the videos Shane; Is it possible to use patch to somehow overcome the 20 item limit using Choices() for a managedmetadata column? This is a tough limitation for what i'm trying to accomplish.

Hey Shane, thanks for all your awesome videos, really helps a lot. Quick question, my SharePoint list column name has a single quote, for example, "Special Instruction / KPI's" and when I try to patch it with " Patch('Client Briefs',Gallery2.Selected, {'Special Instructions / KPI's', DataCardValue35.Text} " it comes up with an error saying the column name does not exits. I am thinking of changing the column name and trying again, but my whole power apps is built already, and I fear if I change the column name, it will affect my app. Please help.

Colour - way to go Shane!!

Hi Shane, thanks for another great video! Question: I have a 'person' field (SP List) that I'm trying to change for a selected gallery item. ThisItem isn't available and the Lookup function doesn't appear to update the record when using a Button with OnSelect. Any thoughts?

Great video Shane! Just wondering instead of having Edit button for each gallery item, is there a way to have 1 submit button for the full gallery and save all gallery items ?

Hi, great video. I want to thank you for your dedication, I have a question, if I want, in a combobox show all the users of my office 365 and save it in a user type field of a sharepoint list, how can I achieve it, using patch? Thank you very much

Hello Shane, thank you for this useful video, I only have a question, I struggled to do the same yo did with cancel and edit, in my case with different icons(edit and cancel hover), could you please give me an idea , how can I do a toggle with icons. I'll really appreciate it.

Hi - love your videos! Thanks a lot. In your patch example in this video - is it necessary to patch via a button when you have made a selection in a dropdown? I'm trying to patch using the "On change" event/property of the dropdown. But iut won't let me. I have a gallery of cost saving hypothesis in my business. I would love to be able to assign status (Initiated, In progress, Needs clarfifications, Closed etc) on the go in my gallery browse/list and have my excel table updated with the correct status whenever I change the value in my drop down lit. Was I able to make myself understood here...?

HI Shane can you use this functionality with out using a gallery? The gallery is limited by size (height) ps in 2 months you have really lifted my knowledge in this so much thank you.

Very informative, Video Shane, i have replicated your instructions but within another form sort of a parent child form, the issue that im running into it that the gallery will update all the item as opposed to just one, have you had any issue like this where you update one but a few seconds later the rest update to the saved value/text. any ideas to point in the right directions would be greatly appreciated. Thanks Cesar

Hi Shane, Again a great video .. Thanks. Do you know why my gallery resets to the first item after patching? 2 Sharepoint lists, want them both to be updated, works great the first time ., after updating the gallery reverts to first item, not the selected one.

THANK YOU !! YOU'RE THE BEST

Great stuff! Would be nice to see an example on how to copy a record from a gallery or a form and create a new item... :)

Shane - your videos are fantastic. I am trying to achieve something similar to what you are doing, rather than updating one value at a time can we update multiple rows within SharePoint with just a button click. E.g. can you provide 1 button that updates all the records with favorite color as red?

Thanks for all the great videos! I have a question regarding this function: I'm trying to do this outside of a gallery, I do have a gallery linked to some display forms, I want to add a counter to the side which updates the SharePoint column of a specific item. So far I have this: Patch('MFG Master List', SearchQuery.Selected, {QtyComplete: CountBox.Text}) My problem is the second bit there, "ThisItem" wouldn't work as this button & field is outside of the gallery but I don't understand how to address this so it is updating the QtyComplete for the item I want.

You've been a life saver Shane...question for you: Is there a way that when you hit Edit, only the Submit/Save button pops up for the card that you want to edit in the gallery? I like the function but for every card I hit edit on, it shows the Save button in every card of the gallery. Little confusing for my users. Help! :)

Awesome Video! I am trying to update all rows of a column in excel to a default value when the powerapp loads up. Any idea how I should do that?

Really helpful video!

Shane, another great video! I'm trying to recreate using a Date field (Insert DatePicker) and two Number fields (Insert TextInput of Format Number) . My Patch function gets "An unknown error" whenever I try to run. My Save button OnSelect = Patch('Support Tracking',ThisItem, {Date: inputDate, Influence: inputInfluence, Support: inputSupport}) I modified the OnSelect to try to Patch with just one of the fields (e.g. Patch('Support Tracking',ThisItem, {Date: inputDate}), and i keep getting the same error, regardless of which field I try to Patch, in any combination. Any thoughts?

Hi Shane, First off, your tutorials are epic. Really helped me get started with PowerApps. I have a quick question: I am using a Gallery to collect data sort of like your Shopping Cart tutorial. What I want to do is search a sharepoint list for a record using data from a collection to find the record to patch in SharePoint. Below is my function: Patch('Demo Stock'; Filter('Demo Stock'; PartNumber = ThisItem.Code; SerialNumber = ThisItem.Serial); {ItemStatus: "Available"});;Refresh('Demo Stock');;Remove(LoanItems;ThisItem) I'm getting an invalid argument type (Table) error with the patch function and I am assuming its got to do with the filter. Im sure its something simple? Cheers

Fantastic Video like always

Hey Shane, great video! I am looking to a patch with a form instead of a gallery. Any tips on what function to use instead of 'thisitem'?

Hey Shane, do you know what the syntax would be to add a checkbox value from SharePoint instead of a choice field (i.e - Choices(Employees.FavoriteColor))?

Hi Shane, learning lots from your videos, after adding a record to a data source using the Patch function how can I retrieve the primary key that was autogenerated.

Hi Shane, How secure is patching to SharePoint when it is within a business? Is there any risk with the data? (Side note - these videos are amazing! I have taught myself so much using these videos!)

Thank you for your hard work. Just a question though is it possible to patch all entries similar to SubmitForm? I just want to "Save As" during EditForm and I do not know any other method rather than patch but with many fields (over 100) I find it irrational way sadly

Thank you Shane. Just one query, if we want to save all list items of a gallery by just clicking on the update button, how can I do that?

I am having trouble trying to patch to a column in my database that is an integer. any ideas?. I am .new at this powerapp stuff and your videos are really helpful.

Oá Shane, as always your videos are fantastic. Will you allow me to answer some questions? 1st You used the Choice function, as follows "choice (fontededados. Column) this form is only for complex columns? 2 ° When should I use Selected or Selectedtext?

Hi Shane, Thanks for your videos. Can you help me please. I am creating Time In and Time out of a visitor. How can I update the column data Time out in an existing list in SharePoint in the same row using powerapps? Thanks again.

Hi Shane, great content! When i try to use the Patch function it does not allow me to use "defaults" or anythin after Patch for that matter. If i go Patch(listname, Defaults(listname), it does not register anything after Patch(listname, unless i use something else than a comma? Do you have any experience with this issue or perhabs any advice? :)

Great work!

Thanks very much, bro!