PowerApps Patch Function

[@fidomcvitie9418]

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

[@ShanesCows]

Thanks 😊

[@JonathanExcels]

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

[@ShanesCows]

Glad you liked it.

[@rachelroberts685]

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!

[@ShanesCows]

Very cool Rachel.

[@diegoacevedo1778]

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

[@ShanesCows]

You can do it!

[@paulmoody4599]

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. 👌

[@ShanesCows]

😻 Awesome Paul.

[@swaminawale7386]

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

[@AhmedBalfaqih]

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.

[@ShanesCows]

I appreciate that!

[@wikiexpert]

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

[@ShanesCows]

Glad to help. 😀

[@timrodrigues-ellis]

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

[@ShanesCows]

Patch(datasource, record, {datefield: Today()}) should work

[@craigjenkins6917]

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

[@ShanesCows]

Thank you :)

[@lawrencesproul1541]

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

[@ShanesCows]

Perfect that is one of the things I teach in my training class these days. 😎

[@rachelgriffing7197]

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.

[@ShanesCows]

Thanks Rachel. Glad to help

[@CarlosSolisNow]

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

[@ShanesCows]

Perfect 🤩

[@markpickett5016]

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!

[@ShanesCows]

Awesome Mark

[@lorenasanchez7581]

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.

[@s961201]

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...?

[@ShanesCows]

The same code that works for a button OnSelect should work for OnChange. Maybe post a new comment with your error message you are getting.

[@JT-sr7fp]

Thanks Shane. Probably a simple question but cannot find the solution - How do I patch back information from the power app form to update an existing record in a SharePoint List, instead of it creating new records? Thank you

[@ShanesCows]

Patch(SharePointList, LookUp(SharePointList, formula to get the record you want to change), {ColumnToChange: ValueToSet})

[@danielwatson7974]

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

[@ShanesCows]

Glad to help. 😀

[@capucinevetter8681]

Hi Shane ! Thanks for the video. If we want to Patch in a FormViewer, what would be the record part of the formula. "ThisItem" doesn't work... I have a message error. Many thaks in advance for your answer !

[@ShanesCows]

You would want to Lookup the record you want to patch. You are right thisitem doesn’t work out of a gallery or form.

[@dylanmonson7689]

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.

[@ShanesCows]

I don't know Dylan. I haven't done anything with managed metadata in a long time.

[@garylynch2734]

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.

[@ShanesCows]

Yes. No Gallery required 😀

[@DonD-h3d]

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?

[@juanp.ortizm.3018]

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

[@ShanesCows]

This will show you the way kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@guillaumechandonnet8225]

Hi, i've got a question, maybe i skip that part but, i have a sharepoint list with multiple row, one of the column is a list of communications. One of the other column is call 'Seen by' that will be fill later on with a 'x' when the communication as been seen. How with a Onselect button i could add the 'x' in the SeenBy column based on the communications select in a listbox inside my powerapps? Thanks a lot

[@ShanesCows]

