How to Create SharePoint Term in Term Store Using Power Automate

I was working on a document management system for a client where they used the Term Store in SharePoint to manage metadata. The Term Store is useful for keeping tags consistent, but sometimes not everyone has permission to add new terms. This created a problem when users wanted to add missing terms.

After some research, I found a way to solve this using Power Automate. With a simple workflow, we can automatically create terms in the Term Store.

In this tutorial, I will show you how to create a Term in the Term Store using Power Automate.

Create a Term in the Term Store Using Power Automate

For this example, I created a SharePoint list with two columns:

• Term Name
• Description

This list will act as the input source for the flow. Each time a new item is added to the list, a term will be created in the Term Store.

But before we build the flow, we need two important IDs:

• GroupId (ID of the Term Group)
• TermSetId (ID of the Term Set)

We will use these IDs in the flow when creating terms.

How to Get GroupId and TermSetId

1. Open the Term Store in the SharePoint Admin Center.
2. Select the Term Group where you want to add the term.
3. Copy the GroupId. It looks like this:

7dc4e8e3-5179-5fdb-719d-709982716622

4. Next, select the Term Set under that group.
5. Copy the TermSetId. It looks like this:

69bdb139-ec3d-4540-82b1-f1c37b1969d1

Keep both IDs safe, because we will need them in Power Automate.

Steps to Create a Term in the Term Store Using Power Automate

1. In the Power Automate Home page, create an Automated cloud flow with a ‘When an item is created‘ trigger. Set the site address and list name.

2. Next, add an Initialize Variable action and provide the parameters below:
   • Name: varGroupId
   • Type: String
   • Value: Past the Group ID.

3. Again, add an Initialize Variable action and provide the following parameters:
   • Name: varGroupId
   • Type: String
   • Value: Past the Group ID.

4. Add a Send an HTTP request to SharePoint action under the trigger and provide the following parameters:
   • Site Address: Select the SharePoint site address from the dynamic content.
   • Method: Select POST as the method.
   • Uri: Provide the below URI:
     • _api/v1.0/termStore/groups/@{variables(‘varGroupId’)}/sets/@{variables(‘varTermSetId’)}/children
   • Body:

{
  "labels": [
    {
      "name": "@{triggerBody()?['TermName']}",
      "isDefault": true,
      "languageTag": "en-US"
    }
  ],
  "descriptions": [
    {
      "description": "@{triggerBody()?['Description']}",
      "languageTag": "en-US"
    }
  ]
}

5. Save and Test the Flow. Go to your SharePoint list and add a new item (Term Name + Description). For example, I add ‘HR’ with the description ‘Human Resources Department’.

After the flow runs successfully, go to the Term Store, and we will see the new term created automatically.

This way, we can create a Term in the Term Store using Power Automate.

You may also like the following tutorials:

• SharePoint List Title Column
• Enable Users to Add New Terms to SharePoint Term Store
• Content Approval in SharePoint
• SharePoint Column Validation Formula Examples
• SharePoint Online Number Column without Comma