Power Apps Patch Function Examples For Every SharePoint Column Type

Power Apps Patch Function Examples For Every SharePoint Column Type



Welcome to my mini-guide on using the Power Apps Patch Function with SharePoint.

Inside you will find examples of how to patch every SharePoint column type. Each page contains code and visuals to show what the code is doing. COPY + PASTE code from the guide into your own app.  Just change the datasource name and column names to match your own.



Power Apps Patch function examples by SharePoint column type:



There is no way to PATCH these column types:

  • Calculated Column
  • External Data Column
  • Location Column




Questions?

If you have any questions or feedback about Power Apps Patch Function Examples For Every SharePoint Column Type please leave a message in the comments section below. You can post using your email address and are not required to create an account to join the discussion.

Subscribe
Notify of
guest
20 Comments
Oldest
Newest
Inline Feedbacks
View all comments
Ryan
Ryan
2 years ago

Hi Matt,
Thanks to this tutorial I just patched to a lookup column for the first time! Next, I’m wondering if it is possible to collect to a lookup column when collecting a whole collection to a datasource (eg. Collect(Datasource, Collection)
Is it possible?

Sudheer
Sudheer
1 year ago

Hi Matt,

Thanks for the article. Can you please share how to work and store Managed Meta data columns using Power apps.

Kiki
Kiki
1 year ago

Can you please share tips on how to patch gallery selection that has a nested gallery?

OlaH
1 year ago

Hi Matt
Thank you for this invaluable resource that helped and developed my knowledge.

I’m stuck when it comes to merging two collections, from two Sharepoint lists that contain students’ test results. It’s about how I handle columns with the same name. The key is upn, but then there are also the students’ names, school and class.
Dropcolumns, showcolumns?

Stefan
Stefan
1 year ago

Hi, is there a way to change the First Published Date for News?
We are transferring lots of News to a new Sharepoint and we want them to have the correct Publish date but this not editable.

Thanks

Justin David
Justin David
1 year ago

Good Evening @Matthew

Thanks for the write up tell me how would i go about adding a event created to a outlook calendar?

Sean Douglas
Sean Douglas
10 months ago

“PATCH A SharePoint Image Column” seems incomplete or just does not work. Do you have any pointers or further explanation on that solution?

Darren Neese
9 months ago

Now give me the same list for those of us who might be using Dataverse! 😂

StefWS
StefWS
4 months ago

Ho do I patch a lookup column to my sharepoint list. Not the lookup’d column itself. I have a main SPList with lookup columns. I populated dropdowns with the secondary lists (because I can’t sort lookup column directly). Now I want to patch my selected choice (from the secondary list) into my main list, but this gives an error since the data types don’t match.

Brock
Brock
3 months ago

I’m struggling with patching a Person column, I’ve always used the formula you list out in your Patch the SharePoint Person column page and it has always worked flawlessly, but now I have an application I am building where it just simply will not work, and I cannot work out why. I get the error “Missing column. Your formula is missing a column ‘Email’ with a type of ‘Text’. (which it is not, this exact formula works if I copy paste it into another application that does this same patch function)

Any ideas?

Brian Scott
Brian Scott
3 months ago

Just wondering how to trap an error if the column is set to “Enforce Unique Values” –