Patch Complex SharePoint Columns with Power Apps - Choice, Person, LookUp, Managed Metadata

[@ShanesCows]

Get the code and more details in the blog post. www.powerapps911.com/patch

[@noodle4noggin]

Shane you are so generous and kind for sharing this content. Thank you for all the help!

[@ShanesCows]

You are welcome 🤩🤩

[@ethioone7136]

Your continuous support in the Power Platform is greatly appreciated. Thank you.

[@ShanesCows]

You are very welcome

[@luket3432]

Just …thanks. Your ability to empathise (empathize in your neck of the woods 😄) is just phenomenal…so great for any level user.

[@MichaelDeBlasis1369]

This video is pure gold. One of your best IMO

[@ShanesCows]

Thank you, that means a lot to me. 🐶

[@andre090598]

Bro, you deserve an award

[@ShanesCows]

Thanks 🏆

[@mikepowers4767]

Great tutorial of everything in the same video. Thank you...

[@ShanesCows]

Thanks. Yeah, it is hard enough without making the video hard too 😎

[@jamesambrose2834]

Shane, I was pulling out my hair for two hours trying to get powerapps to accept my record was actually a record before finding your video! Thank you! (I love the inclusion of Buddy in your videos btw 😋😋)

[@ShanesCows]

Thanks James. 🐶

[@oluwatobipaul6171]

Thank you Shane Young. The multi select is a take home for me

[@ShanesCows]

Awesomeness 😎

[@MrsLaubie]

Brilliant video - thank you so much! For next steps I'd love to learn how I can filter galleries by multi-choice columns or send emails to multi-person in Flow.

[@ShanesCows]

Sarah the filtering answer is in this video. kzbin.info/www/bejne/j4rMq5SOa8yLjZI The concept taught is exactly what you need to do even though the video is slightly different. 🙂 The flow one I haven't done. Good idea. 🤩 I will add it to my list.

[@MichaelDeBlasis1369]

Shane ALWAYS has the answer.

[@ShanesCows]

Happy to help

[@MultiSweetc1]

This was incredibly helpful thank you

[@ShanesCows]

Awesome, I appreciate the comment.

[@robertorodriguez8186]

The max! Shane! Thank You!!!!

[@ShanesCows]

Happy to help

[@TheRhoadesFamily]

Excellent sir!

[@ShanesCows]

Thank you kindly!

[@osamaalam6336]

Hi Shane, great video very informative! Quick question, what if I have a managed metadata column that has the option to manually add values in the SharePoint list, how can that be done in Power Apps? Secondly, when having a lot of terms under a single group for managed metadata, I used a combo box but for some reason it isn't able to retrieve certain records even on search and has only a fraction of the options; any idea how I can deal with that? Thanks for the great content!

[@MultiSweetc1]

Hi Shane , I have a task which has been giving me the hardest time. I have two lists One has Student ID Name of student and the rest of the columns have a class and then a score and so on it could be up to 15 columns with corresponding grade. but I must use a look up list which has the class title , the description of the class and the respective points for each class. Even though the classes are the same they have different scores based on if is a freshman or senior. I just so lost have no idea where to go from here .

[@E1Trapyking1]

Hi Shane - great videos and all explained very well. How would you use the data from a complex column say multi select column in a combo box to filter a gallery?

[@paolovr1970]

Thanks Shane 🙏🙏🙏

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@avocadoarmadillo7031]

Thanks for this. I was getting stressed chasing my tail trying to patch a 'request submitter' to a multi-person choice column. I thought what I had made sense, but it simply was not working.

[@ShanesCows]

Happy to help

[@marcy4227]

Thanks for your explanation. Does a person column have to be a combo box? I used a dropdown to auto complete text input fields that pulls in job title in one field and dept in another. Populates as expected but when patching i did multiple {odata...} for each of those fields updating the dept: and job title: separately. No code errors but it doesnt pull data back to the SP list.

[@kwamebuanyinaohemeng919]

Great video. Thanks for putting this together. In 21:06 for the multiperson input, is there a way to enter all the people without listing them one at a time?

[@FineTuningAnalysis]

Hi Shane, first of all, I find your Power Apps tutorials very helpful! 😎 I have one quick question, I have an app that I am building that tracks the tasks completed on a construction project for each unit. I have all of the tasks in a gallery and one of the controls in the gallery is the 'add picture' control one, so when populating the Patch Function, I am trying to the '.Image' string at the end of the name of the control but it isn't populating as an option and is saying an error when I still put it in. Any ideas what might be happening? 😅

[@tofferbase405]

I hope you can recognise this comment. I was trying to update my sharepoint list via power apps. My problem is in my sharepoint list i have a PO number with multiple items. How can update the status, example the status is pending, and when i update it new status will be approved, how can i do that by just one click. Inhave tried but only 1 item was updated, the status of the other two items under the same PO number did not change

[@ShanesCows]

YOu need to use the ForAll function to loop through all of the records. kzbin.info/www/bejne/nJ6vdKF_mr6WpJY