Patch(datasource, listbox.selected {seen you: User().fullname) is roughly it

[@DeadPixelZombie]

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

[@ShanesCows]

AWESOME! Enjoy the bacon.

[@Productivity365]

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

[@ShanesCows]

Glad to help. 😀

[@gympcd087]

Hi Shane! Is there a way that I could type in a color if the dropdown didn't have my favorite color?

[@ShanesCows]

You would have to build functional for that. Or add Other to the Dropdown and if they select that show a text input to capture the value

[@actuallyba]

Hi Shane, how can I adress an existing entry in a Sharepoint list? I have a fix list with employees and want to change the amount of days of leave. I tried the following: Patch(AmountofHolidays;{WorkersName: User().FullName};{Available: 2}. But instead of editing the existing row, it creates a new one. Thanks for out help and greetings from Germany

[@ShanesCows]

You need to add a lookup in the middle to tell it which record. Patch(SharePointList, Defaults(SharePointList),{column:value})

[@actuallyba]

@@ShanesCows Thanks a lot!! It worked!

[@jameskrull764]

@@ShanesCows Hi Shane, I'm having a similar issue. I am updating a table record in a OneDrive Excel sheet but using the SubmitForm button to update a form and calculate an overall average field in my table based on the form inputs. I tried using your command above Patch(Table1, Defaults(Table1), {'Overall Score':(CCValuePropScore.Text* 0.5 + DeliverOutcomesScore.Text*.5)}); SubmitForm(EditForm1) However it keeps on saving a new record instead of updating the record that the form is displaying. thanks for the great content your videos are fantastic! EDIT: Solved this using the following command Patch(Table1, 'Client List Display'.Selected, {'Overall Score': (CCValuePropScore.Selected.Score*0.1 + LOBGrowthScore.Selected.Score*0.1 + RevenuesGrowthScore.Selected.Score*.2 +ClientSatScore.Selected.Score*.25 + DeliverOutcomesScore.Selected.Score * 0.25 + ActivelyTrackScore.Selected.Score * 0.1)}); SubmitForm(EditForm1) The key takeaway is I used the 'Item' value in the Editform card, in my case this was called 'Client List Display'.Selected. It was as simple as calling this variable as the BaseRecord in my Patch command. then using the other fields to calculate a weighted average and update my overall score variable in the OneDrive Excel document

[@TIMEPIECE66]

Hi Shane - thanks for all the great videos! Hoping you will be able to point me in the right direction trying to write the URL of a Picture field in SharePoint (SP). I can save out a picture to a SP Picture Library and get returned the URL to the Picture. I then try to create a new entry in another list that uses the returned URL as the Picture URL of a Hyperlink/Picture field, set to Picture. I'm using Patch, which shows the Picture: field but it fails to write suggesting it is read only. Any hints or suggestions would be most appreciated.

[@ShanesCows]

I don't. I haven't tried that. Boo me

[@TIMEPIECE66]

Ok, thanks but though it was worth asking. Fancy doing a video on it? 😋

[@ResponsibleXI]

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?

[@ShanesCows]

Put it OnSuccess of the form

[@robertz.180]

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

[@ShanesCows]

Glad to help. 😀

[@ResponsibleXI]

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?

[@ShanesCows]

Patch(first list);Patch(Second list) is what I think you are looking for.

[@PACWESTVB]

Thank you for all your great videos! I have been using your videos to help our club manage our own database. I have a question regarding the patch function. When I insert a slider on a gallery and use the patch function on the OnChange, the app slows down immediately and just has the dots going across continuously. Would you be able to help me configure a better way to have the slider make changes without having a save button? Thank you!

[@ShanesCows]

Unfortunately I don’t have a good answer with the slider. 😔 Every step is going to trick on change. Boo. Might have to come up with a plan B. Dropdown instead? Sorry

[@ShanesCows]

Fun fact. I have played and coached club volleyball. Coached a couple of teams that made nationals. Been a long time.

[@PACWESTVB]

@@ShanesCows Awesome! Volleyball is a great sport! I'm trying to make an evaluation tool on passing, setting, hitting, blocking, serving. Something that is quick while the athletes run through. Last season we had 300 players to evaluate. I like the slider for the quick movement, but I think I'm going to have to go with a save button. Does that seem like it might solve the issue?

[@ShanesCows]

@@PACWESTVB yes that would do it. Or use a Dropdown and then you can use OnChange

[@kolbybeck1702]

Shane, are collections persistent? Meaning if a user opens my app on their phone and then on their desktop, will the collection live between the two devices? Or will patching to an entity in the CDS be the best option?

[@ShanesCows]

They are not. If you want the data available you will need to save it to a datasource 😀

[@mustafahussainmohsin320]

Hello, Mr Shane. will that update context variable work for updating the existing record, selected from the gallery? into the form, I am using a patch code on submit button, but when I edit the existing record and press on submit it is creating new records? is that due to variable not used? Please guide!!!

[@ShanesCows]

Try this video kzbin.info/www/bejne/g5TPe5KFbq2pgLM

[@imax8307]

Adding the action buttons/icons within the gallery within this way means that the icons/button visibility changes on all items. Is there a way to have this happen for each item?

[@sonmarl]

I came here to ask the same thing. I was hoping that this would be covered at the end of the video, as this makes the whole form unusable from a UX stand point.

[@altino91255268]

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?

[@ShanesCows]

SelectedText is deprecated so always use Selected.

[@safiyap4085]

Edit Form - How to replace a default control with a custom control? Once custom control is used, how this value can be updated to list on the click of default "save" button?

[@ShanesCows]

This video shows that kzbin.info/www/bejne/amTInJ1rgtGBgLc

[@shoebwk]

Hi Shane, in my display form I am trying to use the Edit button toggle to bring one field in Edit mode but its not moving out of the view mode. Is there any restriction on the display form ? or am i doing something wrong?

[@ShanesCows]

Should work. Maybe check out this video for some hints? kzbin.info/www/bejne/eJ_dkoZ6jtFro6M

[@joan322]

Hi Shane! I have an inventory/order system going on. I have one gallery which I patch the items over to a collection. With the collection I create a gallery to show what the person is going to order from the first gallery. But if they don't want to order it anyway I want them to be able to delete the item from the collection item and the item should be set back into the inventory again. Is this possible?

[@ShanesCows]

Yes use Remove in the gallery to remove the item. Patch the original gallery back at same time if you need.

[@osamaalam6336]

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?

[@ShanesCows]

I show that concept in this video. kzbin.info/www/bejne/foa7kGN3dplgftU

[@zeugnima]

Awesome videos, so useful in helping me understand PowerApps. However my app is loading with my cancel button visible, once I enter and then exit "lets edit " it functions as expected. Is there a way to ensure that the app loads with "lets edit" set to false? or is that even the problem?

[@ShanesCows]

You can set the variable to false when the app loads. Use OnStart.

[@zeugnima]

@@ShanesCows I had tried that using [App>OnStart=Set(LetsEdit,false)] it turned out that I needed to change [visible=LetsEdit] to [visible=If(LetsEdit,true,false)] on my save an cancel icons. I'm not sure if that was a function of using icons vs buttons, but thanks for your help. I wouldn't have gotten nearly this far without the video!

[@remisuszkiewicz5543]

Hello Shane, another great Video from you. I am currently busy with a slightly different question. I want to create an app with a custom form that restores collected data to a list. How is it possible, if it is possible? Thank you in advance.

[@ShanesCows]

I don’t follow. Can you give me more specifics on what you want to do or isn’t working?

[@julianfolino]

I'm on a dead end! Thank you for your videos since they helped me a lot but I've been trying to find a solution and I'm lost. I have a form in the app with a "Submit" button that has a Flow sending all the information entered by the user to the sharepoint list (mostly text so it's easy). But I want also to have possibility to send attachments and Persons (multiple) and as it is not text, I need to use the Patch but all what I see is to update a record already built. I'm not sure how to do it collectively with this submit button creating the record with all inside. Any thoughts??

[@ShanesCows]

I talk about patching complex columns in this video kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@virgolove9274]

