Unanswered

Trying to extract list from nested JSON arrays

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have the below JSON response from an API call:

{"result":
 [
 {"account":
 {"link":"https://example.com","value":"12345678"}
 },
 {"account":
 {"link":"https://example.com","value":"87654321"}
 }
 ]
}

I'm trying to use power automate to retrieve a list of all the "value"s using a Select function.

I have created an array and added the JSON to it and using the below in the select:

first(variables('test1'))?['result']?[0]?['account']?['value']

However, this creates a 1 item list/ only selects the first value.

Can anyone please help and tell me where I'm going wrong?

Categories:

General topics

All responses (2)

Answers (0)

Sort by

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SamPhillips ,

Check https://www.youtube.com/watch?v=C52brz28poU&list=PLN-cZRQeAiDVQ-6ZWGr43yyTcpu6mUgrR&index=3 for JSON parsing.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, Thanks for the reply.

I have watched the video and whilst educational, can't seem to find my use case in it.

If i use the below i get error: "Array elements can only be selected using an integer index"

first(variables('test1'))?['result']?['account']?['value']