Showing results for 
Search instead for 
Did you mean: 
Level 8

Workaround to update SharePoint document metadata custom columns

Microsoft has been making great strides in improving PowerApps functionality over the past year.  In late 2017, the product team announced the ability to set values for Managed Metadata (aka Taxonomy) columns in PowerApps and Flow.  This is great if you are using managed metadata fields in a SharePoint List, but does not work for SharePoint Document Libraries according to Connect to SharePoint from PowerApps.

So how do you update the Document Library managed metadata?  Consider the fact that wherever you use the same managed metadata, the same term set, terms, and associated globally unique identifiers (GUIDs) are used.

The work-around is to access the managed metadata and combine it with the Document Library data.  One way to achieve this is to create a SharePoint list that can be used for the sole purpose of hosting these metadata fields.  Then, when building the PowerApp, you can pull in all the data you need from the Document Library and the metadata-hosting list and pass it to SharePoint, a Flow, or any other downstream work action to update the Document Library managed metadata






Simple enough. 

Community Support Team
Community Support Team

Re: Workaround to update SharePoint document metadata custom columns

Thanks for sharing this




Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 309 members 5,974 guests
Please welcome our newest community members: