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
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 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.
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.
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!
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.
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.
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.
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.
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
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.
@@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.
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 believe that is an html control where value is displayed. You can write simple html code and change color attribute based on the value. I do not have a specific video reference for it though.
@@RezaDorrani You have the list of syntax for referencing complex columns in sharepoint, do you have syntax for referencing complex columns in dataverse?
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
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
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.?
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
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
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
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.
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.
I wish PowerApps let you go further into the data, like console.log() in js. So I have a few questions, that I dont understand. At 00:27:00 you use a function called UpdateIf(colIdeas, true.... what is checked if its true here? Does true simply mean if colIdeas containes values, then its true? then you use Patch(Ideas, colIdeas), how does it know which row in the list to update? cause I've used Patch(db, LookUp(db, title = my row I want to update), but Patch(ideas, colIdeas) does not show which id you want to update, Is that stored in colIdeas which row you want to update? Does this trick only work then with gallerys?. Right now I have a screen with a few inputfields that I store in a sharepointlist. I use the Title unique id in sharepoint list to read the data, and when I update this I use this Title as Id to which to update. If I collect say textinput1 and 2, and use Patch(database, collection) I dont see how this would work ? How does it know which Title in the sharepointlist to update.
Updateif true will update all records in collection. If item getting added to collection is an existing item, it has the ID of the item so it knows which one to update. If items a new item, it wont have the ID so it will create a record. Galleries is when you are working with multiple items. If you only have fields then more of less you are updating a single item.
@@RezaDorrani I wonder if I can add {Title: variablefortitle, the item I want to patch: item.Text } to make it work with Patch(db, collection) i will try that
I am trying to do a very simple patch for a new item, and I keep getting "Network error when using the patch function. The requested operation is invalid." All I trying to do is patch text to a text column like at 3:30.
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, 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 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!!
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
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.
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.
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!
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
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?
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?
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 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 Reza, the last submit patch from multiple form I don't understand if any form is connected to the same table or different table. Can I use one patch for multiple form connected to multiple tables?; thanks.
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!
I have not tried this with Dataverse for team hence not sure. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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 :)
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.
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)
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.
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
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
Thanks Reza, I’ve been using the patch function you demonstrated at the end of the video for the longest time. But after authoring version 3.24042.28, I start to get an error that says, “network error when using patch functions. The specified column is read-only and can’t be modified.” But like I mentioned, nothing related to this table was changed throughout the whole app. I can only go back to the previous authoring version by restoring to the previous saved versions, but once I make a minor tweak to something else to the power app and hit save, this error message populates once I hit the button associated with the patch function. Any help is appreciated 🙏
Not experienced this issue so not sure. I would have to recreate it and currently working on new video ideas. I recommend posting your issue on forums at powerusers.microsoft.com and if you get a fix, please share it here
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!
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
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.
Is it possible to patch multiple items at once? For example, if I have Table A with columns: Code, Name, & Category. And I have Table B with columns: Code, Name, Category, & Price. These tables are in Dataverse. I want to patch multiple rows from Table A to Table B based on certain criteria. For example, I want to patch all the rows with Code 101. Let's say there are 30 rows that meet those conditions. I want to see those same rows in Table B, but the column Price should be empty because Table A doesn't have a price. What code should I use?😥
Probably possible but not something I have done. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Wonderful. But i was wondering is there a way to bulk update with last data of each items? for example: in your list you showed in the demo. Is there a way to use bulk update with last data of "Approval History" for each item?
@@RezaDorrani well, I have a list that include a column (Multiple line of text) named 'history' (Just like 'Approval History' in your demo list) When i used patch update for 1 items only, its field was updated with old data of itself But when I tried to use bulk update for few items on my list. This field of all items was update with old data one of them
may i know if I have many information to be patch and submit into my database, may i collect them in a collection first and replace the last part of patch function by the collection name?
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 ?
Yes as shown on website. 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
@@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.
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
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?
I will have to look at your App in action to provide guidance & know more about your use case. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
hope you cn include validating a form using patch function without the usage of submitform. how can i trigger the datacard.error just by using the patch on a button
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
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
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
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.
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
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 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
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!
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!
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!
Thanks a lot Reza!
Probably this is the great video on Patch() function that I have ever seen.
Wow, thanks!
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.
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!
Hi Reza, very useful and valuable information in the video. Thank you very much for sharing.
Most welcome
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!
This video and others are wonderful. You are great Reza, congratulations!
Thanks Lucio
Thanks Reza this video is really worthful for beginners.
Glad to hear that
Great video. Lots of little thinks that can help us to develop apps in better ways
Glad to hear that! Thanks for watching.
@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.
Thanks for the great refresher on Patch function.
Glad to hear that. Thanks for watching.
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
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.
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.
Really interesting knowledge .. will come here a lot fot sure
Thanks and welcome
Reza Dorrani Always brings us something New
Thanks
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 a lot Reza, I really needed this you are the best!!
My pleasure!
Very useful information explained..Thanks Reza.
Most welcome
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.
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.
haha i was looking into patching stuff lately and how to improve my calls..then you posted a vid..nice
Hope you enjoyed it!
Thanks for the video. It solved my business problem.
Most welcome
Hi Reza, How would you change the color of the hard coded text "Approval Status Updated" (21:54)? Thank you
I believe that is an html control where value is displayed. You can write simple html code and change color attribute based on the value. I do not have a specific video reference for it though.
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!
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
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.
This is Fantastic example... Thanks
Glad you liked it!
Another great, clear and to the point video.
Thanks Reza
My pleasure!
Very Helpful! Great video!
Thanks
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 😊
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
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
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
If(IsBlank(varIdea),"New",varIdea.Status.Value) use this formula in default of Dropdown ..it worked for me
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.
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!
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.
Really nice, thanks Rezza so much
My pleasure!
I wish PowerApps let you go further into the data, like console.log() in js. So I have a few questions, that I dont understand. At 00:27:00 you use a function called UpdateIf(colIdeas, true.... what is checked if its true here? Does true simply mean if colIdeas containes values, then its true? then you use Patch(Ideas, colIdeas), how does it know which row in the list to update? cause I've used Patch(db, LookUp(db, title = my row I want to update), but Patch(ideas, colIdeas) does not show which id you want to update, Is that stored in colIdeas which row you want to update? Does this trick only work then with gallerys?. Right now I have a screen with a few inputfields that I store in a sharepointlist. I use the Title unique id in sharepoint list to read the data, and when I update this I use this Title as Id to which to update. If I collect say textinput1 and 2, and use Patch(database, collection) I dont see how this would work ? How does it know which Title in the sharepointlist to update.
Updateif true will update all records in collection.
If item getting added to collection is an existing item, it has the ID of the item so it knows which one to update.
If items a new item, it wont have the ID so it will create a record.
Galleries is when you are working with multiple items.
If you only have fields then more of less you are updating a single item.
@@RezaDorrani I wonder if I can add {Title: variablefortitle, the item I want to patch: item.Text } to make it work with Patch(db, collection) i will try that
@@AndrewTSq Try and see
I am trying to do a very simple patch for a new item, and I keep getting "Network error when using the patch function. The requested operation is invalid." All I trying to do is patch text to a text column like at 3:30.
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
Great video, thank you for the content.
Your most welcome
Excellent video!
Thanks Scott
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
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.
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!!
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
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!
great video Reza
Thanks
Hi Reza, when approving the items, how do you create the functionality so the approved item disappears from the gallery/list?
You can either filter out the items based on status or set permissions on items.
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!
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
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
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.
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.
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
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.
Thanks Reza, the last submit patch from multiple form I don't understand if any form is connected to the same table or different table. Can I use one patch for multiple form connected to multiple tables?; thanks.
It must be connected to the same list.
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!
I have not tried this with Dataverse for team hence not sure.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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.
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
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)
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.
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
Thanks Reza.
How can I using Petch update attachments?
Patch does not support attachments
Great Video sir thanks
Welcome
Excelent Video thanks a lot.
Glad you enjoyed it!
Very helpful. Thanks
Thanks for watching
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
Great Job!
Thank You
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
Thanks Reza, How can we build on the iferrors function to be able to show a success message? Thanks
IfError(function;success message,failure message)
@@RezaDorrani is it in one of your videos?
@@utilisemedia No
Thanks Reza, I’ve been using the patch function you demonstrated at the end of the video for the longest time. But after authoring version 3.24042.28, I start to get an error that says, “network error when using patch functions. The specified column is read-only and can’t be modified.” But like I mentioned, nothing related to this table was changed throughout the whole app. I can only go back to the previous authoring version by restoring to the previous saved versions, but once I make a minor tweak to something else to the power app and hit save, this error message populates once I hit the button associated with the patch function. Any help is appreciated 🙏
Not experienced this issue so not sure. I would have to recreate it and currently working on new video ideas.
I recommend posting your issue on forums at powerusers.microsoft.com and if you get a fix, please share it here
@@RezaDorrani thanks for the suggestions
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!
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
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
Is it possible to patch multiple items at once?
For example, if I have Table A with columns: Code, Name, & Category.
And I have Table B with columns: Code, Name, Category, & Price.
These tables are in Dataverse.
I want to patch multiple rows from Table A to Table B based on certain criteria.
For example, I want to patch all the rows with Code 101.
Let's say there are 30 rows that meet those conditions.
I want to see those same rows in Table B, but the column Price should be empty because Table A doesn't have a price.
What code should I use?😥
Probably possible but not something I have done.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
you save my life sir!
Wow! Happy to have helped
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
Wonderful. But i was wondering is there a way to bulk update with last data of each items? for example: in your list you showed in the demo. Is there a way to use bulk update with last data of "Approval History" for each item?
Not sure I understood the question. I would recommend posting your query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani well, I have a list that include a column (Multiple line of text) named 'history' (Just like 'Approval History' in your demo list)
When i used patch update for 1 items only, its field was updated with old data of itself
But when I tried to use bulk update for few items on my list. This field of all items was update with old data one of them
@@ThanhNguyen-ew3dw I will have to look at your app to know the cause of ur issue. It would be best to post your issue on forums.
may i know if I have many information to be patch and submit into my database, may i collect them in a collection first and replace the last part of patch function by the collection name?
Check my video on bulk updating data. I have covered this scenario.
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 ?
Yes as shown on website. 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
@@RezaDorrani Thank you Reza, i write a post on the forum.
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
You’re my boy, Reza
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
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
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?
I will have to look at your App in action to provide guidance & know more about your use case. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
hope you cn include validating a form using patch function without the usage of submitform.
how can i trigger the datacard.error just by using the patch on a button
Why would you want to use patch for a form control?
I have done videos on patch functions.
I have hidden fields that has cascaded values based on another list that I want to add to my sharepoint list submitform cannot do that :(
@@Soulebi03 I recommend checking or posting your query on forums in case someone has tried something similar powerusers.microsoft.com
hello managed to get it using SubmitForm all i have to do is create a custom card and then hide it :D @@RezaDorrani
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