Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Navigate through JSON file

(1) ShareShare
ReportReport
Posted on by

Hi,

 

I am trying to extract one element (an ID) from a JSON file I got from an API response in order to set a condition.

I tried the object method (body['data']...) but it does not work. Indeed, when I check the ID manually, it is the correct ID so that the condition returns True, but whenever I test my flow, it always returns False.

 

I also asked the AI assistance and it suggested to write body?['data']?... and it does not work either, it concatenates the response body with the string "?['data]?...".

 

I checked the forum and it is said that I can create a "Compose" action, but I don't seem to have it.

 

Do you have any advice to navigate through the JSON file ?

 

Thanks!

  • Community Power Platform Member Profile Picture
    on at
    Re: Navigate through JSON file

    Hi,

     

    Thank you for your reply, I tried it and it's much better now !

  • Community Power Platform Member Profile Picture
    on at
    Re: Navigate through JSON file

    It does not detect anything else than Outputs and body, that is why I tried to writeIt does not detect anything else than Outputs and body, that is why I tried to writeThe "Parse JSON" was already there when I had the problemThe "Parse JSON" was already there when I had the problem

    Hi,

     

    Thank you for replying, however as you can see on the screrenshots, I already tried the Parse JSON action, yet Power Automate doesn't suggest any ID as dynamic content.

  • Verified answer
    Jcook Profile Picture
    7,770 Most Valuable Professional on at
    Re: Navigate through JSON file

    Hi @Anonymous 

     

    You seem to be typing in the expression as text. Rather than an actual expression.

    You need to put the whole expression inside the expression box. You will know it’s right if you have your whole expression inside the “Dynamic content box”

    IMG_5838.jpeg

     

  • trice602 Profile Picture
    13,760 Super User 2025 Season 1 on at
    Re: Navigate through JSON file

    Hi @Anonymous ,

     

    Please try "Parse JSON" action and paste in your sample schema.  Then you will see the ID is now available as dynamic content downstream.

     

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,635 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow