Updating a term store in Power Automate

[Arajan123]

I have a term store created:  {
"id": "8bf3af92-0da3-480a-8175-665b6cd67186",
"labels": [
{
"name": "Fish1234",
"isDefault": true,
"languageTag": "en-US"
}
]
},
{
"id": "1e6155c3-f6cb-462d-83ec-7f887768fad5",
"labels": [
{
"name": "Fish123456",
"isDefault": true,
"languageTag": "en-US"
}
]
},

The terms in the term store needs to be updated from a Sharepoint list ( When a new item is added/modified in the Sharepoint list)

How do I design the power automate to :

1. check if the new item added in Sharepoint list exists in the term store

2. If any modification is made to the existing term, how can I retrieve the term id of that term in term store to replace it with the new term name.

[Expiscornovus]

Hi @Arajan123,

Like mentioned in a couple of earlier conversations with you it is possible to achieve this via at least three HTTP requests. I guess you need help putting this all together?

For reference, these are the separate threads I was talking about

- Add a new term, https://powerusers.microsoft.com/t5/Building-Flows/PowerApps-Update-term-store-in-PowerApps/m-p/2659...

- Find a term in your term set, https://powerusers.microsoft.com/t5/Building-Flows/Update-a-term-in-term-store/m-p/2677895

- Update a new term, https://powerusers.microsoft.com/t5/Building-Flows/Update-a-term-in-term-store/m-p/2677895

You can combine those requests with a Get changes for an item or a file (properties only) action to see if a field has changed. For a modified item you can retrieve the previous value from the version history, https://tomriha.com/get-previous-values-of-modified-sharepoint-columns-in-power-automate/

You can reuse that previous value in the find a term in your term set HTTP request. When you found a match you can use the id of that matching tag in the PATCH request.

Below is an example of all these actions together

1. Use a When an item is created or modified action

2. Use a couple of Initialize variable actions to store the Term Group and Term Set ids

3. Use a Get changes for a file or item (properties only) action. Make sure you use the Trigger Window Start Token in the Since and the Trigger Window End Token in the Until fields

4. In the Condition check if the Title field has changed or not (In my setup I am only using that field in the List) 

4. In the If Yes use the add new term approach

5. In the If No add the three actions below.

a. HTTP request for getting previous values from the history

_api/web/lists/getByTitle('EMP Term Set')/items(@{triggerOutputs()?['body/ID']})/Versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']})?$select=Title

b. Finding the term based on the previous Title

_api/v2.1/termStore/groups/@{variables('TermGroupId')}/sets/@{variables('TermSetId')}/terms?$filter=labels/any(a: a/name eq '@{outputs('Send_an_HTTP_request_to_SharePoint_-_Get_Previous_Value')?['body']['Title']}')

c. Updating that term with the new Title

_api/v2.1/termStore/groups/@{variables('TermGroupId')}/sets/@{variables('TermSetId')}/terms/@{outputs('Send_an_HTTP_request_to_SharePoint')?['body']['value'][0]['id']}

{ 
"labels": [
{
"name": "@{triggerOutputs()?['body/Title']}",
"isDefault": true,
"languageTag": "en-US"
}
]
}