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:

Building flows

All responses (5)

Answers (2)

Sort by

renatopc84 44 on at

Like
a
(0)

Report
Copy link

Link copied!

For information I replaced the real values SharepointLibraryName, Term1 and {TermGuid} that in my code are with real values without special characters
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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/
renatopc84 44 on at

Like
a
(0)

Report
Copy link

Link copied!

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."
Verified answer

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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
Verified answer

renatopc84 44 on at

Like
a
(1)

Report
Copy link

Link copied!
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}" } ] }