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

Подписаться 163 тыс.

Просмотров 34 тыс.

50% 1

In this video, you will learn how to patch complex SharePoint columns with Power Apps. With this comprehensive guide, you will be able to handle different types of columns in SharePoint such as Choice, People, Lookup, Images, and more. From overviewing the SharePoint list and the column types to patching static and dynamic values, this video covers it all.
The video is broken down into chapters to make it easy to follow along:
0:00 - Introduction to patching complex SharePoint columns with Power Apps
1:22 - Overview of the SharePoint list and the column types
2:24 - Patching Title, Text, DateTime, Number, and Currency columns
3:14 - Patching a Choice column with a dropdown
4:54 - Patching a Multi Select Choice column with a Combo Box
6:50 - Patching a Lookup column with a dropdown
8:52 - Patching a Person or Group column with a searchable combo box
10:58 - Patching a Managed Metadata column with a dropdown
12:10 - Patching a Yes No column with a toggle
12:53 - Patching a Hyperlink column
14:00 - Patching an Image column with the Add Picture control
16:07 - Overview of patching static values
16:56 - Patching static Title, Text, DateTime, Number, and Currency columns
17:39 - Patching a Choice column with a static record
18:27 - Patching a Multi Choice column with a static table
19:20 - Patching a Lookup column with a static record or table
21:00 - Patching a Person or Group column with a static record or table
24:00 - Patching an Image column with a static image
25:11 - Patching a Managed Metadata column
25:49 - Patching a Yes No column with a boolean value
26:05 - Patching a Hyperlink column
By the end of this video, you will have a solid understanding of how to patch complex SharePoint columns with Power Apps. So, sit back and enjoy the video!
Link to blog post with more details and all of the code www.powerapps911.com/patch

Наука

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 83

@ShanesCows Год назад

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

@ethioone7136 Год назад

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

@ShanesCows Год назад

You are very welcome

@noodle4noggin Год назад

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

@ShanesCows Год назад

You are welcome 🤩🤩

@luket3432 11 месяцев назад

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

@MichaelDeBlasis1369 2 месяца назад

This video is pure gold. One of your best IMO

@ShanesCows 2 месяца назад

Thank you, that means a lot to me. 🐶

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YYizaX6gXW0.html 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.

@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 😎

@andre090598 8 месяцев назад

Bro, you deserve an award

@ShanesCows 8 месяцев назад

Thanks 🏆

@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?

@MultiSweetc1 3 месяца назад

This was incredibly helpful thank you

@ShanesCows 3 месяца назад

Awesome, I appreciate the comment.

@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?

@robertorodriguez8186 8 месяцев назад

The max! Shane! Thank You!!!!

@ShanesCows 8 месяцев назад

Happy to help

@MichaelDeBlasis1369 2 месяца назад

Shane ALWAYS has the answer.

@ShanesCows 2 месяца назад

Happy to help

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

@TheRhoadesFamily Год назад

Excellent sir!

@ShanesCows Год назад

Thank you kindly!

@Rob_K0 Месяц назад

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

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

@MultiSweetc1 2 месяца назад

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 .

@sundrapillay6668 Год назад

Thanks Shane

@ShanesCows Год назад

Happy to help Sundra!

@jekyllhyde05 5 месяцев назад

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.

@FineTuningAnalysis 4 месяца назад

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? 😅

@shathike4079 Год назад

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

@ShanesCows Год назад

Something like this? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GfY63JPdkcs.html

@avocadoarmadillo7031 2 месяца назад

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 2 месяца назад

Happy to help

@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?

@ArkysisGaming 9 месяцев назад

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?

@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

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uqx_h4Ym8ng.html

@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 ,

@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"})

@manjunathak4822 Год назад

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

@ShanesCows Год назад

DOne

@manjunathak4822 Год назад

♥️Thanks

@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!

@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. 🤩

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

@user-mj3xe6hy7q Год назад

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.

@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 10 месяцев назад

@@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 10 месяцев назад

@@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. 😎😎

@thewanderingcouple8378 11 месяцев назад

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

@ShanesCows 11 месяцев назад

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 11 месяцев назад

@@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?