Answered

Navigate through JSON file

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

trice602 16,228 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Jcook 7,783 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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”

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It 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 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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

Was this reply helpful? Yes No