FlowBites: Using the SharePoint Term Store
Hi everyone, and welcome to FlowBites, my bite size Power Automate tutorial series.
Tagging content within SharePoint is paramount to successful and organised document management. One tool in our tagging toolkit is Managed Metadata, tags which can be globally used, and centrally managed from the SharePoint Term Store.
Working with this type of field from Power Automate, however, isn't that clear cut. If we just put straight forward text, then we will get an error:
"The data returned from the tagging UI was not formatted correctly"
We have to work a little bit harder, and ask the Term Store for the ID of the term as well as the label:
LABEL|TERM ID
To do that we are going to query SharePoint using a HTTP request with the following URI:
_api/v2.1/termStore/groups/[TERMGROUPID]/sets/[TERMSETID]/terms
Once we query that REST endpoint, we can get everything we need to dynamically tag content, using Managed Metadata, from within Power Automate.
If you'd like to connect with me, you can find me on Twitter: / mattweston365 or on LinkedIn: / mattweston365
Please LIKE and SUBSCRIBE!
Have a great day
Matt