
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
SD
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