[@tofferbase405]

@@ShanesCows thanks for this but your example is from a gallery. My screen display is a datatable.

[@shathike4079]

Hi, very good explanation and i am looking to add values manually dropdown list in PowerApps using SP List

[@ShanesCows]

Something like this? kzbin.info/www/bejne/fZe8Z2aAhcmemdU

[@manjunathak4822]

Good Content.Thanks Shane..and asked one question in last short comments can you provide answer for it.

[@ShanesCows]

DOne

[@manjunathak4822]

♥️Thanks

[@sundrapillay6668]

Thanks Shane

[@ShanesCows]

Happy to help Sundra!

[@jekyllhyde05]

Hi, Shane. How about patching combo box values with multiple selected items that is using a lookup field from another SP list? Been cracking my head over this for the past weeks. Hope you can help and thank you in advance.

[@tofferbase405]

Need help. I inserted an avatar in my power app, i connect the image property to a text input where the approver's name indicated. Let us say the approver is Jayson, but that avatar image always showing letter A instead of J. How can i fix it?

[@ShanesCows]

Sorry, I haven't done that before.

[@carolerlston3876]

Thank you so much for your very helpful video. How would one patch multiple records in a gallery to their respective lookup columns in a SharePoint list?

[@jatinsaini7773]

Hi Shane, Great amazing outstanding video. I just have a quick question: I have a multi select person column, and I want to add a new person to that column ensuring that the existing persons does not get removed. GREAT THANKS.

[@masiemil2584]

So what would be the best way to patch attachment links to a column? with a HyperLink? Solutions appreciated!

[@ShanesCows]

This works for me 😎 Patch(Law, Defaults(Law), {Title: "Test", HyperLinkColumn: "training.powerapps911.com"})

[@erenuyank4153]

Hello, thank you! I'd like to ask a question related to same topic.. I have a person column in SP list and I show this person name in the ComboBox (as DefaultSelectedItems). I need use this info (from ComboBox) in the "Patch" function. I tried as you explain in the video for person columns. But I couldn't use ComboBox output in the script, you use already as string (like email) in your code. How can I solve this?

[@ShanesCows]

Leave a new comment with your Patch formula and I will look at it. What is the Items property of your Combo Box also?

[@nico4im466]

Hey Shane, great Video I loved it! I have a question about the PowerApps Calendar you made a year ago. Today is the 7th february and my Calendar is still showing me the days from January. If I press the Button "Start here" which should refresh the Calendar it always gets me back to January.. do u know how I can fix that ? Thank you so much and greetings from the beautiful germany!

[@ShanesCows]

