@@RezaDorrani Hi , but i wanted to store multiple users in one record, that multiple users are coming from another share point list in a gallery, on check i am creating collection and i want to patch the selected users by checking check box and store that into collections and wanted to patch that to store in one column
For anyone wondering how to patch attachment column, you can, but for any reason, you have to write at the end of your patch function : patch {….}, form1.updates, form1 this edit form where the attachment component is, and it works !
Video after video you prove that I didn't subscribe for nothing. It's simple, yet very complex and this (important!) stuff is not in the MS documentation. Thanks a lot again. For reference when I come back - I'm sure I'll check this video more than once - let's note that the summary starts at 20:00, which is brilliantly timed 😉
I'm a very lazy dude but with this I have no more excuse to procrastinate. Thanks, Reza. BTW, you made me stopped wasting my life watching all other CZcamss LOL!!!
@@RezaDorrani Thanks! I'm working on migrating my MS Access apps to MS PowerApps. I'm very interested in the topic of generating reports, especially complicated reports, which Access is very capable of. Watching your tuts on pdf, very helpful and practical (of course!). Greatly appreciate!!!
That’s great video! I looked for the way to use patch function to choice column, but, it was difficult to find in Japanese content. This video is very helpful for me. ありがとうございます。
Hi, Reza, your videos, as always, saved me many hours of headaches. Now, knowing all these principles I can build complex features. Thanks a lot again.
Great tutorial, Reza! Thank you. Perfect timing, too. I’m customizing the Edit form for a new SP document library & really struggling with updating complex data types (choice columns with user fill-in, multi line text columns, yes/no). This video will help tremendously. Looking for to the next one & checking out Audrie’s as well.
I concur with @Jim Fitch. I was banging my head on my drop-downs using lookup columns, i realize I need to do the drop-downs as choices(…), then every else is easy.
Hi Reza, your awesome. Each and every video of your is very informative and easy to understand for beginners like me. One quick question on this. Say for my requirement I just have a form which need to update and I'm using PATCH function and there is no Gallery or DataTables to select from. But however I'm having a Dropdown in PowerBI to filter this Form(Power BI and PowerApp integration). So in this case is there a syntax which I could use in this place of Defaults(Source_Name)? Because I cannot use Lookup nor First nor Filter functions.
Thanks Pavan. Even in case of power bi and power apps integration, the home screen will have a gallery. Check czcams.com/video/5y2jJyH4Eu0/video.html Defaults is used only when you want to create new item. When editing data for form, you will need the item context.
Hi, i think you made forgot Table at 21:45 for Manged Metadata. I need to add Table for Enterprise keyword column. BTW your vide is very instructive. I learnt a lot again
You would need to add termguid and label with structure as shown in video. I did not cover managed metadata in video but my blog showcases the syntax rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
@@RezaDorrani sir, i have need some help about main category item and sub category item display in power app same gallery and how to control because they are two list main category and sub category how to manage pleases guide me how to solve this
@@imranfc your best bet would be to post your query with screenshots on the community forum at powerusers.Microsoft.com since it would be difficult to provide help without looking at your data source, column types and use case.
@@RezaDorrani Sir, give me some help about order Id actually I am using function patch forall function and data save correctly but my problem when I am show this data in gallery and search repeat order id with multiple rows. I want show only one order id and then I am click to show other all rows expand with same Id. Kindly help me about this problem
This was very helpful to gather the user information from 365 however, what is the formula or input to retrieve the manager's information? I've tried multiple codes/inputs and I can't seem to figure it out.
You would need to use the office 365 users connector to get that information. I do not have a video reference on this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
still helpful after 4 years. QQ How to tackle when display name and User().FullName are slightly different in length. for example, some users drop middle name in profiles but sharepoint picks it up. I will try the workaround of leaving it blank when patching in the meantime
Great Video. I need to do the same thing than you with "subject" but my "subjects" refer to an another sharepoint list as your "class". So There is a multiple selection i need to patch in a column with multiple choices and these column refer to an another list. How can i pass multiple ids?
Tough to understand your question without looking at your App in action. I would recommend posting your query with screenshots on the forums at powerusers.microsoft.com
This video was super helpful, thank you. I'm having an issue with the Patch function in which I want to keep the records that already exist in a multiple select field, but simply add an additional record. To be more specific I have a multiple select people field in my sharepoint list. If record already contains others in the column I want to keep them there, but also add the user to it. Not sure how to keep records that are already in the column and add another record without completely replacing them.
You should store the existing values related to the field in a variable. Then let user make new selections and prior to patching merge the existing and new selection values. Also, ideally you would want to show the existing values to the user so they can just update them. If you need more assistance I would recommend posting your query with screenshots to the community forums powerusers.microsoft.com/t5/General-Discussion/bd-p/PowerAppsForum1
Great walkthrough, question - do you ever work with collections? If so, how do you use a dropdown and or a datepicker in the collection and patch it to a sharepoint list?
Hiii ! great video rezaa! i followed your tutorial powerapps bulk data. I successfully create exactly what i want based on the video. But I have a problem where I want to patch data collection to sharepoint but i only can patch 20 data only :( did you know why? Thank you reza !
I have not run into this issue, hence I do not know the reason for this issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thank you and you really asked me a question that got me thinking. I found the solution and I would surely be sharing this soon on my twitter handle @rezadorrani. Credit to you. Your need to do 2 things 1 - Go to experimental feature and turn on formula level error management 2 - Patch your person column as follows PersonColName: Blank() Let me know how it goes.
Hi Reza, Always appreciate and enjoy your instruction. I am trying to write a patch to update an existing record. I am not using a gallery. I get an error when attempting to patch a people / group field. My patch function states an error "Network Error when using patch function: The requested operation is invalid. Can you tell me what I should be looking for when that error comes up. It is not very clear
I have not come across this issue, hence not sure what the resolution would be. I would have to reproduce your scenario to know the next steps. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I did and not getting any responses that are helpful. A couple people asked me to post my patch function which I did but without response
@@golfnutt8 Forums is a free platform. You may or may not get the best response. I do not have any bandwidth to validate this and hence asked to check on forums.
@@RezaDorrani Its no problem, I was just wondering if you had heard of anything concerning this. Totally understand you are busy. Again, your videos are amazing and we learn a lot from them.
HI REZA,HAVE FOUND THAT COLLECTION AND FOR ALL WITH PATCH MAKES NO SIGNIFICANT DIFFERENCE .IS USING COLLECTION FOR PATCH IS OTHER OPTION OTHER THAN FOR ALL.thank you for your response.
Love your videos. I'm trying to find out how to patch a SharePoint person column with multiple values. I'm my Powerapp I'm using a combo box for the people picker. I've found videos on how to patch SharePoint multiple person field, but the values are hard coded. I need a way to patch multiple people from the combo box people picker input from my user. So far, I can't find out how to do this. Any ideas? Thanks again.
Excellent video!!....i have a scenario where the entries are made in sharepoint list directly as its used by different teams, i have developed a power apps for a particular team where they want a text box value to be summed up each time when the particular ID is selected from the drop down....the problem that am facing is i want to alter only one column but since there are few mandatory columns in sharepoint list its asking me to patch a value for those columns, but i dont want to alter any other columns....is there a way to do this
Hi Pricilla , If you are using Patch to create a new record, then all mandatory columns need to have values. If you are using Patch to update a record, then you can update your fields of choice.
Hey Reza! Cool Video!! I was ondering if you can help me in this situation: I have a excel list with some different colums then Sharepoint list, but both of then have the same intention. For exemplo: in SP list I have A, B and C coluns, and the excel I have D, F and G. I want to add the D, F and G coluns from the excel sheet to Sp list. I will create this coluns in SP list, and want to upload the items from sp list with the excel list. Also, I have the same itens in both sheets, with a coluns that work as a ID. So I can compare the items to insert the data of the new colums in the correct item. Maybe I should try something like: Patch>Forll>Lookup>data from the coluns I want to add?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you Reza. I want to include an auto increment in my list. Want function do I use to patch auto number starting from 1 --- to my SharePoint list? I'm running a powerapp survey
@@RezaDorrani Thank you. And do you have any recommendations on how I can generate graphs for my PowerApp survey? I tried web part chart on SharePoint but it didn't work out because my survey responses do not contain number values. All responses are I'm text.
@@itstiktok8765 I do not have a video on this scenario. I would have to try it out to provide guidance. I will recommend posting your query on the forums at powerusers.microsoft.com
Hi Reza, your videos are always great. What is the best practice for a multi select combo box when multiple choices are made or updated? Can this patch function be updated to handle that? Thanks again.
Yes, works with all column types except attachments. I did a recent video on Patch function (check if that helps) + video description has link to a blogpost I wrote on Patch function and all SharePoint column types.
@@RezaDorrani Thank you, I missed the link to the blog. Very informative and have added my email. How am I able to add not only my multi select lookup choices and my other fields to the same patch and how is patch used with Table as you show? I know your busy, so I apologize for bothering you; I'm just struggling to make this work for my project.
@@golfnutt8 I do not have a specific video on that. And would have to try it out to let you know how. I would recommend posting your query with screenshots on the forums powerusers.microsoft.com
@@RezaDorrani I did and I have found multiple functions that look like they would help but not with what I am doing. For all I know, being somewhat new to this, is I may be going about this all wrong. I will keep looking. Thanks again.
Is this the best way to post to a list if you are brining in multiple data sources? I am still learning and so far this seems to be the only option I see. Any insight on this would be greatly appreciated.
Great reference video for all column types, thanks. I’ve come across an issue though with a sharepoint look up column. My list uses a site column which looks up to list on the root site in the site collection however if I try to patch to it the lookup field isn’t visible. If the look up points to a list on the same site then all is well, but not if it is looking at the parent site. Any ideas?
Hi Ian, Great question. I have not tried it. My guess would be that you would need to include some sought of relationship with the root site. Modern SharePoint world is flat, meaning you build site collections and not sub sites. You can also relate sites together using the new hub features. There is also new CT hub publishing features coming soon.
@@RezaDorrani Many thanks for your reply. I am finding your videos very helpful. My issue comes from having a legacy sharepoint set up with a large hierarchy of sites and sub sites. Following the demise of sharepoint designer it’s a shame MS didn’t consider backward compatibility with power apps functionality. I’ll investigate the hub features you’ve mentioned and see what they have to offer as a solution. I don’t suppose you have done a video on them as well, have you. Many thanks again.
@@iancrosby7265 I have not done videos on SharePoint but have been working on SharePoint since 2007 :) Here is the reference documentation for hub sites - docs.microsoft.com/en-us/sharepoint/planning-hub-sites
Reza, do you know if there is a way to patch an Attachment to a SP list. I took the control from another form connected directly to a SP data source but when I try to use a collection with a different structure I cannot map the patch to the attachments field. Any thoughts?
Excellent Video! As are all of your videos. Question, I see on the Video "Patch function with SharePoint Columns" you have "ID of item created". Can you tell us how you did that from Sharepoint? Thank You so much for your great Videos!
dear reza thanks for the video.do you know how to patch crm yes/no toogle from power apps please.i got two radio buttons yes,no in powerppas if i select yes from powerapps and click submit it needs to update in crm .toggle should change to yes and vice versa .i tried path in if condition i am getting errors some how
This video is purely focussed around Power Apps. For CRM (CDS) the format for patching is a little different. When you are Patching for Yes/No type column in CRM use 'colName (EntityName)'.Yes where colName - is name of your field and EntityName is name of your entity.
Dear Reza, Thank you for the video, its very helpful. I have question. I have 2 person column in sharepoint list, How can I patch if one of them is optional? Thanks You :)
Lookup column value is not getting saved into sharepoint list. BUT when I select and wait in the function that I have written it is showing the ID and column value.
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
Hi Reza, hope you doing great.i have a SharePoint choice column, when i use the patch function to submit my form, all the other colums get updated except this particular column, this is what my onSelect function for the submit button looks like "Patch(Helpdesk, Default(Helpdesk), CreateTicketForm.Updates)". Can you help figure out why a particular column isn't updating? Thanks in advance
I will have to look at your App in action to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
How does the patch work if your 'Class' (Office 365 Users column - 'Department' in my case) is provided dynamically when you select the student from a people picker combobox? ie you don't select class from the dropdown, the class is obtained and placed in a textbox when you select your student? - Thanks. This video has answered all my other questions👌
@@RezaDorrani Sorry, didn't mention that the 'Class' column is a lookup column to another list that has the corresponding grade for the classes. Ie class 9w is a grade 9 class thank you for the quick response.
@@techdrift73 This is something I would have to look at or try out. I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Hi, Lookup column is not getting saved into sharepoint list. But in power apps, when I select the column I am trying to save, it is showing both ID and value correctly.
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
Hi Reza when I use combobox with choices and bulkupdating why same value is populated to sharepoint list ,created collection on combobox on change property ,appreciate your answer.
I would have to see your code to know why this is happening. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
I have a question if I have 3 screens with 3 edit forms and these edit forms have different fields from different tables from my database and I have a button on the last page to save all the information the user inputted how can I save all the information into my database?
hi very informative and helpful video. One question... the "Class" column in "Students" list is fetching the value from another list "Class". But in Items property you mentioned, "Choices (Student.Class)" why that so? How will we get other class values which are not saved in "Students" list but are in the "Class" list "Title" column? and another issue... how can i display people from gallery selected plz?
Class is a lookup column associated with the list "Class". Hence using Choices(Student.Class) works. You could also directly get the values from the Class list. Both approaches will work. Both approaches will show you all the data from the Class list even ones that are not saved in Students list. Display people from gallery selected? Do you mean filtering gallery data based on people picker column? Check this - czcams.com/video/tPxE_-DcWkg/video.html
czcams.com/video/tPxE_-DcWkg/video.html For Patching you have to follow the format of a person type column as described in this blog post - rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
Reza your videos are amazing! My team and I love your content! I finally got my PowerApp to update my data because of your video! Once I update a record, however, it disappears from the app Gallery View - but shows the updates made in SharePoint. Is there something I am missing? For context, I used your Editable Grid Video to build an app in Power Apps, and this is in reference to the "Edit in Grid View'/Exit Grid View' portion -- Where data is updated after 'Exit Grid View' is selected. Here is the function for my button: If( varGridEdit, Patch( Contractors,colGridData.GalleryGrid.Selected, {'Contractor Status':{Value:"ContractorStatus.Selected"}, 'LastCertified Date':Today()} ) ); Select(btnLoadData); Set( varGridEdit, !varGridEdit ) I appreciate any and all help you can provide! Thank you for making amazing content!
Thanks for watching and liking my videos. The editable grid video has link to download the sample App. Give that a try. There is a known bug with combo box controls. So replace them with Dropdowns.
Hi Reza.. A quick query.. I am trying to patch my powerapp with Excel database in OneDrive for business. It created a powerappid in file.. But the data is not getting captured. Can you guide on this issue please.
Hi Ashish, I would have to see the code base to help. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1
Hi sir, can you please help me in this scenario, due to threshold limit of the sharepoint i am able to use 12 lookup columns in my list. but in my required there should be 13 for that i am using text box in the list while customizing in PowerApps for the list form i am using as people picker for one control. My data is saving to the list. but while editing it data is not showing. Please help me sir.
SharePoint has a limit of 12. That cannot be changed in sharepoint online. You would either have to change the column types or look for a different data source.
You can use the same screen to update or add records. I have seen a lot of questions around this on the forums. I will recommend you check on the forums at powerusers.microsoft.com/
@@RezaDorrani generally choice columns have more than one option even if it's not a multi-select column. Otherwise what's the point of having one choice?
@@RezaDorrani so on the blog post do I need to pay attention to "Choice Column" or "Multi Select Choice column " - if the first (as it's a choice and not-multi-select), do I just need to enter "{Value: "choicevalue1", "choicevalue2"}" etc..?
I have a app which wanted to save multiple people values into SP list and it's already enabled for multiple people selection but how can we store it in SP list using patch, thanks
I do not have a video reference for this scenario. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
How to proceed with a powerapps, full CRUD where the requirement is to have 14 people picker (contacts for each department) with sharepoint list as datasource. I designed 14 text columns in SPL and within gallery control, combo box for people picker. I'm stuck with accessing each department combo box and patching each of them. Is this the right approach or any other way to do this?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I do have a backlog of planned videos. Will add it to my list. I do plan on creating a voting feature for subscribers in future. That ways I am creating content in line with subscriber requests.
Hello Reza, I have a gallery with data coming from source A, i can filter that data but i want to move that filtered data into source B which is a sharepoint list. how do i use patch to achieve that? so i want to use the filtered data in my gallery to create a new records in source B.
Thank you for posting the video.I come from Japan. I`m thinking of making an app for taking inventries. I`m looking for a way to renew the value in the cell using the patch function. (Columns: ①item-number②quantity) This is what I want to do. I read a QR code ro get the item number and input the remaining quantity. I activate the patch function. The problem is how to renew the quantity. It`s not good enough to just renew the value since I need to input the accumulated quantity. I need to add the value to the one already input in the cell. I tried the below but it didn`t work. ・Patch(filename,lookup(filename,item-number=barcodescanner1.value),{quantity:inputbox1.value,}) →Patch(filename,lookup(filename,item-number=barcodescanner1.value),{quantity:quantity+inputbox1.value,}) I guess I have to use another function or something instead of the patch function in my case. If you know how to make what I want to do happen , it would help. Thank you.
Thanks for liking the video. As for your scenario, I would have to either look at your app in action ot recreate your scenario to provide guidance. I will recommend posting your query/issue with screenshots on the forums at powerusers.microsoft.com
HI Reza, with the People Picker control, even if I enter and select another persons name, when the data is patched to SP list, it displays my name and not the person whom I selected.
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
Choices is a standard function that works with Choice and Lookup type columns. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
How to update both SharePoint list fields and corresponding powerapps field using MS flow? If I select trigger the action when an item is created in SharePoint, then only SharePoint list field is getting updated ,powerapps form filed will remain same. If I select trigger action as powerapps, then I am not getting the SharePoint form 🆔. Could you please make a video on this scenario? A simple approval workflow with a status field in powerapps?
If power apps is connected to SharePoint and if SharePoint list is being updated then the changes should reflect in Power Apps. Sounds more like an issue or some disconnect with me understanding your use case. I will recommend you check on the forums at powerusers.microsoft.com/
@@RezaDorrani I have set my status field display mode as view in powerappps, (I don't want to edit the status field by an end user). when I change other field value through workflow, they are getting updated( they have display mode as edit). Hw can I change a field with view mode through workflow.
@@shinshae7882 Display mode of control in Power Apps has no effect on updating the field from flow. You can simply use update item action and set the values for the fields.
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Sir I have data in Excel 20 Rows and 5 Columns (Columns and Rows may vary based on available data).I want to copy (Ctrl C) all data from excel and past (Ctrl V) into PowerApps canvas and Patch to SharePoint along with few headers in Canvas with the help of button. Request your help in this regard.
I have never tried that. I dont think copy and paste works that way. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Mate great video. You made my day easy, everything I was looking for at a single place 🙌🙌
Thank you
Thank you Vikram
@@RezaDorrani Hi , but i wanted to store multiple users in one record, that multiple users are coming from another share point list in a gallery, on check i am creating collection and i want to patch the selected users by checking check box and store that into collections and wanted to patch that to store in one column
@@amanchourasia1870 I do not have any video references on this use case. I recommend posting your scenario on forums powerusers.microsoft.com/
For anyone wondering how to patch attachment column, you can, but for any reason, you have to write at the end of your patch function : patch {….}, form1.updates, form1 this edit form where the attachment component is, and it works !
It works only if you are actually using a form control. Without form control (form1.updates), you cannot patch to attachments column.
This is how every tutorial should be done. Slowly broken down in parts and explained step by step. Thank you Reza
Thank you Ami
Thank you for watching
Reza, I do not know you, but thank you so much, I spent several hours until I found your video...you are great.
Glad it was helpful! Thank you for watching.
Your channel is enough to build a full fledged business application in PowerApp! . Thank you so much Reza.
Wow! Thank you.
Video after video you prove that I didn't subscribe for nothing. It's simple, yet very complex and this (important!) stuff is not in the MS documentation. Thanks a lot again.
For reference when I come back - I'm sure I'll check this video more than once - let's note that the summary starts at 20:00, which is brilliantly timed 😉
Thank you for the wonderful feedback. The timing on the summary was indeed perfect 😉
I'm a very lazy dude but with this I have no more excuse to procrastinate. Thanks, Reza. BTW, you made me stopped wasting my life watching all other CZcamss LOL!!!
Thanks for watching. Hoping to make this channel cover most bases of power platform.
@@RezaDorrani Thanks! I'm working on migrating my MS Access apps to MS PowerApps. I'm very interested in the topic of generating reports, especially complicated reports, which Access is very capable of. Watching your tuts on pdf, very helpful and practical (of course!). Greatly appreciate!!!
Thanks sir for power apps videos in simple language
Your most welcome
非常感谢！使用Patch函数将数据上传到Sharepoint的这个步骤很关键，您的视频讲解的非常细致！
感谢您观看和喜欢视频
One of the most usefull video about Power Apps and SharePoint. Thank you for these high quality videos.
You're very welcome!
Thank you Reza. Finally I got the solution to patch the different column types.
Glad to hear that! Thanks for watching.
Ultimately , I found solution here !!! Thank you.
Welcome 👍
The User patch was spot on. Thank you! Also, thank for the link to the code, you saved my a lot of time.
Glad to hear it!
Again, very important video if you want to success with powerapps! thank you Reza.
Thanks for watching David
That’s great video! I looked for the way to use patch function to choice column, but, it was difficult to find in Japanese content. This video is very helpful for me. ありがとうございます。
Glad it was helpful!
Hi, Reza, your videos, as always, saved me many hours of headaches. Now, knowing all these principles I can build complex features. Thanks a lot again.
Great to hear! Thank You so much for the feedback.
Thanks a ton for another great tutorial, Reza. Just wished I had found your video wayyyyyy earlier in the day 😅
It’s never too late :)
this video is a gem ...all scenarios covered with precise details step by step .... I just love it. Thanks a bunch Reza!!
You are most welcome Aroh
Best channel i have subscribed so far. Great as always! Thanks!
Thank you for your kind words.
Will try my best to keep posting relevant and useful information.
Excellent Video, Please tell us the remaining topic videos.
Check the community tab on my channel. I share all info about upcoming videos there.
Man this is amazing, excelent way of showing EVERYTHING, I love it, really good !
Thank you Mauro
Excellent. Thank you for sharing.
Thanks for listening
Learned a lot, especially the one on the Lookup columns. Well done!
Thanks Marc
thanks Reza great tutorial.
You are most welcome
Superb overview - thank you! 👍👍
Thanks Brian
Great tutorial, Reza! Thank you. Perfect timing, too. I’m customizing the Edit form for a new SP document library & really struggling with updating complex data types (choice columns with user fill-in, multi line text columns, yes/no). This video will help tremendously. Looking for to the next one & checking out Audrie’s as well.
Thank you Jim. Glad it was useful.
Audrie is one of my favorites too.
I concur with @Jim Fitch. I was banging my head on my drop-downs using lookup columns, i realize I need to do the drop-downs as choices(…), then every else is easy.
Thanks, learned a lot from this!
Yes, great video!
Glad it was helpful!
Thank you
Thanks Reza for the great video but the video does not contain the last point which is "Patch vs Form"
I have done multiple videos on Patch and Form control.
Great video, thank you
You are welcome!
Really, very useful , Thank you so much !!!
Thank you for watching
Thanks, great resource
You're welcome!
Hi Reza, your awesome. Each and every video of your is very informative and easy to understand for beginners like me.
One quick question on this. Say for my requirement I just have a form which need to update and I'm using PATCH function and there is no Gallery or DataTables to select from. But however I'm having a Dropdown in PowerBI to filter this Form(Power BI and PowerApp integration). So in this case is there a syntax which I could use in this place of Defaults(Source_Name)? Because I cannot use Lookup nor First nor Filter functions.
Thanks Pavan.
Even in case of power bi and power apps integration, the home screen will have a gallery.
Check czcams.com/video/5y2jJyH4Eu0/video.html
Defaults is used only when you want to create new item.
When editing data for form, you will need the item context.
Great Video. Translationen
Glad you liked it!
Awesome! Great info!
Thanks for watching!
Great video Reza! Thanks!
My pleasure!
Hi, i think you made forgot Table at 21:45 for Manged Metadata. I need to add Table for Enterprise keyword column. BTW your vide is very instructive. I learnt a lot again
You would need to add termguid and label with structure as shown in video. I did not cover managed metadata in video but my blog showcases the syntax rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
its really good video about patch functionalities.
Glad you liked it
@@RezaDorrani sir, i have need some help about main category item and sub category item display in power app same gallery and how to control because they are two list main category and sub category how to manage pleases guide me how to solve this
@@imranfc your best bet would be to post your query with screenshots on the community forum at powerusers.Microsoft.com since it would be difficult to provide help without looking at your data source, column types and use case.
Thank you
@@RezaDorrani Sir, give me some help about order Id actually I am using function patch forall function
and data save correctly but my problem when I am show this data in gallery and search
repeat order id with multiple rows. I want show only one order id and then I am click to
show other all rows expand with same Id. Kindly help me about this problem
this is useful!
Glad to hear that!
This was very helpful to gather the user information from 365 however, what is the formula or input to retrieve the manager's information? I've tried multiple codes/inputs and I can't seem to figure it out.
You would need to use the office 365 users connector to get that information.
I do not have a video reference on this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
still helpful after 4 years. QQ How to tackle when display name and User().FullName are slightly different in length. for example, some users drop middle name in profiles but sharepoint picks it up. I will try the workaround of leaving it blank when patching in the meantime
Great to hear!
Use one or the other to keep things consistent. Or simply query users profile using o365users connector.
Great Video. I need to do the same thing than you with "subject" but my "subjects" refer to an another sharepoint list as your "class". So There is a multiple selection i need to patch in a column with multiple choices and these column refer to an another list. How can i pass multiple ids?
Tough to understand your question without looking at your App in action. I would recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Great informative video
Glad it was helpful!
Ευχαριστούμε!
Ευχαριστώ
This video was super helpful, thank you. I'm having an issue with the Patch function in which I want to keep the records that already exist in a multiple select field, but simply add an additional record. To be more specific I have a multiple select people field in my sharepoint list. If record already contains others in the column I want to keep them there, but also add the user to it. Not sure how to keep records that are already in the column and add another record without completely replacing them.
You should store the existing values related to the field in a variable. Then let user make new selections and prior to patching merge the existing and new selection values.
Also, ideally you would want to show the existing values to the user so they can just update them.
If you need more assistance I would recommend posting your query with screenshots to the community forums
powerusers.microsoft.com/t5/General-Discussion/bd-p/PowerAppsForum1
Great walkthrough, question - do you ever work with collections? If so, how do you use a dropdown and or a datepicker in the collection and patch it to a sharepoint list?
I am actually working on a video that showcases how to patch data held in collections for entire record data.
That video should be out coming Tuesday.
That was excellent, thank you. I've used patch a lot but still learned heaps
Glad you liked it Ryan.
I plan to add videos on advanced Patch functions & the Form control soon.
Eager to see the next videos you mention here!
Really helpful video. Would this patching be the same to Dataverse?
Patch function syntax would be same.
But the column types and formats used for Patching would be different.
Hiii ! great video rezaa! i followed your tutorial powerapps bulk data. I successfully create exactly what i want based on the video. But I have a problem where I want to patch data collection to sharepoint but i only can patch 20 data only :( did you know why? Thank you reza !
I have not run into this issue, hence I do not know the reason for this issue.
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thanks for your valuable videos Reza. Can you please advise how do i create a list with O365 users automatically? Is it possible?
You can use the Office 365 Users connector to list all the users in your Power App
Thanks Reza, it is great video. Do you know how to patch person field with null?
Thank you and you really asked me a question that got me thinking. I found the solution and I would surely be sharing this soon on my twitter handle @rezadorrani. Credit to you.
Your need to do 2 things
1 - Go to experimental feature and turn on formula level error management
2 - Patch your person column as follows
PersonColName: Blank()
Let me know how it goes.
Hi Reza! Please, do you have any video for beginners, about collections? Thank you!
Currently No. But is a high priority video in my list.
awesome! thanks you!
You're welcome!
Hi Reza, Always appreciate and enjoy your instruction.
I am trying to write a patch to update an existing record.
I am not using a gallery.
I get an error when attempting to patch a people / group field.
My patch function states an error "Network Error when using patch function: The requested operation is invalid.
Can you tell me what I should be looking for when that error comes up. It is not very clear
I have not come across this issue, hence not sure what the resolution would be. I would have to reproduce your scenario to know the next steps. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I did and not getting any responses that are helpful. A couple people asked me to post my patch function which I did but without response
@@golfnutt8 Forums is a free platform. You may or may not get the best response. I do not have any bandwidth to validate this and hence asked to check on forums.
@@RezaDorrani Its no problem, I was just wondering if you had heard of anything concerning this. Totally understand you are busy. Again, your videos are amazing and we learn a lot from them.
@@golfnutt8 Thanks for understanding. I have not heard anything on this one.
HI REZA,HAVE FOUND THAT COLLECTION AND FOR ALL WITH PATCH MAKES NO SIGNIFICANT DIFFERENCE .IS USING COLLECTION FOR PATCH IS OTHER OPTION OTHER THAN FOR ALL.thank you for your response.
Patch collection is way faster than forall and more performant.
Check - czcams.com/video/VzrarcM9W5k/video.html
Found it. Thanks!!!! Can you patch to tables at the same time?
Which Tables?
Love your videos. I'm trying to find out how to patch a SharePoint person column with multiple values. I'm my Powerapp I'm using a combo box for the people picker. I've found videos on how to patch SharePoint multiple person field, but the values are hard coded. I need a way to patch multiple people from the combo box people picker input from my user. So far, I can't find out how to do this. Any ideas? Thanks again.
Depends on how the combox is being populated with data. At the end of the day, when you patch the format should be as described in this video.
Excellent video!!....i have a scenario where the entries are made in sharepoint list directly as its used by different teams, i have developed a power apps for a particular team where they want a text box value to be summed up each time when the particular ID is selected from the drop down....the problem that am facing is i want to alter only one column but since there are few mandatory columns in sharepoint list its asking me to patch a value for those columns, but i dont want to alter any other columns....is there a way to do this
Hi Pricilla ,
If you are using Patch to create a new record, then all mandatory columns need to have values.
If you are using Patch to update a record, then you can update your fields of choice.
@@RezaDorrani got it,thank you
Hey Reza! Cool Video!!
I was ondering if you can help me in this situation:
I have a excel list with some different colums then Sharepoint list, but both of then have the same intention. For exemplo: in SP list I have A, B and C coluns, and the excel I have D, F and G. I want to add the D, F and G coluns from the excel sheet to Sp list.
I will create this coluns in SP list, and want to upload the items from sp list with the excel list.
Also, I have the same itens in both sheets, with a coluns that work as a ID. So I can compare the items to insert the data of the new colums in the correct item.
Maybe I should try something like: Patch>Forll>Lookup>data from the coluns I want to add?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you Reza. I want to include an auto increment in my list. Want function do I use to patch auto number starting from 1 --- to my SharePoint list? I'm running a powerapp survey
SharePoint already has a column called ID which is a unique auto number column.
@@RezaDorrani Thank you. And do you have any recommendations on how I can generate graphs for my PowerApp survey? I tried web part chart on SharePoint but it didn't work out because my survey responses do not contain number values. All responses are I'm text.
@@itstiktok8765 I do not have a video on this scenario. I would have to try it out to provide guidance. I will recommend posting your query on the forums at powerusers.microsoft.com
Hi Reza, your videos are always great.
What is the best practice for a multi select combo box when multiple choices are made or updated? Can this patch function be updated to handle that?
Thanks again.
Yes, works with all column types except attachments. I did a recent video on Patch function (check if that helps) + video description has link to a blogpost I wrote on Patch function and all SharePoint column types.
@@RezaDorrani Thank you, I missed the link to the blog. Very informative and have added my email.
How am I able to add not only my multi select lookup choices and my other fields to the same patch and how is patch used with Table as you show?
I know your busy, so I apologize for bothering you; I'm just struggling to make this work for my project.
@@golfnutt8 I do not have a specific video on that. And would have to try it out to let you know how. I would recommend posting your query with screenshots on the forums powerusers.microsoft.com
@@RezaDorrani I did and I have found multiple functions that look like they would help but not with what I am doing.
For all I know, being somewhat new to this, is I may be going about this all wrong. I will keep looking.
Thanks again.
Vielen Dank
Sie sind herzlich willkommen
Is this the best way to post to a list if you are brining in multiple data sources? I am still learning and so far this seems to be the only option I see. Any insight on this would be greatly appreciated.
Patch and SubmitForm are your options
Great reference video for all column types, thanks. I’ve come across an issue though with a sharepoint look up column. My list uses a site column which looks up to list on the root site in the site collection however if I try to patch to it the lookup field isn’t visible. If the look up points to a list on the same site then all is well, but not if it is looking at the parent site. Any ideas?
Hi Ian,
Great question. I have not tried it. My guess would be that you would need to include some sought of relationship with the root site.
Modern SharePoint world is flat, meaning you build site collections and not sub sites. You can also relate sites together using the new hub features. There is also new CT hub publishing features coming soon.
@@RezaDorrani Many thanks for your reply. I am finding your videos very helpful. My issue comes from having a legacy sharepoint set up with a large hierarchy of sites and sub sites. Following the demise of sharepoint designer it’s a shame MS didn’t consider backward compatibility with power apps functionality. I’ll investigate the hub features you’ve mentioned and see what they have to offer as a solution. I don’t suppose you have done a video on them as well, have you. Many thanks again.
@@iancrosby7265 I have not done videos on SharePoint but have been working on SharePoint since 2007 :)
Here is the reference documentation for hub sites - docs.microsoft.com/en-us/sharepoint/planning-hub-sites
Reza, do you know if there is a way to patch an Attachment to a SP list. I took the control from another form connected directly to a SP data source but when I try to use a collection with a different structure I cannot map the patch to the attachments field. Any thoughts?
Patch statement does not support attachments.
You would need flow - czcams.com/video/g9ChYuTdNd4/video.html
@@RezaDorrani thank you Reza.
Great video...! Thanks
can u please suggest on how can I duplicate the gallery item and submit it with a new ID to SP?
Using defaults(datasource) in patch will post data as a new item to data source. This will automatically generate a new ID in SP.
Excellent Video! As are all of your videos. Question, I see on the Video "Patch function with SharePoint Columns" you have "ID of item created". Can you tell us how you did that from Sharepoint? Thank You so much for your great Videos!
ID is created automatically in SharePoint.
@@RezaDorrani Thanks for the quick response, but how do I get that ID in Powerapps to use after it is automatically created in Sharepoint?
@@ronpalyok3212 When you get the item, you will get the id also.
@@RezaDorrani Wow how quick!!! If I patch a record, how do I get the ID
@@ronpalyok3212 Simply save the response of patch in a variable. Set(x, Patch(...))
x will have all the data you need.
dear reza thanks for the video.do you know how to patch crm yes/no toogle from power apps please.i got two radio buttons yes,no in powerppas
if i select yes from powerapps and click submit it needs to update in crm .toggle should change to yes and vice versa .i tried path in if condition i am getting errors some how
This video is purely focussed around Power Apps. For CRM (CDS) the format for patching is a little different.
When you are Patching for Yes/No type column in CRM use 'colName (EntityName)'.Yes where colName - is name of your field and EntityName is name of your entity.
@@RezaDorrani thanks very much will try that
Dear Reza,
Thank you for the video, its very helpful.
I have question.
I have 2 person column in sharepoint list, How can I patch if one of them is optional?
Thanks You :)
Patch does not force to add optional fields. You can avoid patching that column in formula.
Lookup column value is not getting saved into sharepoint list. BUT when I select and wait in the function that I have written it is showing the ID and column value.
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
Hi Reza, hope you doing great.i have a SharePoint choice column, when i use the patch function to submit my form, all the other colums get updated except this particular column, this is what my onSelect function for the submit button looks like "Patch(Helpdesk, Default(Helpdesk), CreateTicketForm.Updates)". Can you help figure out why a particular column isn't updating? Thanks in advance
I will have to look at your App in action to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
How does the patch work if your 'Class' (Office 365 Users column - 'Department' in my case) is provided dynamically when you select the student from a people picker combobox? ie you don't select class from the dropdown, the class is obtained and placed in a textbox when you select your student? - Thanks. This video has answered all my other questions👌
If department is a text column, you can simply patch it with combobox.selected.department
Something on these lines.
@@RezaDorrani Sorry, didn't mention that the 'Class' column is a lookup column to another list that has the corresponding grade for the classes. Ie class 9w is a grade 9 class thank you for the quick response.
@@techdrift73 This is something I would have to look at or try out. I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Done, title is 'Patch lookup column from another list'
@@techdrift73 I go to forums to assist in my free time only. There are many other folks who provide guidance.
Thank you for your work. But what about patch with controls for numbers?
Just directly patch that column with numerical value. Example:
numberColumn: 1
thx u very much, Il helps me, but what if I want savc the invoice analysed in the same SharePoint List Attchement, what could I do?
Patch function does not support attachments.
Check czcams.com/video/3dNeMVLZDHo/video.html
Hi,
Lookup column is not getting saved into sharepoint list. But in power apps, when I select the column I am trying to save, it is showing both ID and value correctly.
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
Hi Reza when I use combobox with choices and bulkupdating why same value is populated to sharepoint list ,created collection on combobox on change property ,appreciate your answer.
I would have to see your code to know why this is happening.
I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
I have a question if I have 3 screens with 3 edit forms and these edit forms have different fields from different tables from my database and I have a button on the last page to save all the information the user inputted how can I save all the information into my database?
If they are form controls, you can simply use the SubmitForm function to submit the data to your database.
Hi Reza, is it possible to start with a blank canvas app and then publish to Sharepoint (like infopath) to create the columns?
Start with blank App - Yes.
Publish like InfoPath and create columns - No
hi very informative and helpful video.
One question... the "Class" column in "Students" list is fetching the value from another list "Class".
But in Items property you mentioned, "Choices (Student.Class)" why that so?
How will we get other class values which are not saved in "Students" list but are in the "Class" list "Title"
column?
and another issue... how can i display people from gallery selected plz?
Class is a lookup column associated with the list "Class". Hence using Choices(Student.Class) works. You could also directly get the values from the Class list. Both approaches will work. Both approaches will show you all the data from the Class list even ones that are not saved in Students list.
Display people from gallery selected? Do you mean filtering gallery data based on people picker column?
Check this - czcams.com/video/tPxE_-DcWkg/video.html
@@RezaDorrani hi again a great video... may be if u please give an idea how to fetch the people field in a combo box and change / edit on it
Thanks for sharing. May I know how we can lookup the sharepoint list by user().email and patch to update the info?
czcams.com/video/tPxE_-DcWkg/video.html
For Patching you have to follow the format of a person type column as described in this blog post - rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
Reza your videos are amazing! My team and I love your content! I finally got my PowerApp to update my data because of your video! Once I update a record, however, it disappears from the app Gallery View - but shows the updates made in SharePoint. Is there something I am missing? For context, I used your Editable Grid Video to build an app in Power Apps, and this is in reference to the "Edit in Grid View'/Exit Grid View' portion -- Where data is updated after 'Exit Grid View' is selected. Here is the function for my button:
If(
varGridEdit,
Patch(
Contractors,colGridData.GalleryGrid.Selected,
{'Contractor Status':{Value:"ContractorStatus.Selected"},
'LastCertified Date':Today()}
)
);
Select(btnLoadData);
Set(
varGridEdit,
!varGridEdit
)
I appreciate any and all help you can provide! Thank you for making amazing content!
Thanks for watching and liking my videos.
The editable grid video has link to download the sample App. Give that a try.
There is a known bug with combo box controls. So replace them with Dropdowns.
I'm having trouble clearing a user and group field in sharepoint once it's set using the PATCH() function.
Is this not supported?
Did you try the technique in this video?
Hi Reza..
A quick query..
I am trying to patch my powerapp with Excel database in OneDrive for business.
It created a powerappid in file..
But the data is not getting captured.
Can you guide on this issue please.
Hi Ashish, I would have to see the code base to help.
I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1
Hi sir, can you please help me in this scenario, due to threshold limit of the sharepoint i am able to use 12 lookup columns in my list. but in my required there should be 13 for that i am using text box in the list while customizing in PowerApps for the list form i am using as people picker for one control. My data is saving to the list. but while editing it data is not showing. Please help me sir.
SharePoint has a limit of 12. That cannot be changed in sharepoint online.
You would either have to change the column types or look for a different data source.
Hello Reza, can you please share the link of the video where you have prepared a people picker from scractch
I have done plenty of videos. Do not remember in which one I did that. Check either the combo box video or one of my editable grid videos.
Sir, do I have to create another screen for Update-Patch ? Hope you would notice this.
You can use the same screen to update or add records.
I have seen a lot of questions around this on the forums.
I will recommend you check on the forums at powerusers.microsoft.com/
Hi Reza - great video as always! For a choice column, do I Ineed to keep repeating the same code for each choice value? - {Value: "choice value"}
If it's multi select - then array of choices
video description has link to blog post
@@RezaDorrani generally choice columns have more than one option even if it's not a multi-select column. Otherwise what's the point of having one choice?
@@sudosaurus What I meant was single select vs multi select. Options would be many.
@@RezaDorrani so on the blog post do I need to pay attention to "Choice Column" or "Multi Select Choice column
" - if the first (as it's a choice and not-multi-select), do I just need to enter "{Value: "choicevalue1", "choicevalue2"}" etc..?
@@sudosaurus if single select {Value:”data”}
If multi Table({Value:”data”},{Value:”data”})
I have a app which wanted to save multiple people values into SP list and it's already enabled for multiple people selection but how can we store it in SP list using patch, thanks
I do not have a video reference for this scenario. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
What if you have a multi select choice column in share point and you want to patch it with the contents of a collection?
For collection patching, check czcams.com/video/VzrarcM9W5k/video.html
How to proceed with a powerapps, full CRUD where the requirement is to have 14 people picker (contacts for each department) with sharepoint list as datasource.
I designed 14 text columns in SPL and within gallery control, combo box for people picker. I'm stuck with accessing each department combo box and patching each of them. Is this the right approach or any other way to do this?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani thank you. I will post this on forum.
Excellent video! Can you please do one for cds as well?
I do have a backlog of planned videos.
Will add it to my list.
I do plan on creating a voting feature for subscribers in future. That ways I am creating content in line with subscriber requests.
Hello Reza, I have a gallery with data coming from source A, i can filter that data but i want to move that filtered data into source B which is a sharepoint list. how do i use patch to achieve that?
so i want to use the filtered data in my gallery to create a new records in source B.
Load all filtered data into a collection and patch it in one go.
czcams.com/video/VzrarcM9W5k/video.html
Thank you for posting the video.I come from Japan.
I`m thinking of making an app for taking inventries.
I`m looking for a way to renew the value in the cell using the patch function.
(Columns: ①item-number②quantity)
This is what I want to do.
I read a QR code ro get the item number and input the remaining quantity.
I activate the patch function.
The problem is how to renew the quantity.
It`s not good enough to just renew the value since I need to input the accumulated quantity.
I need to add the value to the one already input in the cell.
I tried the below but it didn`t work.
・Patch(filename,lookup(filename,item-number=barcodescanner1.value),{quantity:inputbox1.value,})
→Patch(filename,lookup(filename,item-number=barcodescanner1.value),{quantity:quantity+inputbox1.value,})
I guess I have to use another function or something instead of the patch function in my case.
If you know how to make what I want to do happen , it would help.
Thank you.
Thanks for liking the video.
As for your scenario, I would have to either look at your app in action ot recreate your scenario to provide guidance.
I will recommend posting your query/issue with screenshots on the forums at powerusers.microsoft.com
how to patch multiple value in poeple and group? I have manger names display in textbox and need to display them on pepole and group? plz help
rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
HI Reza, with the People Picker control, even if I enter and select another persons name, when the data is patched to SP list, it displays my name and not the person whom I selected.
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 don't know why but Choices doesn't work for me. I needed to use Distinct(UK_Contacts, UK_Segment)
Choices is a standard function that works with Choice and Lookup type columns. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi; Time: 13:40 How are the details unlocked?
I did not understand your question.
How to update both SharePoint list fields and corresponding powerapps field using MS flow?
If I select trigger the action when an item is created in SharePoint, then only SharePoint list field is getting updated ,powerapps form filed will remain same. If I select trigger action as powerapps, then I am not getting the SharePoint form 🆔.
Could you please make a video on this scenario? A simple approval workflow with a status field in powerapps?
If power apps is connected to SharePoint and if SharePoint list is being updated then the changes should reflect in Power Apps. Sounds more like an issue or some disconnect with me understanding your use case. I will recommend you check on the forums at powerusers.microsoft.com/
@@RezaDorrani I have set my status field display mode as view in powerappps, (I don't want to edit the status field by an end user). when I change other field value through workflow, they are getting updated( they have display mode as edit). Hw can I change a field with view mode through workflow.
@@shinshae7882 Display mode of control in Power Apps has no effect on updating the field from flow. You can simply use update item action and set the values for the fields.
How to browse excel file and insert VBA module and run it in powerapps
I have never tried that. Try checking on the forums at powerusers.microsoft.com
Reza, the patch can be used with a data form as well. I have found issues with Combobox (with filter) when I move from submitting to patch.
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks I will do that.
Hi Sir
I have data in Excel 20 Rows and 5 Columns (Columns and Rows may vary based on available data).I want to copy (Ctrl C) all data from excel and past (Ctrl V) into PowerApps canvas and Patch to SharePoint along with few headers in Canvas with the help of button.
Request your help in this regard.
I have never tried that. I dont think copy and paste works that way.
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hi Sir
Thanks for your reply. Request you please suggest any alternate method.
@@bujjibabukj9616 I would have to try this out to suggest. I would recommend you post your query on the forums at powerusers.microsoft.com/
@@RezaDorrani Thank you Sir
I have posted in powerusers.microsoft