Answered

SharePoint Update Item Action : Managed Metadata Columns only returning single term

(0) Share

Report

Posted on by MP4249

Hi,

I have a flow that is used to collect attachments from a list and copy them to a document library along with all the relevant column data values. There are two managed metadata columns that I need to update the values for, but am only seemingly able to pass the last value to each column - How do I configure to update ALL managed metadata terms from one to another?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MP4249 ,

I'm afraid I don't quite understand what your problem is. Could you provide more details?

If you fill in Value, then it should be updated correctly.

Best Regards,

Was this reply helpful? Yes No
MP4249 63 on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft

Hi,

The problem is that it only returns a single metadata term - not all that are present in the list.
The 'Create File' related actions are within an 'Apply to each' action and works as expected for all other file properties:

However, when I try to add the Managed Metadata column values, it further automatically wraps each output in a further 'Apply to each' action which I believe is causing the problem:

Hope this provides enough information for you to help advise how this should this be configured.

Many thanks,
Mike

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @MP4249 ,

This problem occurs because you set the field to allow multiple selections.

You can refer to the following method to update the two fields, for example, to update the Tags field. You can follow a similar method for the other field.

Initialize the array variable to store the Tags value contained in the item, traverse the Tags and append the value to the variable in the specified format.

Finally, update the file property with variables. The point is to append the value of the managed metadata field in the item to a variable to use.

Image reference:

Best Regards,

Was this reply helpful? Yes No
MP4249 63 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks I got this working by using a variable as advised.
However there is no need for the Append variable action as simply storing the value in a variable works fine.

Thanks

Was this reply helpful? Yes No
Mello 2 on at

Like (0)

Report
Copy link

Link copied!

When I update the list item I get the following error: "The data returned from the tagging UI was not formatted correctly"
I assume that's because the value in my array needs to include the term GUID.
So instead of sending: [ { "Value": "Equipment" } ]
I need to send: [ { "Value": "Equipment|172509b8-b3d5-434f-8121-5262d382a56f" } ]
How do I get the GUID for the term?
Using the "TaxonomyHiddenList" is not an option because not all terms will be used before being assigned.

Was this reply helpful? Yes No
AsheerHasan 93 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have followed all the steps bus still it's storing the last selected managed meta data values in the library. Please assist.

Was this reply helpful? Yes No