Hey Shane, so my issue is that i got everything up and running, however i dont have the drop down option, so i done everything like you did but for my drop down list its only showing my current value selected and not giving me a option from a drop down menu when i press play?....if i create a drop down box outside of the gallery then i can view the drop down options, but the one inside the gallery,wont appear?

[@ShanesCows]

It should work. I would start over and see if you can find the little piece that is out of sorts. Good luck

[@rozhinimani9249]

Hi Shane, love all your videos!!! I have a request for a video 🙏. I have two SPO lists and I want to connect them through a power apps form via a common ID (maybe a GUID)... I’m not sure what the best approach would be. Please help!

[@rozhinimani9249]

To elaborate, the user would fill out form 1 connected to share point list 1 and form 2 connected to share point list 2 in the same app but it would assign the same I’d to both those new record entries to connect them on another screen

[@ShanesCows]

Maybe look at this series. it talks about relationships. kzbin.info/www/bejne/rpjdn55qjdGDedE The key is your going to need to track an ID of some sort. :)

[@Balrog74Fr]

Hi, I'm facing a problem. On my Save button after the patch function I want to add reset and refresh functions. If I split my functions with a ; (french version for the ,) then the code after the ; is not recognized and I have an error about unattended characters. If I split the functions with AND or & like I do for everywhere else the code is recognized but then the button doesnt work at all...

