Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Updating a managed metadata column of a document set based on a simelar field from a list item

(0) ShareShare
ReportReport
Posted on by

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 net

User'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?

(I earlier posted it Updating a managed metadata column of a document set in Power Automate based on a managed metadata column value from a list item - Microsoft Q&A but was invited to post it here)

  • Expiscornovus Profile Picture
    31,946 Most Valuable Professional on at
    Updating a managed metadata column of a document set based on a simelar field from a list item
     
    I have used a HTTP request with the update driveitem method for this in the past.
     
    That might be worth a try in your setup as well?
     
    Below is an example based on a blog I created a couple of years ago:
     
    The format of the MMS field (Customer) was the below. Notice that the value also ends with a semi colon character.
    "Customer": "Fabrikam Travel|2fe1fa4e-f9c5-4ea6-8d65-7d934d5ed50c;"
     
    The whole payload was the below, which included the conversion of a regular folder to a document set via the contentType property.
    {
    "fields": 
    {
    "Order_x0020_Status": "Proposed",
    "Customer": "Fabrikam Travel|2fe1fa4e-f9c5-4ea6-8d65-7d934d5ed50c;",
    "Product_x0028_s_x0029_": "SharePoint Online|7c932ee6-c55a-429b-9b06-3b72690ed3c9;"
    },
      "contentType": {
        "id": "@{variables('ContentTypeId')}"  
    }
    }
     
     


     
    Happy to help out 😁

    I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492