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

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!

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

Reza to the rescue (again)! I was confused about how to update an existing record in a Sharepoint list as opposed to adding a new record. LookUp was the key and Reza explained it beautifully.

Rezaaaaaaaa Man - You are just amazing!! Earlier I was wondering why people are writing so many appreciative comment. Now I can relate. Hence joining the boat.. Awesome work Man :)

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.

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

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!

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!

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

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.

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.

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.

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

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

Honestly Speaking- My manager asked me to creat a form on power apps and just because of your video i was able to impress him Thank you for such a wonderful knowledge sharing One request as patch does not support attachment plz do something as alternative

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

Hi Reza, very useful and valuable information in the video. Thank you very much for sharing.

Thanks Reza this video is really worthful for beginners.

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

Reza bro.. You are doing a great job. I am a non-IT person, but your videos help me learn new things. You are a great teacher, and thanks for taking tremendous efforts and time to create such knowledgeable videos and that too free. God bless. Loads of love from the 🇬🇧. By the way do you have whatsup group or community to post doubts or sharing best practises.?

Great video. Lots of little thinks that can help us to develop apps in better ways

Thanks Reza. I have replicated the steps explained by you and I created an App for Idea Generation which I would refine as per my use cases. Thanks a lot.

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

Reza Dorrani Always brings us something New

Thanks for the great refresher on Patch function.

Really interesting knowledge .. will come here a lot fot sure

This is Fantastic example... Thanks

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

haha i was looking into patching stuff lately and how to improve my calls..then you posted a vid..nice

I like your way how to describe..never missed any video eventhrough it is beginner level .. there must be something new that i haven't heard. Can you make a vedio ForAll concept with patch statement. Eagerly waiting for that. Thanks in advance

genius! thanks a lot, greetings from Peru!

Very useful information explained..Thanks Reza.

Another great video! I’ve watched a bunch of your videos and I’m still trying to find a particular example that I haven’t found yet. Do you have a video where you explain how to select multiple people and then send them to a SharePoint list in a form, and then also the option to update that entry in a form. I’ve seen examples where there’s just a single person, but I suspect that I need to use a collection for entering multiple people in a single line in a SharePoint list.

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!

Excellent video!

Hello Reza, I saw your video named "How to use Patch function in Power apps" and there you mentioned that if we want to do Bulk update then we need to use Updateif and Patch function and i was trying to accomplish the same in my Power apps. I created a Simple sharepoint list named "Test" and it consist of 4 columns, Title, Requestor (Person type), Approval Status (Choice), Description (Multi line text) and i added some of the records. Now i created a Power app and added a Gallery control that display the records from the SharePoint list and then added a Checkbox control to the Gallery for each record. For the Checkbox control I defined some of the properties: OnCheck: Collect(varstatus,ThisItem) OnUncheck: Remove(varstatus,ThisItem) Default: ThisItem in varstatus Then i added a Combobox control and for the Datasource property i set it to Choices('Test List'.'Approval Status') I also added a Button control and for the button control OnSelect property i set it to: UpdateIf(varstatus,true,{'Approval Status':{Value:ComboBox1.Selected.Value}}); Patch('Test List',varstatus); Clear(varstatus) Now when i am playing the app and selecting two records from the gallery and selecting a Approval status from Combobox control and pressing the Button i am getting the error. What am i doing wrong and why it shows me that Network error when using Patch function: the specified column is read-only and can't be modified

Very Helpful! Great video!

@rezza If possible, Please make videos on Model driven apps use cases too, there are very less content on this topic.

Great video, thank you for the content.

Really nice, thanks Rezza so much

Hi Reza thank you for this video! Would you be able to create a list of column syntax for dataverse?

You’re my boy, Reza

Thank you Reza, learning a lot from you. Do you have the suggestion box app created already? Cant seem to find it

Great Job!

Absolutely love your content, can you please make a guide about document management with library and list!?

Thank you for the video. Bit confused about how we can validate existing record entries in the SharePoint list before we patch the user records. To avoid entry duplication.

Great Video sir thanks

Thanks for the video. It solved my business problem.

great video Reza

Very helpful. Thanks

you save my life sir!

Excelent Video thanks a lot.

Hi Reza and thanks for another great video! If you have the time and energy for it... here's a couple of questions related to the video: 1. On the Bulk update; how can I include the Approval log, date and approver? 2. I want to add a checkbox outside the gallery to "select all"... what's the code for this? Br, Asbjørn Nielsen

that was an epic video

Thanks for your clear explanation! Although I'm still struggling with the patch of a ComboBox: I'm having a work around. But how do I get this in a ComboBox patch line? ComboBox1 > Items Fx = Choices(Locaties.Afdeling) Labels1 > Text Fx = ComboBox1.Selected.Value Buton1 = OnSelect Fx = Patch(Locaties, {Name: Label1.Text}) Thank you!!

