web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get data from JSON

Power Automate

Answered

Get data from JSON

(0) Share

Report

Report

Posted on by GuttormG

23

I have a flow that gets new posts from Teams. I use triggerBody() to extract the data, and pase this to JSON. So far so, good 🙂
Now I want to get only a few values from this JSON. How do I get the values marked in this JSON?

I have tried things like outputs('Parse_JSON')?['sections']?['facts'] in several different ways, but either the flow fails, or I get a null-value.

Any suggestions?

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Pstork1 69,665 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Since Sections and facts are both arrays you'll need to add an index number to reach them directly. Something like this

outputs('Parse_JSON')?['sections'][0]?['facts'][0]?['value']
GuttormG 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Ahh, thank you very much! Got almost crazy of all the brackets, question marks and index numbers I couldn't figure out.
Also, I had to use body() instead of outputs(). Don't know why, but it works now!

Join the conversation