Update SharePoint Managed Metadata Column using string

[gj84uw]

Hi everyone

I have a flow that updates columns on a SharePoint document when it is uploaded.  The metadata for the document is obtained by splitting the folder structure of the library.  So for example if they uplpoad the document into TestLibrary/Department/DocumentType my flow splits the path and uses each section as a piece of metadata.

This works fine apart from the department column as this is a managed metadata column in the library.  If I try to pass the department string as the department MM value I get an error saying:

The data returned from the tagging UI was not formatted correctly

I'm guessing this is because the MM column is expcting both a value and GUID?  If this is the case is there currently any way I can get the GUID that matches the value and pass both to the MM column value in Flow?

Any assistance would be gratefully received.

Thanks in advance.

[RezaDorrani · Accepted solution]

Hi @gj84uw 

Since you do need the guid

Your only option then would be to first query the hidden taxonomy list that gtes generated on each site

/Lists/TaxonomyHiddenList/AllItems.aspx

query this list in Flow and get the equivalent guid for the tag and then accordingly update your field

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[gj84uw]

@RezaDorrani 

Excellent thanks!  I'd been looking at using the send web request to SharePoint actions to achieve this but your method is much simpler.

[ARM]

How did you pass both values into a an update file properties flow?