Hi Nico. I am not sure why your calendar would be doing that. I just opened mine up and it jump to Feb like it should. 😐 HEre is my OnStart code if it helps. Set(varFirstDayMonth, DateValue(Month(Today())& "/1/"& Year(Today()))); Set(varFirstDayViewMinus1, varFirstDayMonth - Weekday(varFirstDayMonth) ); Set(varFirstDayViewNextMonth, DateAdd(DateAdd(varFirstDayMonth, 1, Months) , 7- Weekday(DateAdd(varFirstDayMonth, 1, Months)),Days) ); ClearCollect(colSharePointEvents, Filter('Test Events', (StartDate > varFirstDayViewMinus1 And StartDate varFirstDayViewMinus1 And EndDate

[@nico4im466]

​@@ShanesCows Its not working and I really dont know why. Here´s my code, maybe you can detect why it´s not working. Set(varVideoMonth; DateValue(Month(Today()) & "/1/" & Year(Today())));; Set(varVideoFirstDayView; DateAdd(varVideoMonth; - Weekday(varVideoMonth; Monday); Days));; Set(varVideoFirstDayNextMonth; DateAdd(DateAdd(varVideoMonth; 1; Months); 7 - Weekday(DateAdd(varVideoMonth; 1; Months)); Days));;

[@ShanesCows]

@@nico4im466 Try taking out the Monday and see if you get the right answer? I am wondering if you need to add Monday into the logic for varVideoFirstDayNextMOnth? Sorry, hard to troubleshoot without me recreating it all. 😔

[@nico4im466]

@@ShanesCows Hey Shane, nothing is working and my brain is exploding cause I can´t fix it. I tried to add and delete monday as you told me but its still not working. Everything works, only the automatic switch to the next month is giving me problems over problems. But thank you for trying to help, I appeciate it! 😒

[@nico4im466]

@@ShanesCows Nevermind, I was looking for some answers via ChatGPG and it worked. This App is genius and helped me instantly. Have a great day Shane!

[@maddiebeatz98]

is there anything you do differently when patching an ID lookup column ?

[@ShanesCows]

I don't think so. Unless you mean the actual ID column, it is the primary key and it is not patch able. SharePoint autogenerates it. But if you mean a Lookup column then the video should work.

[@shreyasonawane8119]

hey I simply want to patch the combobox data to my sharepoint document library is it possible ? coz u have used list and i am using document library ,

[@usernameksrk]

Hi Shane, Thanks for the video. In my case, i have 70-80 managed meta data terms and when i choose combo box field in the front end, app displays the top 20 items only. Though user can search as you type but it’s not like end user will be aware of all the ‘startwith’ keywords of these terms. Any workaround for this issue? Thanks!

[@ShanesCows]

Use a gallery instead of a combo box. It will take up more space but if you do a little work you can make it look nice and not too big. 🤩

[@usernameksrk]

Thanks for the response. Will try that and see if i can patch the gallery selections to the SP list

[@SubhashA-p9z]

Hello Shane, how can we patch sharepoint location column

[@ShanesCows]

I have never tried that one. Not sure, I will have to add that to my list to try.

[@NimaRamharand]

Hi, thank you for helpful content. Shane I'm new here and I'm looking for a way for using power app in SharePoint On-Perm. Have you any content in this subject?

[@ShanesCows]

Nima Power Apps is only in the cloud. You can connect to on-prem via the gateway though. kzbin.info/www/bejne/q6LbkJtqjtJrpMk

[@ArkysisGaming]

Hi Shane, I believe the image column has changed in SharePoint. I tried to take the uploadedimage.image property and use it to patch an image column, but it told me that it expects a record, not text. I did some further digging and found that SharePoint image columns now have 4 properties and are therefore stored as a record: Full, Large, Medium, Small. I would assume these are meant for resolution differences and better performance based on image size. I still cannot figure out how to patch directly to the column. It shows up blank even when I patch the column using a record like: {Full: uploadedimage.image, Large: uploadedimage.image,... (and so on). I'm able to patch to a multiple lines of text column, but the image column will not save successfully. Any ideas?

[@geralddahl9159]

I think you tweeted that you slaved 9 hours of video editing on this, over and above generating the SharePoint site and app in Power Apps, so thanks! Would you care to produce a Dataverse version of this, perhaps for columns that require slightly different Patch syntax? (I’m working from memory, but I seem to recall a terrible time I had trying to patch a multi choice Dataverse field, particularly when updating the record as opposed to patching default etc.) Enjoy the Super Bowl?

[@ShanesCows]

Gerald I was thinking a DV version of this was a natural next step. :) It is on the list for sure. 😍

[@renedoucet2849]

@@ShanesCows that's great.. I definitely second the request for DV version. Thanks for the video!

[@AmyCustomer]

@@ShanesCows I wish you included a version where all the column types are patched from a nested GroupBy gallery. I'm finding it quite impossible.

[@ShanesCows]

@@AmyCustomer that is too specific. You can submit your question/details in the free help contact form over at www.powerapps911.com and maybe someone on the team can nudge you along. 😎😎

[@kimsalas8197]

Thanks for the video. The link to the blog post doesn't work, however.

[@ShanesCows]

www.powerapps911.com/patch Hmmm. I will go double check it. Sorry about that Kim. Hope you are doing well. 🤩

[@michaelmcdaniels8812]

How do you patch an attachment?

[@ShanesCows]

Not possible sadly. Power Apps Attachments for SharePoint - Files, Images, and Signatures kzbin.info/www/bejne/gWiXhnmPnNd-eJY have to use flow

[@Justinline]

Great video, but I am getting an error for "Missing column. Your formula is missing a column 'Id' with a type of 'Number'. I don't have a column with that besides the default ID column. Not sure what I'm doing wrong when it looks exactly like what you're doing. Any help is appreciated.

[@Justinline]

I realized there's an issue with the Lookup column I'm using that's populated by another SP List.

[@ShanesCows]

Glad you got it Justin.

[@thewanderingcouple8378]

Why we would use static data? I mean what is static data?

[@ShanesCows]

For example maybe you want to automatically set the Manager to the logged in User or the Hire Date to Today's date. The idea is it is "static" because the user isn't entering it, the formula has the value "hard coded". Hope that helps

[@thewanderingcouple8378]

@@ShanesCows yeah that means default value.. Thanks Shane 😊

[@zzerozero2722]

how can i resolve this im getting this error during the first patch no problem on the next patch 👉The requested operation is invalid. Server Response: my_table failed: Save Conflict. Your changes conflict with those made concurrently by another user. If you want your changes to be applied, click Back in your Web browser, refresh the page, and resubmit your changes. clientRequestId: 4defca3f-a93a-4fb3-8454-ab00364b35c1 serviceRequestId: 4defca3f-a93a-4fb3-8454-ab00364b35c1...

[@prempasanha3]

I am trying to patch multiple values from combo box and used similar code as in video but i get error that "Expecting a Table but different schema" .Here is my code: Patch(A360Forms,{EmployeeName:NameInput.Text,Email:Email_text.Text, Jobtitle:Jobtitletext.Text,RequestedMarkets:ComboBoxMarkets.SelectedItems,BusinessJustification:BusinessJustificationText.Text}) Any Idea?