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!
Im happy to hear this video is simple and effective. I try very hard in each video to make sure I make it simple for everyone. Thanks for the feedback.
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. 😊
Thanks James! If collection contains the unique key of the data source (lets say ID in SharePoint), then it will update the item. If it does not find or ID is blank in collection, it will create a new item. You can also check ruclips.net/video/VzrarcM9W5k/видео.html
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.
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
Glad to hear the video was useful. Patch does not support attachments. Alternatives are form control or call flow from power app. I have done many videos related to form control and ones for attachments. You can check those.
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.
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!
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 :)
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.
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.?
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.
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
I have not come across this issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
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!
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
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.
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.
@@RezaDorrani I have a query regarding the Sort Function. I tried to Sort the Gallery with Sort('Work Tracker Test',Status.Value,SortOrder.Ascending). But the issue is that, it has thrown me delegation error. Can u please suggest how to get rid of this delegation error. From your other videos, I understood what exactly Delegation is all about and how it is useful. Thanks for clear explanation. U have displayed Delegation concept in FILTERING Gallery items (ruclips.net/video/zxZGaXQlZqo/видео.html). Can u please help in the case of SORT too.
@@RezaDorrani Thanks, please, Would you mind giving me a clarification? I was trying to get the information from a dropdown with Status: {Value."field_name".Selected.Value} but appear the next message: The argument type 'crf47_usuario' doesn´t match with the expected type 'OptionSetValue'. Type found 'Record'. Please, help me.
@@RezaDorrani You have the list of syntax for referencing complex columns in sharepoint, do you have syntax for referencing complex columns in dataverse?
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.
I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my RUclips channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
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!!
Life doesn't always have to be difficult! :) Solution: ComboBox2 = Items Fx = Choices(Locaties.Afdeling) Button2 = OnSelect Fx = Patch(Locaties, {Name: ComboBox2.Selected.Value}) Thanks again for your excellent video's!!
@@RezaDorrani Respect for all your hard work and follow up on RUclips!! It's not certainly not common for people with the knowledge that you have to do so!!
I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my RUclips channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
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
1 - Do not remember much of this video but if its a collection performing bulk update. You would need to include the details in that collection. Simply update collection with those details. 2 - I have done a few videos where I have shown the code for select all. You would need to check those (I do not specifically remember which one)
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?
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.
Thanks for liking the video. As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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)?
Patch emails? I dont think there is any such option. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani I appreciate the quick response. Thank you. I will check the forum but perhaps I didn't put my question correctly. Looking at how you patched one person to the "Person" column type in share point, I was asking if we can patch multiple persons in the "person" type column on share point using the patch function. Or more specifically, patch an array of multiple approvers from power app to a share point list person type column.
@@kwamebuanyinaohemeng919 For that you would need to pass a Table of those values similar to multi select columns of type choice or lookup. Video description has link to my blog which shows an example of multi select lookups and choice. Similar pattern is needed for Person. I do not have a specific video reference on it though.
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 . ?
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 ?
By using filter function. Filter(datasource, columnname.Value = “New”) Assuming column is a choice column. I have done plenty of videos on gallery filter. I will recommend checking them out.
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
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!
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)
Not out of the box. It would need some form of custom logic to check if value entered exists and if not then patch it to related table. Not something I have attempted.
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
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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
1 - I am not sure if there is an option to do that. Not something I have explored. 2 - The App was built from an existing template in Power Apps (its an out of the box template) That template already had those updatecontext variables set.
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 { }?
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my RUclips channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
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.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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?
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!
Not sure about this since I have not come across this issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
I noticed that the combo box doesnt work with this technique with the Global Variable in "Default", but works well with dropdown list as Reza is doing. Just in case someone is using combo box for their patch.
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.
I do not have a video reference on this scenario and would have to try it out to provide guidance. Forums will be your best bet. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
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!
Thanks so much. I do not have any specific video references on your scenario and not sure what the reason for your issue could be. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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
I do not have a video reference on sql scenario and would have to try it out to provide guidance. I recommend checking or posting your query on the forums at powerusers.microsoft.com/ in case someone has done something similar.
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?
I do not have any video references on this and none with sql. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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?
You can set all the controls reset property to a boolean variable. Then when you want to reset the controls, set(varReset,false);Set(varReset,true); and you should be good to go.
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?
@@RezaDorrani I thought the Blank() was to remove the selection of the gallery, cause if you use Defaults(Ideas) then varIdea has a value? and then the coalescing would not work.. but I am no expert so I could be wrong :)
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})
I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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, 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!
I would have to look at your App in action to know the cause for your issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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!
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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?
Try “controlname.selected.” And intellisence will guide you through. Controlname is name of combo box control for person in form. If person column is storing all details of selected person, why do you need another column to store full name?
@@RezaDorrani Hmm, I just want to show the person in the app itself rather than only in the database. My team won’t view the back end, and they will need to see on the front end who enters the info. Hopefully that makes sense lol thank you for your help!
@@vidabailey16 Yes, but for that you don’t need to save it as person and display name. You can simply use person columns display name property to show value in App
@@RezaDorrani no actually certain logics and codes you have entered in the second one is bit different i guess, so if possible pls let me know, if not , it aint a issue, i m grateful already for all the contents you share and damn u read and respond to all msgs
@@usmanwaleed3612 Its minor updates and I always keep updating the same apps. So it will not be in the state + data source is something I cannot share.
Welcome! This was done some time ago and the app was based on an existing template. Had made minimal modifications to it. I no longer have access to the app.
Is there any video on how to create a login experience where if person is admin it will show different screen and if it is user it will show different screens
I do not have a specific video reference on that but I did videos around role based security. Check ruclips.net/video/J-hMMXrKMVE/видео.htmlsi=DmYYnvMwYMs5EDTN
Brilliant! So many fabulous tips and great information, along with an excellent 'ideas' use case thrown in, within such a short timeframe
Thank You Paul
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!
Im happy to hear this video is simple and effective. I try very hard in each video to make sure I make it simple for everyone.
Thanks for the feedback.
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. 😊
Thanks James!
If collection contains the unique key of the data source (lets say ID in SharePoint), then it will update the item.
If it does not find or ID is blank in collection, it will create a new item.
You can also check ruclips.net/video/VzrarcM9W5k/видео.html
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.
Reza says Thank You
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
Glad to hear the video was useful.
Patch does not support attachments. Alternatives are form control or call flow from power app.
I have done many videos related to form control and ones for attachments. You can check those.
Took me ages to work this out - should have known to come straight here - your examples and real-life solutions are epic!
:)
me too... this is the 2nd time for me.... from now on I'm coming to this guy first!
@@TheFunkBros Thank You both
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.
You're most welcome!
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.
Glad to hear that! Thanks for watching
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!
Wow! Thanks Barney for the amazing feedback. I will keep trying my best.
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 :)
Thank You so much Gaurav
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.
Glad you enjoyed it!
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.?
Thank You so much!
No whatsapp group or direct line 😊
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 to hear!
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
I have not come across this issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thanks a lot Reza!
Probably this is the great video on Patch() function that I have ever seen.
Wow, thanks!
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!
Most welcome!
This is Fantastic example... Thanks
Glad you liked it!
Thanks Reza this video is really worthful for beginners.
Glad to hear that
Hi Reza, very useful and valuable information in the video. Thank you very much for sharing.
Most welcome
Really interesting knowledge .. will come here a lot fot sure
Thanks and welcome
This is life-saving indeed! I got a breadth of relief after learning this video. Thank you so much.
You're most welcome!
This is one of most useful videos for me. You're amazing!
Glad it was helpful!
Reza Dorrani Always brings us something New
Thanks
Thanks for the video. It solved my business problem.
Most welcome
Great video. Lots of little thinks that can help us to develop apps in better ways
Glad to hear that! Thanks for watching.
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
Im not a fan of forall and patch. I use collections and bulk update. I have done multiple videos on it.
@rezza
If possible, Please make videos on Model driven apps use cases too, there are very less content on this topic.
Not in my immediate plans.
You are amazing, Reza! THANK YOU! I was able to figure out how to make my app work by applying some of these formulas!
Fantastic!
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.
Most welcome!
I do not have a video reference for that. Concept would be to use collections.
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.
Glad it helped!
@@RezaDorrani I have a query regarding the Sort Function. I tried to Sort the Gallery with Sort('Work Tracker Test',Status.Value,SortOrder.Ascending). But the issue is that, it has thrown me delegation error. Can u please suggest how to get rid of this delegation error.
From your other videos, I understood what exactly Delegation is all about and how it is useful. Thanks for clear explanation. U have displayed Delegation concept in FILTERING Gallery items (ruclips.net/video/zxZGaXQlZqo/видео.html). Can u please help in the case of SORT too.
You cannot sort directly on complex type columns (delegation challenge).
Check ruclips.net/video/6KlI1iZ_KD0/видео.html
This video and others are wonderful. You are great Reza, congratulations!
Thanks Lucio
Thanks for the great refresher on Patch function.
Glad to hear that. Thanks for watching.
Very useful information explained..Thanks Reza.
Most welcome
haha i was looking into patching stuff lately and how to improve my calls..then you posted a vid..nice
Hope you enjoyed it!
Excellent video!
Thanks Scott
genius! thanks a lot, greetings from Peru!
You're most welcome! ❤️ Peru
@@RezaDorrani Thanks, please, Would you mind giving me a clarification? I was trying to get the information from a dropdown with Status: {Value."field_name".Selected.Value} but appear the next message: The argument type 'crf47_usuario' doesn´t match with the expected type 'OptionSetValue'. Type found 'Record'. Please, help me.
@@zanguinetti8612 I will recommend posting your issue with screenshots on forums at powerusers.microsoft.com/
great information, Reza, it not only is going to help me with this question but another questions in the future.
You’re my boy, Reza
Thanks
Hi Reza thank you for this video! Would you be able to create a list of column syntax for dataverse?
I did not understand your question
@@RezaDorrani You have the list of syntax for referencing complex columns in sharepoint, do you have syntax for referencing complex columns in dataverse?
@@bobbyw1074 I have a playlist on dataverse. I may have covered Patch in one of the videos.
@@RezaDorrani oh great. I’ll look for that video. Thank you!! I love your videos!
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.
There is no inbuilt feature for duplicate detection.
Great Video sir thanks
Welcome
Thank you Reza, learning a lot from you. Do you have the suggestion box app created already? Cant seem to find it
It is a template app in power apps. learn.microsoft.com/en-us/power-apps/maker/canvas-apps/open-and-run-a-sample-app
@@RezaDorrani Thank you for pointing me to it. Appreciate you!
Thanks a lot Reza, I really needed this you are the best!!
My pleasure!
Thanks again. I was so stupid using default(data source) when updating a record.
Everyone is learning! Keep going.
@@RezaDorrani yes ! :)
Absolutely love your content, can you please make a guide about document management with library and list!?
I make videos when I get multiple requests on a particular topic.
Every quarter I ask subscribers for topic suggestions on the Community Tab of my RUclips channel.
Subscribers vote for topics and the highest voted topics get added to my backlog.
Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
Another great, clear and to the point video.
Thanks Reza
My pleasure!
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!!
Life doesn't always have to be difficult! :)
Solution:
ComboBox2 = Items Fx = Choices(Locaties.Afdeling)
Button2 = OnSelect Fx = Patch(Locaties, {Name: ComboBox2.Selected.Value})
Thanks again for your excellent video's!!
Looks like you got it worked based on your response comment
@@RezaDorrani Respect for all your hard work and follow up on RUclips!! It's not certainly not common for people with the knowledge that you have to do so!!
great video. Thanks Raza. Any chance you can upload step by step video of how you built this app? its a great idea!
I make videos when I get multiple requests on a particular topic.
Every quarter I ask subscribers for topic suggestions on the Community Tab of my RUclips channel.
Subscribers vote for topics and the highest voted topics get added to my backlog.
Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
@@RezaDorrani Thanks for the detailed answer. I will follow-up on this.
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
1 - Do not remember much of this video but if its a collection performing bulk update. You would need to include the details in that collection. Simply update collection with those details.
2 - I have done a few videos where I have shown the code for select all. You would need to check those (I do not specifically remember which one)
you save my life sir!
Wow! Happy to have helped
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?
Possible. I have done multiple videos on bulk updating data. Look for these videos in my Power Apps playlist.
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.
Thanks for liking the video.
As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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)?
Check ruclips.net/video/J-hMMXrKMVE/видео.html and ruclips.net/video/fbDQH0vIsN8/видео.html
Best to check my playlists
This is a great video. Thanks. I there a way to patch multiple emails in the person column on share point list?
Patch emails? I dont think there is any such option. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani I appreciate the quick response. Thank you. I will check the forum but perhaps I didn't put my question correctly. Looking at how you patched one person to the "Person" column type in share point, I was asking if we can patch multiple persons in the "person" type column on share point using the patch function. Or more specifically, patch an array of multiple approvers from power app to a share point list person type column.
@@kwamebuanyinaohemeng919 For that you would need to pass a Table of those values similar to multi select columns of type choice or lookup. Video description has link to my blog which shows an example of multi select lookups and choice. Similar pattern is needed for Person. I do not have a specific video reference on it though.
@@RezaDorrani Sounds good. Thank you for the response.
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 . ?
I dont have a video reference on that scene so not sure
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 ?
By using filter function. Filter(datasource, columnname.Value = “New”)
Assuming column is a choice column.
I have done plenty of videos on gallery filter.
I will recommend checking them out.
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
Image column is read only as of today (from Power Apps)
Great Job!
Thank You
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!
Thanks for watching and learning from the videos.
I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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)
Not out of the box. It would need some form of custom logic to check if value entered exists and if not then patch it to related table. Not something I have attempted.
@@RezaDorraniahhh, maybe i'll go another route, lol. Appreciate the quick response and very informative video though!
Very Helpful! Great video!
Thanks
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
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you Sir.
Most welcome
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
1 - I am not sure if there is an option to do that. Not something I have explored.
2 - The App was built from an existing template in Power Apps (its an out of the box template)
That template already had those updatecontext variables set.
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 { }?
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks Reza.
How can I using Petch update attachments?
Patch does not support attachments
Really nice, thanks Rezza so much
My pleasure!
Very helpful. Thanks
Thanks for watching
Make a video Using Dataflow how to Add data to Dataverse Table when a new file is uploaded
I make videos when I get multiple requests on a particular topic.
Every quarter I ask subscribers for topic suggestions on the Community Tab of my RUclips channel.
Subscribers vote for topics and the highest voted topics get added to my backlog.
Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
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.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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?
Append the data. Get last value and concatenate with current value and then patch.
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!
Not sure about this since I have not come across this issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Great video, thank you for the content.
Your most welcome
I noticed that the combo box doesnt work with this technique with the Global Variable in "Default", but works well with dropdown list as Reza is doing. Just in case someone is using combo box for their patch.
Thanks for sharing
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.
I do not have a video reference on this scenario and would have to try it out to provide guidance. Forums will be your best bet. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
great video Reza
Thanks
Excelent Video thanks a lot.
Glad you enjoyed it!
thank you so much
You're welcome!
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!
Thanks so much.
I do not have any specific video references on your scenario and not sure what the reason for your issue could be.
I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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
I do not have a video reference on sql scenario and would have to try it out to provide guidance. I recommend checking or posting your query on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani not a problem, thanks for your reply!
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?
I do not have any video references on this and none with sql. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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?
You can set all the controls reset property to a boolean variable.
Then when you want to reset the controls, set(varReset,false);Set(varReset,true); and you should be good to go.
@RezaDorrani a great video
Hello reza very good job explaining, can you kindly post your style code
Style code for Power App?
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?
Honestly I do not recollect why I had done that :)
@@RezaDorrani I thought the Blank() was to remove the selection of the gallery, cause if you use Defaults(Ideas) then varIdea has a value? and then the coalescing would not work.. but I am no expert so I could be wrong :)
@@AndrewTSq Honestly, I would have to revisit the video to refresh my memory.
Your outline sounds right.
that was an epic video
Thanks
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})
I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Tq so much sir
Welcome
Hi Reza, any dedicated video for variables in power apps?
I have used variables in plenty of my videos but do not have a dedicated video on variables
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
I will have to look at your App in action to know why. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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!
I would have to look at your App in action to know the cause for your issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks for your suggestion sir! I posted it on the forums.
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!
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
You are awsome!!!!!!!!!!!
Thank You
Thanks useful content
👍
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?
Try “controlname.selected.” And intellisence will guide you through.
Controlname is name of combo box control for person in form.
If person column is storing all details of selected person, why do you need another column to store full name?
@@RezaDorrani Hmm, I just want to show the person in the app itself rather than only in the database. My team won’t view the back end, and they will need to see on the front end who enters the info. Hopefully that makes sense lol thank you for your help!
@@vidabailey16 Yes, but for that you don’t need to save it as person and display name.
You can simply use person columns display name property to show value in App
@@RezaDorrani Thank you! What should I type?
@@vidabailey16 I will have to try it out myself to give you step by step guidance. Il recommend posting your query on forums powerusers.microsoft.com
Thanks!!
Welcome!
Great video brother, thank you so much, is it possible to get the file for the idea approval power app please
Thats based on a template. You can check power apps templates.
@@RezaDorrani no actually certain logics and codes you have entered in the second one is bit different i guess, so if possible pls let me know, if not , it aint a issue, i m grateful already for all the contents you share and damn u read and respond to all msgs
@@usmanwaleed3612 Its minor updates and I always keep updating the same apps. So it will not be in the state + data source is something I cannot share.
@@RezaDorrani ok , thx
Hi Reza, First of all, thanking for this awesome lesson.
Could you please the zip file for the suggestion box app which you demonstrated?
Welcome!
This was done some time ago and the app was based on an existing template. Had made minimal modifications to it.
I no longer have access to the app.
hello reza, mind if you can show the functionality of how a button is only visible to an admin or a user only?
ruclips.net/video/J-hMMXrKMVE/видео.htmlsi=Uqzqlxff7f3nLz1c
Thanks Reza
👍
Is there any video on how to create a login experience where if person is admin it will show different screen and if it is user it will show different screens
I do not have a specific video reference on that but I did videos around role based security.
Check ruclips.net/video/J-hMMXrKMVE/видео.htmlsi=DmYYnvMwYMs5EDTN