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:

This column type cannot use PATCH however there is a workaround:

PATCH A SharePoint Image Column

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.

14 Comments

Oldest

Newest

Inline Feedbacks

View all comments

Ryan

1 year 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

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.

Matthew Devaney

1 year ago

Reply to Sudheer

Sudheer,

Suggest you check out this page by my friend Reza Dorrani: https://rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/

Kiki

11 months ago

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

Matthew Devaney

11 months ago

Reply to Kiki

Kiki,

I would suggest you ask this question in the Power Apps forums:
https://powerusers.microsoft.com/t5/Forums/ct-p/PA_Comm_Forums

OlaH

11 months 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?

Matthew Devaney

11 months ago

Reply to OlaH

Hello Ola,

Check out this page from my “Collections Cookbook.”
https://www.matthewdevaney.com/powerapps-collections-cookbook/join-all-columns-from-another-collection/

Stefan

11 months 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

Matthew Devaney

11 months ago

Reply to Stefan

Stefan,

Not sure. SharePoint migrations are not my specialty.

Justin David

10 months ago

Reply to Matthew Devaney

Good Evening @Matthew

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

Matthew Devaney

9 months ago

Reply to Justin David

Justin,

To create a new event in Outlook you would have to use the “Create Event” action in the Office365Outlook connector. This is not done using the PATCH function.

Link: https://docs.microsoft.com/en-us/connectors/office365/#create-event-(v4)

Sean Douglas

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

Matthew Devaney

2 months ago

Reply to Sean Douglas

Sean,

I agree it seems like I stopped short of a working solution. What does the Update property of the card for the Attachments column say? Can you point it at the control like this?

AttachmentsControlName.Attachments