Get an item from a JSON response within an object

(0) Share

Report

Posted on by sausage_dog

Hi,

I have an action in Power Automate which returns, in JSON, the following (see image). I am then using this 'value' in an Apply to Each. To get the TopItemNumber via an expression in the loop using a Compose action, I use:

items('Apply_to_each')?['TopItemNumber']}

I want an expression which gets "Level_2" which is within "TheHierarchy" object. How can I do this via an expression in the same compose action as the one above?

Thanks

I have the same question (0)

All responses (1)

Answers (0)

Andrew_J 1,962 Moderator on at

Like (0)

Report

Re: Get an item from a JSON response within an object

@sausage_dog

You need to look at drilling down from "TheHierarchy" to "Level_2". So somehere in your flow use:

outputs('Get_items')?['body']?['value']?['TheHierarchy']?['Level_2']

Or see below as refereance for the above:

https://tomriha.com/how-to-get-a-specific-value-from-a-json-object-in-power-automate/

That sould get what you need.

Andrew

Was this reply helpful? Yes No