[@ShanesCows]

In French where I use a , you use a ; and where I use a ; you use a ;;

[@CedarRidgeRoughnecks]

Great video! Super helpful for our department. Subscribed! However, was wondering if you could help with one glitch I'm having. I'm running an Edit toggle: OnSelect UpdateContext({EditMyInfo: !EditMyInfo}). I have a save button like in the video: Visible EditMyInfo. Problem is, when I first start the app, the Save button is visible even though EditMyInfo = false. When I go to click on the Save button it disappears. It doesn't seem to be affecting the use of the app but it might be confusing to my users and isn't very professional. I would appreciate any help.

[@prateeksharavi4820]

How do I distinguish between patching an existing record to sharepoint such that it doesn't create a new line in my sharepoint list? How do I differentiate this from when I do have a new form and want to create a new record?

[@ShanesCows]

Patch(datasource, Defaults(datasource), {column: value}) makes a new row. Patch(datasource, Lookup(datasource, ID =1), {column:value}) patches an existing record.

[@cummins75901]

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.

[@ShanesCows]

Yes but complicated. This video will help you get the concept I think. kzbin.info/www/bejne/foa7kGN3dplgftU

[@tribalhunter2978]

Bless your soul for these videos 🙏

[@ShanesCows]

Glad to help. 😀

[@magebol]

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

[@JoshAutomates]

What if I want to click the submit form coming from Values of Text Input, Dropdown, and Choice? How can it be revert back to sharepoint list as new entry. Sample : Title: TextInput.Text Selection : Dropdown_1.Selected.Value

[@MrDonduro]

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

[@ShanesCows]

Sorry I don’t follow the question.

[@iyoung2001]

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

[@johannagemaespinosalazo8855]

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

[@MayankGupta-te3tn]

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?

[@ShanesCows]

Look for my video on ForAll

[@eulama1]

Good Morning! I'm doing your course in Spain, instead of commas I put semicolons and to unite functions instead of semicolons I put &. but putting this function gives me an error when putting them together. Any suggestion? Patch (EmployeeDetails; ThisItem; {Deparments: txtInputDpto.Text; FavoriteColor: DropdownFC}) & UpdateContext ({LetsEdit: false}) thank you!

[@ShanesCows]

I thought instead of & that you should use ;; but I am not sure.

[@Klote3241]

Hi Shane, thanks for your video. i have a question regarding the patch function... i would like a single button to update 2 lists at the same time. so 1 lists keeps information about the user and the other list just registers the amount of people with some sort of counter. for some reason when ever i try to add a second Patch argument i get errors what am i doing wrong :/

[@ShanesCows]

There needs to be a ; between the two patches.

[@Klote3241]

@@ShanesCows yeah for some reason 1 of those ; arent enough.... i have to add 2 ;; then it works.

[@rochellenicholson6372]

Hi Shane another great video. Why would you get the following error when using PATCH, I cant find where the error is coming from. NAME: The specified column is generated by the server and cant be updated

[@ShanesCows]

You are trying to patch an automatically generated column. Like ID or maybe a calculated column in SharePoint. Those columns are read only.

[@rickdesnoyers8978]

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?

[@ShanesCows]

It is a complex column so you have to do it differently kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@StevenNel]

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

[@ShanesCows]

Replace filter with lookup and I think you have got it.

[@neerajcoolcs055]

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?

[@ShanesCows]

Yes. Incorporate an If to determine which want you want the button to do.

[@Nze02]

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

[@ShanesCows]

Glad I could help

[@Stacy-skydives]

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!

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@sa3idi69]

