Power Platform Community Forum Thread Details

Hi all,

I am fairly new to Power Automate and hoping someone can help with this problem that has been driving me nuts.

I have a JSON object that I would like to turn into a CSV table. I have included a simplified exampled of the JSON structure but the final JSON could have hundreds of thousands of rows of data and 50 + columns.

As you can see from the JSON below, the 'headers' key is an array of values that are my column headers.

The data value is an array of arrays. Each child array represents a single row of data:

{

"header": [

"'Test Table'[Column_1]",

"'Test Table'[Column_2]",

"'Test Table'[Column_3]"

]

"data": [

[

"Foo",

"Bar"

[

"Hello",

"World"

]

}

So, my aim is to transform the above into the following table:

Column_1	Column_2	Column_3
1	Foo	Bar
2	Hello	Worlds

As I said, the actual data I will feed into this flow could be hundreds of thousands of rows long and 50+ columns wide so I am trying to avoid any solution that requires me to hard code any values or any name mappings (as a select data operation does when I pass in anything that isn't an array of objects).

I'd also ideally like to avoid any looping via an apply to each (although this is based on my admittedly limited understanding of the speed or Power Automate).

Any help is massively appreciated.

Thank you

Categories:

Building flows