Thanks again. I was so stupid using default(data source) when updating a record.

Reza I'm watching all of your vídeos. The information are unique ! One questions. When I see your gallery, I observed that the gallery is filtered by "status" ( on minute 18:49 it' shows only the "NEW") . Could you share how did you do that ?

Thanks Reza for this amazing video to clear most of the doubts. Just one query that can we use patch function to create or update almost 20 to 25 new records in SharePoint list?

Hello, Reza, I hope you are very well!! Please, would you recommend me a video to understand how to make visible and invisible some buttons depending of the user (admin and a common user)?

This is a great video. I'm not sure why but my Patch on my Submit button is not working. I receive an network error when using the Patch function: The requested operation is invalid. This is my third attempt at creating multiple forms to submit a new item to a SharePoint list. My Patch syntax is Patch('Change Request',Defaults('Change Request'), BasicForm.Updates, DetailsForm.Updates, CMForm.Updates) If I'm using the form.updates, do I need to add all the fields between { }?

Thank you Sir.

great video. Thanks Raza. Any chance you can upload step by step video of how you built this app? its a great idea!

Reza - great content. I'm trying to figure out how to set the varIdea variable when I'm using SharePoint integration. I'm trying to patch SharePoint choice field using another list, but submit form is not saving to list

This is a great video. Thanks. I there a way to patch multiple emails in the person column on share point list?

Great,great video.. I have one question regarding error handling: is it possible to have name of the control or ,even better, name of label , where error has happened ( if input value is logner than ti should be ) ? One more thing : can you , please , explain UpdateContext function which is within pathc function of submit button ( at 15:57 ) ? Thanks, you are the best

Hey Reza, incredible video! Is it possible to "write" in new data in a combo box and patch that new data to your data source (Dataverse in my instance - CB is connected to a lookup column)

It is a clear idea, Raza. I would like to ask you for help. How do you Use a Patch Function a Photo (Camera)from Power App To Sharepoint List(Image), Instance Ideas sharepoint list add a column Image? Look forward to showing me Thanks Toan

Very nice video, thank you! One question, I tried submission with patch function, submitted a blank value to a required field, somehow, the system ignores it, not return any error and let me submit the blank value to the list. Any other setting is needed to stop the submitting? Thanks!

Hi Reza, great video! I have created a "Reward App" and I am wondering if it is possible that when a new reward (new form) is submitted that the current number of points in my SharePoint list column is automatically updated with the new amount of points being added when the new form is submitted. Do you think this is possible? I have watched a few videos and browsed the forum but no luck so far. Thanks.

You are awsome!!!!!!!!!!!

Hi Reza, excellent video as always and by far the best patch walkthrough on youtube. If you create a manual form and then patch the results is there a way to then clear the manual form like you would with the form control element itself by using the built in form reset function?

Hello Reza, thanks for this awesome video! I've learned a lot and hope to see more videos from you in the future! I have a very specific question and I hope I can get some insight and help from you if possible! Our company has a manual-entry form that was made in Power Apps , and recently we wanted to optimize it and track the time for how long a specific task is completed in. Our app consists of multiple buttons , so I tried putting some patch function into our button that enables a user to enter a new form( its a button that puts out an empty form and also starts a timer on the screen), but I cant get the data from the form itself ( so the data the user needs to fill in) , I just get a new blank record in my sharepoint list with a start time and when I press submit, with the end time and the time spent as the difference between the two. My main goal is to collect the data in the form ,as well as get the time difference between the start and the end time of the task into the sharepoint list (calculating the time spend). Is there a possible and an easy fix for this kind of problem? Looking forward to more videos like this!

Hi reza, great video , but how do you use drop-down as a selection for the existing column to update from text box inputs . ? to pull and send data same time . ?

Hi Reza, I just want ask regarding 8:26. I currently have a "Data Type: Table" and it is a listbox/checkbox where I can pick multiple items, and varIdea.NameofColumn or varIdea.NameofColumn.Value is not working. How can I apply it on this kind of data type. Thank you! Thanks for making this video it helps me a lot. Looking forward to your next video tutorials!

thank you so much

Great video, as always. But I was wondering why you initialized varIdea with Blank() instead of Defaults(Ideas). Wouldn't that eliminate the need for your if statement when patching?

Thanks!!

