how can i convert json output from excel run script to HTML table and post it in Team chat using power automate online.
Thanks in advance for the kind support.
Raw output:-
{
"statusCode": 200,
"headers": {
"Cache-Control": "no-store, no-cache",
"Transfer-Encoding": "chunked",
"Vary": "Accept-Encoding",
"Access-Control-Expose-Headers": "Version",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"mise-correlation-id": "9585ecb4-f116-4231-a9b8-45502ad78fcb",
"x-ms-workflow-name": "7dbe6680-b12f-457e-9188-01bfe52a3426",
"Version": "3.8",
"x-ms-client-request-id": "8c5245a2-88d4-4dac-b1ec-cd7ce978dae2",
"x-ms-request-id": "8c5245a2-88d4-4dac-b1ec-cd7ce978dae2",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"x-ms-environment-id": "default-5d471751-9675-428d-917b-70f44f9630b0",
"x-ms-tenant-id": "5d471751-9675-428d-917b-70f44f9630b0",
"x-ms-dlp-re": "RunScriptProd|False",
"x-ms-dlp-gu": "-|-",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Tue, 11 Feb 2025 11:48:58 GMT",
"Content-Type": "application/json; charset=utf-8",
"Content-Length": "317"
},
"body": {
"result": "[["Grand Total",448],["N1",58],["N2",51],["N3",41],["N4",40],
"logs": []
}
}
result:-
[["Grand Total",448],["N1",58],["N2",51],["N3",41],["N4",40]]
