Showing results for 
Search instead for 
Did you mean: 
Kudo Collector
Kudo Collector

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
Community Support

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

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,890)