Reza, thank you as always for your great videos and insight! I'm attempting to use ForAll to patch a variable and a field from a collection to two SQL columns "savings_request_id", and "basin_id", any thoughts on how i need to change my formula for this to work? ForAll(collPABasinSupplier, Patch(savings_request_basin_xref, Defaults(savings_request_basin_xref), {savings_request_id:varSavingsRequestID, basin_id:BasinID})). It just tells me it's invalid. Thanks again! Beau

Thanks Reza. How can I using Petch update attachments?

Thanks useful content

Thanks Reza

Hi Reza, Thanks for the great video, my app goes through multiple approval stages, I have created the approval history column to contain emails of every user who edited it, but the patch function is only keeping the last email, how can I make it show all emails and not replace the existing user emails with last email only?

Hi Reza, thanks for all your videos! I've learned a lot. For some reason, I am running into a problem when patching back the collection to the sharepoint list. Since the patch function expects 3 arguments and we are only providing Patch(source, collection). It works, but when I close the apps and re-open, there is an error: Invalid argument type (Table). Expecting a Record value instead. If I rename the collection everywhere, then the apps works fine...until I close the app again and rename the collection again. Why is this happening? Thanks

Hi Reza, You are giving us awesome content. could show us how you implemented the count of each record based on Status selected and the Navigation to that particular items.

Your video is very helpful, it helped me a lot. I have a problem in btnexit, when you use patch, it gives me an error in all that part, since (updateif) recognizes it as a record and not as a row, any advice?

Amazing !! I have a similar ask, I've been using 4 fields from excel out of which 3 fields are number format and 1 text. Even though the datatypes are correct, the Patch syntax throws an error. Any help is appreciated. Example- Patch('Table1' ,Defaults('Table1'), {FiscalYear:Value(TextInput_FiscalYear.Text) , FiscalPeriod:Value(TextInput_FiscalPeriod.Text) , Business:TextInput_Business.Text , Forecast:Value(TextInput_Forecast.Text})

On 11:30 aldough I pressed +, Status doesn't go back to NEW (it stays on last choice from gallery that was selected). I did excatly the same, and all works except this one. Regardless on this, thanks once again for great and usefull video Raza.

Tq so much sir

Hi, Thank you for detail video. I had issue where more than one user can try to save data at same time but only one user's data is saved in my SQL table. Will you please help to solve this?

Hello, Nice video, it helped me a lot but except for one problem : what's the good code for patch a mutli select choice column with data from combobox, with items property filed with a data from another SP list ? I have tried with ForAll(DataCardValue.SelectedItems; {Value : Title}) but it does not works. Can i have to use Table() like on your website ?

Hi, thank you so much for this tutorial. I’m trying to get this thing to work in an issue log app. I’m using the gallery selector to search for only Open Status issues for the current user. I’m using With({userEmail: User.Email},Sort(Filter(IssueLog,Status.Value=“Open”,’Created By’.Email=userEmail),Modified,Descending)) as an item filter. For some reason it breaks the default property of the status dropdown. Please help!

Hey Reza, this video is awesome, thank you. I know when you used the person field it reports data back to the data source, but I would also like to display the person's name in my text input field in the form. Let's say the text input name is "txtBox". What would the formula be for me to display the person's full name in there and write back to the data source the same?

Great Video Reza. I have followed the video, but in my case I am using a Combobox. I am facing an issue, where I would like to auto populate a Text Input with the Values from a Combobox. I can achieve my result separately, but how can I achieve this based on the selection of the source in the Combobox? Any ideas?

Thanks sir👍

Hi Reza, your videos are always so helpful! I am currently building a PowerApp with multiple galleries and forms with its data source as a SharePoint list, and have run into a problem when trying to submit the data using a patch function. I've been using the form1.updates, form2.updates, etc. functionality, but whenever a user tries submitting responses on other forms, a new list item is created. Is there a way to save the unfinished forms and then come back later, ultimately submitting the completed forms, without creating a new list entry in my sharepoint list? In other words, I was hoping to implement a save button that spans across four forms and three galleries. The user needs to be able to return to the app after having 'saved' the once submitted/unfinished data to a single sharepoint list item, and then submit their remaining responses using the forms - with their responses falling into the same list item. Thank you!

Hi @RezaDorrani, following the steps outlined in that video but using a dataverse for teams table as source. When I attempt to set the default value of my dropdown it doesn't accept my varName.FieldName.Value. When I look at the variable preview from my formula bar it displays " This data type is unsupported for Ev...", can't see the end of the message but I suspect my issue might come from using the modern dropdown, unfortunately the classic doesn't seem available. Appreciate your help if you know the answer. I'll keep trying and post workaround if I find one here!

Hello reza very good job explaining, can you kindly post your style code

Hi Reza, any dedicated video for variables in power apps?

Great video brother, thank you so much, is it possible to get the file for the idea approval power app please