Updating a managed metadata column of a document set in Power Automate based on a managed metadata column value from a list item

Eddy Feys 70 Reputation points
2025-06-27T09:35:23.03+00:00

If you want to create on a uniformed way document sets based on a state in a Microsoft List, you can now use the power automate sharepoint action "Create a new document set"User's image

Earlier, I used "Get item" in order to obtain all dynamic data fields of a selected item. In that list is a "Brand" column which is configured as a managed metadata column linked to a tenant level term store term set. That way I can use the following dynamic data

User's image

When I use the action "Create a new document" set, i get the metadata fields of the document set. For every managed metadata field, i see the internal name of the field followed by "Value". So for the managed metadata field "Brand", i see in the power automate action "Brand Value" with a dropdown feature in which i see the terms of the connected term set. So far, so good.

Next, I take the dynamic data value from the get items action e.g. "Brand Value" and put it in the document set "Brand Value" field.

Testing it, gave in raw input the Dynamic value formatted als Label|termguid.

Nevertheless, in real result the Brand managed metadata field stayed blank.

Next, I was thinking, perhaps I must first create the document set and a little later go updating the properties. I did the same in the update action, and I get the error "Action 'Update_file_properties' failed: The data returned from the tagging UI was not formatted correctly"

Next I created a Compose action to construct something I found on the netUser's image

But even that, did not work.

What is wrong? How can I realize bringing over the content of a managed metadata field in a list to the same named and configured managed metadata field in a library in a document set.

Who helps me?

Microsoft 365 and Office | SharePoint | Development
0 comments No comments

Answer accepted by question author
Jayden-P 26,285 Reputation points Microsoft External Staff Moderator
2025-06-27T13:01:41.3433333+00:00

Hi @Eddy Feys

Thank you for posting your question in the Microsoft Q&A forum. 

Since Power Automate isn't supported in this forum, I kindly recommend reaching out directly to the Power Platform Community team, as they are best positioned to address and resolve this type of issue efficiently.

However, I did some research and here is what I found:

"Action 'Update_file_properties' failed: The data returned from the tagging UI was not formatted correctly" typically occurs when Power Automate attempts to update a Managed Metadata field with improperly formatted data.

Update file properties can update when you turn on "Input entire array" option.

Please correct me if my understanding is wrong.

Due to limitations in this area, I regret that I’m unable to assist you effectively. I apologize for redirecting you to another platform. There will be dedicated specialists in Power community to assist you.

Thanks for your understanding.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

User's image

Was this answer helpful?


0 additional answers

Sort by: Newest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.