Hi, How can I update multible record in a database using galarey control, for example ( list of student has a check box for attendance the class, I want check the absents then save the all records that I've checked)

[@ShanesCows]

Try my latest video. I show exactly that. 😎 PowerApps ForAll Function - Select multiple records in a gallery and Patch kzbin.info/www/bejne/Zqm9ZZmDf8d_rM0

[@TheZoZoO]

Hi Shane I am looking for video where I want to have a button to get item from SharePoint list in powerapps form.. whenever item is opened It should be in edit mode and 2 columns to enter start date and end date and then need to click on update record

[@ShanesCows]

The LookUp function can fetch a specific record for you. kzbin.info/www/bejne/jWa9Z2SHbreYntU

[@ricci.hidalgo]

I have a simple question: Can the interface you have created in this video have the exact same behavior except that the 2 fields ("Favorite Colour" and "Title") go in edit mode just in the selected item of the gallery when pressing the edit button (the buttons should hide for the all the unselected items)? That would be even a better experience for the user as it will be easier to see which record he is editing (I have seen some phone apps working that way). Also, I would need make the selected item of the gallery higher (keeping the other items with the same high) for making extra space to show additional lookup fields just for that one. If this is not possible (as I suspect), then I will just go ahead and create a separate record editing screen as how the templates work.

[@ricci.hidalgo]

I have just received an answer from PowerApps 911 suggesting me to add the condition "&& ThisItem.IsSelected" in the Display Mode to each "Text Input" component in order to make editable the selected item of the gallery only. Concerning the extra lookup fields for the editable record, it's the same idea; use an adjustable gallery and set the height of the item dynamically to "If(VarEdit && ThisItem.IsSelected, 300, 150)". Thank you PowerApps 911 for your support!

[@ShanesCows]

Glad the team was able to help. 🐶

[@mfsalazar1]

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?

[@ShanesCows]

Yes. Look at forall function. There is actually a working example in the video on repeating tables I released this week.

[@verdijason11]

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

[@ShanesCows]

Maybe this will help? kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@sarankumar3753]

Hi Shane, Its really nice videos. i have learn a lot. if possible can you please do more videos on Flows.

[@ShanesCows]

I will try. 😀

[@sarankumar3753]

@@ShanesCows thanks Shane for your reply. Also if possible do videos on SPFx extensions :)

[@grapegh0stx]

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

[@pennynelson6050]

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.

[@ShanesCows]

Patch(datasource, defaults(datasource), {intcolumn : Value(TextInput.text)}) will turn your text number Into a number number. 😀

[@gwenmac1601]

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.

[@ShanesCows]

Pain in the butt to do. Set(varKey, patch(your stuff).id). This may be my next video. Great question.

[@gwenmac1601]

Thank you will try that.

[@chrisgrubbs6880]

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!

[@ShanesCows]

This video shows it Chris. kzbin.info/www/bejne/foa7kGN3dplgftU

[@Xyz9104_]

Shane ..Excellent video, can you please how do you use collect to write a new record , also if my submit button is using to create , can i also use the same for creating new entry in sharepoint list

[@ShanesCows]

I think I talk about it in this video but not sure kzbin.info/www/bejne/r4SZnoeIodKootU

[@zahidhamidia.h.3246]

Hello Shane, I kinda like have this one problem with the patch function as the "ThisItem" is not detected. I have tried with other screen it worked somehow with my other screen with more columns it does not work. Patch(Utilization, ThisItem,{'Start date and time':StartNew2.SelectedDate,'CT Depth (ft)':DepthNew2.Text,'RIH Weight (lbs)':RIHnew2.Text,'POOH Weight (lbs)':POOHnew2.Text,'WHP (psi)':WHPnew2.Text,'Circulation Pressure (psi)':CircNew2.Text,'PCP (psi)':PCPnew2.Text,'Pump Rate (bpm)':PumpNew2.Text,'Total Fluid (bbl)':TPumpNew2.Text,'N2 Rate (scf/m)':TPumpNew2_1.Text,'Activity Description':DescriptionNew2.Text,'Choke Size (%)':ChokeNew.SelectedText,'Returns (Liquid) %':ReturnsLiq.SelectedText,'Returns (Gas) %':ReturnsGas.SelectedText}) This is my patch function for the screen that is not working. I hope someone could help me with this :')

[@silase.quester3519]

So I realize this video is 2 years old, but for the life of me I can't seem to get the Choices function to work like you did. I write Choices(NameOfList.NameOfColumn) but it just gives me an error and doesn't show anything in the drop down. Any suggestions on why this might be?

[@ShanesCows]

Are you sure you have it pointed at a Choice column? That is the only type of column it works for.

[@beyou7122]

