web

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

Power Platform CommunityForums Power Automate - Building Flows Get data from JSON

Power Automate - Building Flows

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?

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Pstork1 68,324 Most Valuable Professional on at

Like (1)

Report
Re: Get data from JSON

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

Was this reply helpful? Yes No
GuttormG 23 on at

Like (0)

Report

Re: Get data from JSON

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!

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 560 Super User 2025 Season 2

#2

Tomac 347 Moderator

#3

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans