Answered

Parse Json Action

(0) Share

Report

Posted on by CU23010316-0

If a run a query to a Power BI dataset, that returns json format with many column rows, when creating a loop I want to get just 1 column values in the form of ["result1", "result2"] etc. But the only workaround that makes it to work is creating an empty array then with an apply to each action store the values I want in that Initialize a variable action. Is there a direct way to get the list as I want it?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

NsL Coder 475 Super User 2025 Season 2 on at

Like (0)

Report

this can be easily done with the Select data action.

You can select ONE property of an object returned as an array.

Was this reply helpful? Yes No
Verified answer

R_Nilakshan 19 on at

Like (0)

Report

If your JSON is in the below format

[

{

"Code": "C-63ae2aa9",

"Type": "Corporate",

"businessUnit": "DST"

},

{

"Code": "C-63ae2aa9",

"Type": "Corporate",

"businessUnit": "DST"

},

{

"Code": "C-63ae2aa9",

"Type": "Corporate",

"businessUnit": "DST"

}

]

You can simply select the Dynamic content (Column) you want, that'll create a loop and execute

Was this reply helpful? Yes No