Scenario:

Fetching Terms from a Specific Term Set in a Term Store

Objective

You want to retrieve all terms from a specific term set within a term store in SharePoint. The term store and term set are identified by their unique GUIDs.

Steps:

Identify the Term Store and Term Set GUIDs

You have a SharePoint site with managed metadata, and you need to fetch all terms from a specific term set. For example, all labels from the Status metadata column.

The term store GUID is TERMSTOREGUID and the term set GUID is GROUPGUID.

Construct the HTTP Request

Use the SharePoint REST API to get the terms by specifying the term store and term set GUIDs in the URL. In the URL you can specify what needs to be queried and where.

Execute the HTTP Request

Make an HTTP GET request to the SharePoint REST API endpoint with the appropriate query parameters. In my example, I grab all terms, from the group for status (by GUID) and from which Term Store item.

If you have multiple levels, check how deep you need to query to get what you want.

Method: Get Uri: _api/v2.1/termStore/groups/TERMSTOREGUID/sets/GROUPGUID/terms

You have now retrieved the entire body of that termset value. Now do a filter array on:

string(item()?['labels']) contains 'name choice field value'

This step is essential to grab the label, i.e the name, which you can then use in the update term set column step, to for example update with Newstatus|bodyfromfilter

But I will explain that later on.