0

How can we update managed metadata column in SharePoint using REST API in Power Automate?

0

You have to use Send an HTTP request to SharePoint with the below API

/_api/web/lists('Libray-List Name')/Items(ItemID)

enter image description here

Ref: Updating a row with METADATA FIELD in Rest API

Also, this guide would help you to understand and work with Automate and Managed Metadata fields

Read more at

1
  • i tired below test is success but its not updating even in version history it show my name but no updates { "__metadata": {"type": "SP.Data.ControlDocumentsItem"}, "Published": 'Yes', "ApprovalStatus":'Publish', "Title":'@{items('Apply_to_each_2')['Title']}', "Business": { "__metadata": {"type":"SP.Taxonomy.TaxonomyFieldValue"}, "TermGuid":'@{items('Apply_to_each_2')['Business']['TermGuid']}', "Label":'@{items('Apply_to_each_2')['Business']['Label']}', "WssId":'-1' } } – kumar Jan 21 at 11:17
0

If you have a GUID of managed metadata term then you can use SharePoint REST API to update managed metadata column in SharePoint using Power Automate.

Check below articles for detailed steps:

  1. Updating A Managed Metadata (MMS) Column Dynamically In A SharePoint List Using MS Flow
  2. Microsoft Flow: update Managed Metadata Column of a Document Set
  3. Microsoft Flow: update Multi value Managed Metadata Column of a Document Set - If you have multiple selection enabled
0

Before updating, you will first need to get the GUID of required term. A simple request will be like below:

enter image description here

‘__metadata’: {   

    ‘type’: ‘SP.Data.YourListTitleListItem’   

},   

“TermFieldName”:{ 

    “Label”:”Test Value 1″, 

    “TermGuid”:”GUID of the Term”, 

    “WssId”:-1 //which make sure to create an entry in TaxonomyHiddenList if not added. 

    }  
1
  • how to update if managed metadata is multiple select ? – kumar Jan 22 at 4:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.