Answered

retrieve data from ParseJSON output

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I'm making a chatbot using Power Virtual Agents, I'm at the step parsing JSON data to return to the PVA chatbot. This happens regularly.Below is the output from the Parse JSON ( first picture).

When I try to choose "amount" a warning will pop up ( second picture), I believe because it's in the array.

I need help retrieving those data so I can use them to display on chatbot.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Ellis Karim 11,823 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
You can use an expression to reference the amount. Amount is a property of the cashBalance array, and you need to reference the first item of the array. The array only has one item or element. The first item of the array is always number 0 (zero). For example:

outputs('Compose')?['cashBalance']?[0]?['amount']
Example runtime output:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,823 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
You dont need to use Parse JSON reference the amount property. But if you wish to get the Amount from the Parse JSON action, you can use the following expression:

body('Parse_JSON')?['cashBalance']?[0]?['amount']

Note that both expressions are the same, they just differ on where the expression is getting its input from:

outputs('Compose')?['cashBalance']?[0]?['amount'] body('Parse_JSON')?['cashBalance']?[0]?['amount']

Ellis

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

Like (0)

Report
Copy link

Link copied!

Thank you, it works

Was this reply helpful? Yes No