SharePoint Document Issues

How to Copy SharePoint Managed Metadata Values with Power Automate

Maira Mehtab Oct 15, 2026 869 views

Question details

The user needs to copy a multi-value managed metadata Department column from a SharePoint list item to a document library using Power Automate.

How to Copy SharePoint Managed Metadata Values with Power Automate

Product: Microsoft SharePoint and Power Automate
Device & OS: not provided
Scenario: Automating document management processes where existing list item metadata must be dynamically replicated to a destination document library.
Observed behavior: Attempting to copy the managed metadata values directly often triggers a term store GUID error if the array isn't structured to SharePoint's exact requirements.

Before you start

Ensure you have edit permissions for both the source SharePoint list and the destination document library. Verify that the managed metadata 'Department' column is configured identically in both locations and mapped to the same Term Set.

Solution 1Recommended

Switch to Input Entire Array in Update File Properties

Use the entire array input mode in Power Automate to pass properly structured term values, avoiding term store GUID errors.

SharePoint expects multi-value managed metadata to be passed as a complex array of objects containing both valid term identifiers and labels. Manually constructing strings or basic arrays inside an 'Append to array variable' action often results in missing properties, triggering GUID errors during the update phase.

Build the formatted array

Create an array in Power Automate formatted exactly as SharePoint expects for managed metadata. This must include the correct term labels and valid term identifiers (GUIDs) extracted from the source list item.

Add the Update File Properties action

In your flow, add the 'Update file properties' action and point it to your destination document library.

Switch to input entire array

Locate the multi-value managed metadata field (e.g., Department) in the action parameters. Click the 'Switch to input entire array' icon located next to the field box.

Pass the variable

Insert your fully constructed array variable directly into this field. Save and test your flow to verify the metadata copies without errors.

Switch to Input Entire Array in Update File Properties

Data Formatting Success: Passing the complete, properly formatted array directly ensures SharePoint recognizes the unique term structures and applies the metadata seamlessly.

Free Microsoft Office alternative

Discover a Lightweight Alternative to Microsoft Office

Dealing with complex Microsoft ecosystems like SharePoint and Power Automate can be overwhelming for everyday document tasks. If you need a simpler, highly compatible way to manage, edit, and share Word documents, Excel spreadsheets, and PowerPoint presentations without the hefty subscription costs, WPS Office is the perfect solution.

1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install and Launch: Run the installer and follow the simple on-screen instructions to set up the software in minutes.
3. Open Your Office Files: Open any existing Word, Excel, or PowerPoint document directly in WPS Office with formatting perfectly preserved.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx) frequently stored in SharePoint environments.Familiar, intuitive tabbed interface ensuring a zero learning curve and seamless migration.Free to use, offering powerful word processing, spreadsheet, and presentation tools.Lightweight application design that opens files quickly without draining system resources.

Frequently Asked Questions

Why do I get a term store GUID error in Power Automate?

This error occurs when Power Automate attempts to write a raw string or an improperly formatted array into a SharePoint managed metadata column. SharePoint strictly requires a specific JSON object structure that includes the correct Term GUID and WssId.

Can I copy single-value managed metadata without switching to the entire array?

Yes, single-value managed metadata columns are less complex. You can typically map them directly by selecting the dynamic content (like the Term Guid or Label) from the source item without needing to click 'Switch to input entire array'.

How do I find the Term GUID for a specific label in SharePoint?

You can find the Term GUID by navigating to the Term Store Management Tool in your SharePoint Admin Center. Select the specific term from the hierarchy, and you will see the 'Unique Identifier' property listed in the general settings tab.

Does the destination document library column need to be completely identical to the source list?

For a seamless data copy, both the source list and the destination document library should have their respective managed metadata columns configured to allow multiple values and be mapped to the exact same Term Set in the SharePoint Term Store.

Document & File Issues