Power Platform Community Forum Thread Details

JSON storing headers and data in separate lists, how to write them to Excel table?

Hi,

I am trying to write JSON output to an Excel table. However, instead of key-value pair, the JSON has headers and data in separate lists ("fields" has header and it's properties, and "data" is just data), as showing below. Do you know a way to combine the "fields" (more specific, "label" from "fields") and "data" to a dictionary? Or how to pass un-named data to table using "Add a row into a table" action?

Thank you!

"fields": [
            {
                "name": "postedDatetime",
                "label": "Posted",
                "cardinality": 1,
                "dataType": "DATETIME",
                "searchable": true,
                "sortable": true,
                "hasRange": true
            },
            {
                "name": "deliveryDate",
                "label": "Delivery Date",
                "cardinality": 2,
                "dataType": "DATE",
                "searchable": true,
                "sortable": true,
                "hasRange": true
            },...]
 

"data": [
            [
                "2024-08-06T12:30:00",
                "2024-08-13",
                "1:00",
                15393,
                2034.09,
                7067.4302,
                1869.28,
                18442.6992,
                10719.9004,
                4612.2002,
                1610.14,
                61748.74,
                "E",
                true,
                false
            ],
            [
                "2024-08-06T12:30:00",
                "2024-08-13",
                "10:00",
                16217.7002,
                2178.3999,
                7131.7998,
                1912.8199,
                18689.0996,
                10377.9004,
                4660.4199,
                1626.77,
                62794.9097,
                "E",
                true,
                false
            ],...]