Power Platform Community Forum Thread Details

{
  "result": [
    {
      "name": "30909 - Data1",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30909",
          "Test Data3",
          "Address1 Ave",
          "DALLAS",
          "TX",
          "75390"
        ]
      ]
    },
    {
      "name": "30909 - Data2",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30909",
          "Test Data3",
          "Address1 Ave",
          "DALLAS",
          "TX",
          "75390"
        ]
      ]
    },
    {
      "name": "30909 - Data3",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30909",
          "Test Data3",
          "Address1 Ave",
          "DALLAS",
          "TX",
          "75390"
        ]
      ]
    },
    {
      "name": "30911 - Data1",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30911",
          "Test Data4",
          "Test Addres 2 Ave",
          "DALLAS",
          "TX",
          "75225"
        ]
      ]
    },
    {
      "name": "30911 - Data2",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30911",
          "Test Data4",
          "Test Addres 2 Ave",
          "DALLAS",
          "TX",
          "75225"
        ]
      ]
    },
    {
      "name": "30911 - Data3",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30911",
          "Test Data4",
          "Test Addres 2 Ave",
          "DALLAS",
          "TX",
          "75225"
        ]
      ]
    },
    {
      "name": "30912 - Data1",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30912",
          "Test Data5",
          "Test Address 3 Ave",
          "RICHARDSON",
          "TX",
          "75080"
        ]
      ]
    },
    {
      "name": "30912 - Data2",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30912",
          "Test Data5",
          "Test Address 3 Ave",
          "RICHARDSON",
          "TX",
          "75080"
        ]
      ]
    },
    {
      "name": "30912 - Data3",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30912",
          "Test Data5",
          "Test Address 3 Ave",
          "RICHARDSON",
          "TX",
          "75080"
        ]
      ]
    },
    {
      "name": "30915 - Data1",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30915",
          "Test Data7",
          "3501 N  425",
          "IRVING",
          "TX",
          "75062"
        ]
      ]
    },
    {
      "name": "30915 - Data2",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30915",
          "Test Data7",
          "3501 N  425",
          "IRVING",
          "TX",
          "75062"
        ]
      ]
    },
    {
      "name": "30915 - Data3",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30915",
          "Test Data7",
          "3501 N  425",
          "IRVING",
          "TX",
          "75061"
        ]
      ]
    },
    {
      "name": "30953 - Data1",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30953",
          "Test Data6",
          "6121   STE 200",
          "IRVING",
          "TX",
          "75038"
        ]
      ]
    },
    {
      "name": "30953 - Data2",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30953",
          "Test Data6",
          "6121   STE 200",
          "IRVING",
          "TX",
          "75038"
        ]
      ]
    },
    {
      "name": "30953 - Data3",
      "data": [
        [
          "Site Number",
          "Site Name",
          "Address",
          "City",
          "State",
          "Zip"
        ],
        [
          "30953",
          "Test Data6",
          "6121   STE 200",
          "IRVING",
          "TX",
          "75038"
        ]
      ]
    }
  ],
  "logs": [
    "[2024-09-08T19:33:54.8800Z] [\"30909\",\"30911\",\"30912\",\"30953\",\"30915\"]",
    "[2024-09-08T19:33:55.6290Z] [\"30909\",\"30911\",\"30912\",\"30953\",\"30915\"]",
    "[2024-09-08T19:33:56.3320Z] [\"30909\",\"30911\",\"30912\",\"30953\",\"30915\"]"
  ]
}

I am new to Power Automate. With The JSON Data returned from my office Script, I would need to parse through the data, and create Excel Files, along with it's worksheets.

From the example data above

I would have an Excel File created with the name 30909 and Three worksheets related to this key column Worksheets Data1, Data2, Data3.

How would I proceed with the flow. Currently my flow created one file for all the items in the array Eg: 30909 - Data1, 30909- Data2, 30909-Data3 , I need all these to be combined into one excel file.

Please suggest a good approach to accomplish this task.

Categories:

Building flows