Unanswered

Extract Term Set ID from HTTP output

(0) Share

Report

Posted on by CateR

I have a flow that is triggered from an app. When a new item is created in the App, the flow creates a new Term Set Value. The next part that I'm having trouble with is updating a Sharepoint list item with this new managed Metadata term store value.
Using a Send HTTP Sharepoint Get method

I have retrieved the relevant Term Store record:

How can I extract the id value from above so that I can use this (together with the label which is already the variable TermValue ie: "TermValue|<extracted term id value >") to update a managed metadata column type in a sharepoint list?

I've tried using Filter Array, Compose, Initialise variable - I can't figure out how to do it, if it is indeed possible?

Below if the full flow for context:

the TermValue is a parameter from the PowerApp, the Term Group ID and TermSetID are hardcoded. I'm looking for a solution to go after the Get TermStore step to use in the Update Item step.

Also for context the step to create the Term Store record

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (3)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

Hi @CateR ,

Insert a Parse JSON action in your flow using this guide: Power Automate Parse JSON Action Guide | When & How To Use (zeitgeistcode.com)

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @CateR,

In addition to @BCBuizer his approach you can also use an expression to retrieve the id of the single item returned. Just use an index to refer to that first item in the value array.

Try the below expression:

body('Get_TermStore')['value'][0]['id']

Was this reply helpful? Yes No
CateR 86 on at

Like (0)

Report

Hi @BCBuzier,
I have added Parse JSON function as per your suggestion. It is returning similar output to the GET Http request in earlier step. I don't know what to do next to just get the id value

Was this reply helpful? Yes No
CateR 86 on at

Like (0)

Report

Hi @Expiscornovus ,
Can you please provide more specific details - is this expression for a filter array? and how do I "just use an index to refer to that first item"

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @CateR,

You can use that expression directly in an action, in your case the Update Item action.

In my sample I have already added the index for you, the index I used is: [0] (which refers to the first item).

An index always start counting at 0, the second item would be [1], the third item [2], etc.

Below is an example in a Compose action

Was this reply helpful? Yes No
Verified answer

CateR 86 on at

Like (0)

Report

thankyou @Expiscornovus this works really well!

Was this reply helpful? Yes No
CateR 86 on at

Like (0)

Report

Hello @Expiscornovus, I have encountered a problem - if a user creates a term store value that has an apostrophe ie: ' - this flow fails at the Get Term Store stage. I have tried without success to wrap the TermValue variable in double quotations for example changing the URI string to this :
where currently it is like this:
Most appreciated if you have a solution

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @CateR,

You can escape it with another ' character.

Lets say I am searching for D'Origine. In that case the TermValue needs to be D''Origine.

You can use a replace function for this:

replace(variables('TermValue'), '''', '''''')

The whole URI would be:

_api/v2.1/termStore/groups/@{variables('TermGroupId')}/sets/@{variables('TermSetId')}/terms?$filter=labels/any(a: a/name eq '@{replace(variables('TermValue'), '''', '''''')}')

Was this reply helpful? Yes No
CateR 86 on at

Like (0)

Report

thank you so much!

Was this reply helpful? Yes No
CateR 86 on at

Like (0)

Report
Please help!
another question about the solution provided below:

replace(variables('TermValue'), '''', '''''')

to filter out use of apostrophe's - how can I do this to filter out use of symbols - in particular: &

If my term Store label includes a & symbol the flow fails at this point

Was this reply helpful? Yes No