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

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!

[ethioone]

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

[noodlenoggin]

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

[luket]

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

[mikepowers]

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

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

[MichaelDeBlasis]

This video is pure gold. One of your best IMO

[jamesambrose]

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 😋😋)

[oluwatobipaul]

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

[MultiSweetc]

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 .

[manjunathak]

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

[Rob_K]

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?

[shathike]

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

[avocadoarmadillo]

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.

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

[jatinsaini]

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.

[nicoim]

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!

[kwamebuanyinaohemeng]

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?

[jekyllhyde]

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.

[carolerlston]

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?

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