Answered

how to get Value values from JSON

(0) Share

Report

Posted on by Palucci12

Hello,

I have some like these JSON :

 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 4,
 "Value": "10000000"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 22,
 "Value": "20000000"
 }
]

How to extract only Value using Compose, there can be more than just 2 IDs. I tried that but it doesn't work, I got empty input

body('Compose')?['Value']

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

David_MA 14,614 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If the above is what your JSON data looks like, insert a Parse JSON action into your flow. Then use the above as the sample data to create the scheme. You will then be able to get the values from the dynamic content picker out of the Parse JSON action.

Was this reply helpful? Yes No
Palucci12 on at

Like (0)

Report
Copy link

Link copied!

thank for your suggestion, but how should look JSON schema for my example ?

Was this reply helpful? Yes No
Verified answer

David_MA 14,614 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You will first need to make sure your data is a valid array. Then do this:

I don't know where your JSON is coming from. but first pass it through a Compose action and don't add the other actions until you run the flow one time. Then go to a successful run of the flow and copy the output from the initial Compose action.

Next add the Parse JSON action and pass it the data from the Compose action or whatever your real source of the JSON array is. You can then process each item in an Apply to each with the output of the Parse JSON data action.

If everything is configured correctly and your JSON is valid, you will get:

Was this reply helpful? Yes No
Palucci12 on at

Like (0)

Report
Copy link

Link copied!

However, then I have PARSE JSON, where I take the output of this COMPOSE, but I don't know how to set Schema so that in Compose21 it downloads only Value, in this case I will have two Values . Now i got a error:

Here is my JSON where it comes from:
I don't know how to set the Schema so that it creates one JSON for me, so that I can choose a Value, only Value can be several depending on how many objects are in a given row

Was this reply helpful? Yes No