web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get an item from a JSO...
Power Automate
Unanswered

Get an item from a JSON response within an object

(0) ShareShare
ReportReport
Posted on by 63

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']}

 

 

sausage_dog_0-1711309259455.png

 

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

 

Categories:
I have the same question (0)
  • Andrew_J Profile Picture
    1,962 Moderator on at

    @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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard