Answered

Sharepoint Taxonomy multivalue fields

(0) Share

Report

Posted on by renatopc84

Dear all

I created a Power Automate Flow to set Metadata of a Folder in a Sharepoint Library. I'm a normal user, so I don't have direct access to the Term Store.

I'm trying with a Send HTTP Request to Sharepoint action to update a Taxonomy Multivalue field.

I saw on this website UPDATE! Using REST to set a multi-value Managed Metadata Field in SharePoint a possible soluton, but I didn't resolved to convert it in Power Automate.

Can anyone help?

I tried with this Body (the URI is ok)

{
"__metadata": {
"type": "SP.Data.SharepointLibraryName_ArbeitItem"
},
"BusinessPartner": {
"results": [
"-1;#Term1|{TermGuid}"
]
}
}

or also so

{
"__metadata": {
"type": "SP.Data.SharepointLibraryName_ArbeitItem"
},
"BusinessPartner": "-1;#Term1|{TermGuid}"
}

I receive always the error that the JSON is not correct and a Primitive Character is present

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (2)

renatopc84 44 on at

Like (0)

Report

Sharepoint Taxonomy multivalue fields

For information I replaced the real values SharepointLibraryName, Term1 and {TermGuid} that in my code are with real values without special characters

Was this reply helpful? Yes No
Expiscornovus 32,932 Most Valuable Professional on at

Like (1)

Report
Sharepoint Taxonomy multivalue fields

This might be caused by the -1? Each term is normally separated by ';#'. So, it looks like you are trying the update the value with two terms, '-1' & 'Term1', is that correct?

If that is not correct, please update your value to:

"BusinessPartner": "Term1|{TermGuid}"

If you want to update it with two terms it would be:

"BusinessPartner": "Term1|{TermGuid};#Term2|{TermGuid}"

For a good example I can also recommend this blog from Tom Riha:

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

Was this reply helpful? Yes No
renatopc84 44 on at

Like (0)

Report

Sharepoint Taxonomy multivalue fields

Hi Expiscornovus

I tried but I receive always the same error (that I translated here) Status 400 "An unexpected PrimitiveValue node was found while reading from the JSON reader. A StartObject node was expected."

Was this reply helpful? Yes No
Verified answer

Expiscornovus 32,932 Most Valuable Professional on at

Like (0)

Report
Sharepoint Taxonomy multivalue fields

Are you using the validateUpdateListItem method?

If not, maybe the below example helps?

URI

_api/web/lists/getbytitle('Folder Metadata')/items(1)/validateUpdateListItem

Body

{ "formValues":[ { "FieldName": "Business_x0020_Partner", "FieldValue": "Microsoft|842d6d80-195b-49de-ac59-f2276973dc89" } ] }

1. The Term Guid of my example Microsoft Term/Label

2. Column setup which uses this Term Group

3. The flow setup which refers to Folder A by using its id (1)

4. The test result

Happy to help out 😁

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

Was this reply helpful? Yes No
Verified answer

renatopc84 44 on at

Like (1)

Report
Sharepoint Taxonomy multivalue fields

Hi Expiscornovus

Thank you very much :)

Your help has been fundamental to solve it.

The example you provided allows me to save only 1 Taxonomy value, but I modified it and in the Body, instead of a single Term, I passed all of them separated by semicolon. I pass directly a string from the Power Apps Form with all the term already formatted in this way.

Thank you again very much!!!

{ "formValues":[ { "FieldName": "Business_x0020_Partner", "FieldValue": "Term1|{Term1Guid};Term2|{Term2Guid};Term3|{Term3Guid}" } ] }

Was this reply helpful? Yes No