Get Managed Metadata Term ID from Term Store

[mikkele]

I am using the Parse JSON action to parse a JSON file and create items in a SharePoint list.

The items in the list have managed metadata columns, and the format required in the JSON file for metadata is "<TermName> | <TermID>"

I have the Term name in the JSON file but not the TermID, so I would need to query the Term Store to grab the TermID based on the Term Name

How can I do that? 

[v-yamao-msft]

Hi @mikkele ,

Could you share more details on your flow configuration?

Please check if the following doc could be a reference for you:

http://www.cleverworkarounds.com/2017/10/23/powerapps-flow-and-managed-metadata-fields-part-4/

Best regards,

Mabel

[mikkele]

I'm parsing a JSON file that contains certificates information from a server, including server name, customer, service, environment, and certificates details

Then I'm creating a SharePoint list item using the values in the JSON, basically it creates a new item for each certificate in the JSON

The problem is that I need to hardcode the TermID in the JSON which is not flexible/viable, therefore my need to query the TermStore. In this example I would have the Term Name IPW in the JSON and I would like to use Flow to retrieve the TermID for that customer.

the same goes for Service and Environment which are all Managed Metadata columns