Hi Shane! Very informative video! Following your videos are a great help! I had a query, i have added a label inside the gallery items, which shows the value of true and false based on some values in gallery items. Now i want to push this label text of true/false in a column of SharePoint list ( the same list this gallery is using). Additionally i want to apply this at the OnStart of the app. Below is the formula that i am using: Patch( DataSourceList, thisGallery.Selected, {Column: thisGallery.selected.label1.text}) This is not showing any error but not patching the SharePoint list as well. Please help! This is not

[@ShanesCows]

Try Label1.text without the gallery selected part.

[@beyou7122]

@@ShanesCows i tried, it is still not working.. could you please look into the query powerusers.microsoft.com/t5/Building-Power-Apps/Not-able-to-perform-patch-a-label-for-all-items/m-p/652317#M207659 And this powerusers.microsoft.com/t5/Building-Power-Apps/delegable-alternative-for-IN-operator/m-p/652403#M207703 in community and help on the issue, i need to implement this for my app and i am find of stuck, please help..

[@TYCOON0502]

Hello Shane, i'm trying of patch ane record, updating 2 images of the record, but always get an error who says " The specified column is read only and cannot be modified", however i can't understand how it can be, cause the specific column have all the permissions to edit values... Please, help me i beg you

[@ShanesCows]

What is the column type you are trying to patch?

[@kasfour84]

Trying to batch a person or group column type. Can you assist with that please, as it keeps giving (This type of argument does not match expected type record)

[@ShanesCows]

This video :) kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@cesarherrera7509]

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

[@ShanesCows]

Can you share the code you are using? Might give me a hint to help you. :)

[@kreali75]

Hi Shane. Thanks for the videos! Very helpful. I am stuck.... I'm using an OnSuccess of a form to Patch records from my collection into a child list. The Form (Form1) will submit on 'OnSubmit' and the OnSuccess is set to: ForAll(OneCollection, If(IsBlank(ID), Patch(One, Defaults(One), {Title: Title, Format: Format, UPC: UPC, Explicit: Explicit, ParentID: Form1.LastSubmit.ID}))) So for any new items in the Child List (from the Collection) I am Patching and creating the new item. I haven't been able to successfully get the right syntax for Updating a record in this ForAll and IF statement... ideas? is there a better way? A little more background - my form shows the Parent table fields and then on different 'tabs' (just hiding irrelevant information) I'm displaying relevant child lists (there is one child list per tab) as galleries. Then I can edit the child records inline -- send that to a collection, then I want to update the child list after the form submits. Form: Form1 Collection: OneCollection Table (child table): One (Link to Parent table is ParentID (int field - not a lookup))

[@ShanesCows]

Karen this video shows how I do it. PowerApps Repeating Tables like InfoPath Part 1 - Enter the data kzbin.info/www/bejne/rpjdn55qjdGDedE

[@ShanesCows]

Looking at your code more. I bet the confusion is the column names. Change the names in your collection to be slightly different so there isn’t any conflict.

[@ericcute6471]

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.

[@ShanesCows]

Patch the field. Maybe use Now function to get the current time.

[@tyronewoods7480]

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?

[@ShanesCows]

I made a whole video to help you kzbin.info/www/bejne/d6GWkHiXbq1rmJI 😊

[@MrWonderfulChris]

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

[@aashisehrawat]

Hi Shane, is it possible to update a table from Azure data explorer in power apps? Please share.

[@ShanesCows]

Not sure. I haven’t tried that one.

[@shuoyang8894]

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

[@ShanesCows]

Try this Patch(datasource, Record, {Field: Blank()})

[@basselkosanee1591]

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

[@ShanesCows]

Try this video. Does it help? PowerApps Audit Logging kzbin.info/www/bejne/qn-ulKargZxlodU

[@gerantinahoxha8927]

Hi Shane. All of your videos have been very usefull to me so far. Thanks a lot. I have a question, I would really appreciate if you can helo me.Im using Patch to update a date column in sharepoint. What I do: Patch([@'Gallery']; ThisItem; {Datecolumn: DatePicker.SelectedDate}) but at the end nothing is changed. Thank you in advance

[@gerantinahoxha8927]

Ps: it doesn't show any errors. And when I use it the same way but for e.g with a dropdown, everything works fine

