Answered

Updating a managed metadata using Rest API with FieldName and FieldValue pair

(0) Share

Report

Posted on by Community Power Pla...

Hi, I got an existing managed metadata value (via Send HTTP request with GET method) and am trying to update one in the different list. I was able to do this when I use "Send HTTP request" like this:

Body contents:
{
 "Division": {
 "Label": "@{outputs('HttpGet')?['body']?['d']['Division/Label']}",
 "TermGuid": "@{outputs('HttpGet')?['body']?['d']['Division/TermGuid']}",
 "WssId": @{outputs('HttpGet')?['body']?['d']['Division/WssId']}
 }
}

However, I couldn't figure out how to convert this to formValues (FieldName and FieldValue pair). This is what I tried but didn't work:

Inputs in "Compose formValues"
[ 
 { 'FieldName': 'Division',
 'FieldValue': {
 "Label": "@{outputs('HttpGet')?['body']?['d']['Division/Label']}",
 "TermGuid": "@{outputs('HttpGet')?['body']?['d']['Division/TermGuid']}",
 "WssId": @{outputs('HttpGet')?['body']?['d']['Division/WssId']}
 }
 }
]

Although this didn't crash, it says "The data returned from the tagging UI was not formatted correctly" and this is the actual HTTP's output:

"ValidateUpdateListItem": {
 "__metadata": {
 "type": "Collection(SP.ListItemFormUpdateValue)"
 },
 "results": [
 {
 "ErrorCode": -2146232832,
 "ErrorMessage": "The data returned from the tagging UI was not formatted correctly",
 "FieldName": "Division",
 "FieldValue": "{\n\"Label\": \"4\",\n\"TermGuid\": \"b40496ff-d20d-4758-b8b5-6d4e1ce91c0e\",\n\"WssId\": 4\n}",
 "HasException": true,
 "ItemId": 1
 }
 ]
}

So, I believe the format in "Compose formValues" action is incorrect. Can someone tell me what the right format is?

Thank you in advance.

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Expiscornovus 33,175 Most Valuable Professional on at

Like (2)

Report
Re: Updating a managed metadata using Rest API with FieldName and FieldValue pair

Hi @Anonymous,

You are just updating the field with one value, correct? As far as I am aware you can format the MMS FieldValue like this:

termlabel|termguid

Can you try this as a FieldValue:

concat(outputs('Compose')?['body']?['d']['Division/Label'],'|',outputs('HttpGet')?['body']?['d']['Division/TermGuid'])

Also have a look at this nice blog from @tom_riha, that might be useful as well:

https://tomriha.com/how-to-update-sharepoint-managed-metadata-column-power-automate/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report
Re: Updating a managed metadata using Rest API with FieldName and FieldValue pair

Thank you very much. After I changed "FieldValue" to what you said, it worked!
[ { 'FieldName': 'Division', 'FieldValue': '@{concat(outputs('HttpGet')?['body']?['d']['Division/Label'],'|',outputs('HttpGet')?['body']?['d']['Division/TermGuid'])}' } ]

Was this reply helpful? Yes No
Matt Collinge 43 on at

Like (0)

Report

Re: Updating a managed metadata using Rest API with FieldName and FieldValue pair

Tom gives the best working answer to this. Thank you for sharing the link.

Was this reply helpful? Yes No