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?
Solved! Go to Solution.
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']
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']
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!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
28 | |
24 | |
17 | |
10 |
User | Count |
---|---|
66 | |
58 | |
29 | |
27 | |
25 |