[@ShanesCows]

Patch(datasource not gallery1

[@gerantinahoxha8927]

@@ShanesCows Thank you

[@cbtjoe]

Hi Shane, do you have a video on patching in a Customized Form in a List with multiple screens to collect data? Since it is just one formfor View/Edit/New, how would you create a new record and also be able to update a record? an IF statement maybe?

[@ShanesCows]

Hi Joe. It does get tricky. Email me exactly what you have in mind. Not saying I have the answer but a few people have asked similiar and I would like to understand more.

[@cbtjoe]

Cool... i replied to Nicola last night actually.

[@arnaudcoulon120]

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 !

[@davidbuckman3470]

Hello Shane!! i have a lot of columns in my sharepoint datasource and i used the Patch Function, but i keep on having the red lines indicating errors. please i need your help

[@ShanesCows]

You need to look in SharePoint and get the exact field name from the url. Capitalization and encoding matter. %20 for spaces is an example

[@davidbuckman3470]

@@ShanesCows thank you, did that and I got what I wanted. Thanks a lot

[@NaveenKumar-wf3rf]

Hi Shane, Your videos are useful. And thank you for that. Kindly tell me your Power Apps authoring version. Because some of the syntax & options are different for me when compared to your Power Apps version. My version is 3.20043.21. Thank you!

[@ShanesCows]

What are you seeing that is different? Patch has worked the same for years 😀 The only difference you could possibly be seeing is , versus ; if you are in a region that uses a , as your decimal separator instead of a .

[@NaveenKumar-wf3rf]

@@ShanesCows Thank you. I got it.

[@sanjeevtiwari17]

Thanks Shane for this video.I request you can you please make a video for error handling with Patch function.

[@ShanesCows]

That isn't a bad idea. 😊 Thanks

[@kashiffayyaz6004]

Dear Shane Appreciate your help for Canvas App Can you please guide How can we Patch Potential Customer (Account or Contact)field of Quote in canvas app. As it is simple to Patch lookup field but in case of Potential Customer i am having difficulty. FYI: Example of Lookup shown below Vehicle: LookUp( Vehicles, Vehicle = lstVehicle.Selected.Vehicle )

[@ShanesCows]

Try a .Fieldname after your lookup. Lookup(logic).Id for example

[@karolinaunderwood1039]

hi Shane, any idea why the source data is not being updated with the Patch? What are the possible issues as I have got an error message "This formula has side effects and cannot be evaluated"... Any idea what it means?

[@ShanesCows]

Hey Karolina I don't have any quick answers. Can you paste the full formula here and I can try to guess?

[@karolinaunderwood1039]

hi @@ShanesCows , I have simple SP list as a source data with 3 Single line columns: Title, TM and TPC. My vertical gallery has got label linked to the Tile column and two text boxes (tx1 and tx2), linked to TM and TPC. The formula I am using is: Patch('Testing', ThisItem, {TM:tx1, TPC:tx2})

[@ShanesCows]

@@karolinaunderwood1039 The Items property of the gallery is 'Testing'? Your Patch is Patch('Testing', ThisItem, {TM: txt1.Text, TPC: tx2.Text}) Notice my formula is slightly different than yours.

[@karolinaunderwood1039]

@@ShanesCows 'Testing' is a name of my SP list.... and to be fair, for some reason i can now update the source data with txt boxes but when added new column, Choice column - this errors comes back and Choice column is not being updated. New code is: Patch('Testing', ThisItem, {Colours: ddColour.Selected, TM: txt1.Text, TPC: tx2.Text})

[@ShanesCows]

@@karolinaunderwood1039 Did you Refresh the Power Apps datasource after adding the choice column? Is ddColour Items Choices('Testing'.Colours)?

[@carolerlston3876]

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

[@ricci.hidalgo]

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

[@ShanesCows]

You are welcome 🐶

[@kateschultz2362]

Hi Shane :) I'm trying to figure out how to edit just one record at a time. So instead of clicking edit and seeing ALL items in the gallery switch to edit mode, I just want the selected item to change to edit mode. Is that possible?

[@Djupree1]

I am also wondering how this could be achieved? Did you find a solution?