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?
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
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
User | Count |
---|---|
61 | |
50 | |
47 | |
27 | |
17 |
User | Count |
---|---|
26 | |
26 | |
21 | |
21 | |
20 |