Power Platform Community Forum Thread Details

Thought I'd just put another instance of this error out into the world, as I've not been able to find a resolution anywhere.

I have a flow that runs a paginated report, then takes the output (only two columns), creates an Excel file on SharePoint; runs an OfficeScript to create a table from the used range in the file; gets the table from the file, and then bombs on the List rows present in a table step with the following error:

Http request failed: the content was not a valid JSON. Error while parsing JSON: 'After parsing a value an unexpected character was encountered: @. Path 'message', line 1, position 71.'

Here's the output from the Get tables step immediately preceding the "List rows..." step:

{
    "statusCode": 200,
    "headers": {
        "Cache-Control": "no-store, no-cache",
        "Transfer-Encoding": "chunked",
        "Vary": "Accept-Encoding",
        "Strict-Transport-Security": "max-age=31536000",
        "Request-Id": "b3341ebe-fceb-4834-9cd6-bdb50fd8263a",
        "client-request-id": "b3341ebe-fceb-4834-9cd6-bdb50fd8263a",
        "x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"East US 2\",\"Slice\":\"E\",\"Ring\":\"5\",\"ScaleUnit\":\"001\",\"RoleInstance\":\"BN1PEPF000076D7\"}}",
        "OData-Version": "4.0",
        "x-ms-request-id": "b4aec949-84d1-438e-8942-b4fcf627548b;b3341ebe-fceb-4834-9cd6-bdb50fd8263a",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "x-ms-environment-id": "OBFUSCATED",
        "x-ms-tenant-id": "OBFUSCATED",
        "x-ms-dlp-re": "-|-|-",
        "x-ms-dlp-gu": "-|-",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "false",
        "Date": "Fri, 06 Dec 2024 15:55:32 GMT",
        "Content-Type": "application/json; odata.metadata=minimal; odata.streaming=true; IEEE754Compatible=false; charset=utf-8",
        "Content-Length": "696"
    },
    "body": {
        "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#drives('b%21gc5lWKs84KAHLPHWHaIf0pKd_VsCtc5FkzuhZne99ntKNS71sbxHRbMBNUADEZca')/items('01MGIIJ3EOSM4FHRbMBNFZDVKAHLPHWIK4')/workbook/tables",
        "value": [
            {
                "@odata.id": "/drives('b%21gc5lWKs84EW3LeS7HaIf0pKd_VsCtc5FkzuhZne99ntKNS71sbxHRbMBNUADEZca')/items('01MGII7B2FBAC987REYBFZDVKAHLPHWIK4')/workbook/tables(%27%7B2FBAC987-A7DC-4B67-82ED-36EEDF4B7331%7D%27)",
                "showFilterButton": true,
                "id": "{2FCAB736-A7DC-4B67-82ED-36EEDKAHLPHW}",
                "highlightLastColumn": false,
                "highlightFirstColumn": false,
                "legacyId": "1",
                "style": "TableStyleMedium9",
                "name": "DerivedTable",
                "showBandedColumns": false,
                "showBandedRows": true,
                "showHeaders": true,
                "showTotals": false
            }
        ]
    }
}

Categories:

Building flows

Example JSON Schema for Parse JSON Step

Here’s an example of a JSON schema you might define for the "Parse JSON" step based on the output you provided:

{
"type": "object",
"properties": {
"statusCode": {
"type": "integer"
},
"headers": {
"type": "object",
"properties": {
"Cache-Control": {
"type": "string"
},
"Transfer-Encoding": {
"type": "string"
},
"Vary": {
"type": "string"
},
"Strict-Transport-Security": {
"type": "string"
},
"Request-Id": {
"type": "string"
},
"client-request-id": {
"type": "string"
},
"x-ms-ags-diagnostic": {
"type": "string"
},
"OData-Version": {
"type": "string"
},
"x-ms-request-id": {
"type": "string"
},
"X-Content-Type-Options": {
"type": "string"
},
"X-Frame-Options": {
"type": "string"
},
"x-ms-environment-id": {
"type": "string"
},
"x-ms-tenant-id": {
"type": "string"
},
"x-ms-dlp-re": {
"type": "string"
},
"x-ms-dlp-gu": {
"type": "string"
},
"Timing-Allow-Origin": {
"type": "string"
},
"x-ms-apihub-cached-response": {
"type": "string"
},
"x-ms-apihub-obo": {
"type": "string"
},
"Date": {
"type": "string"
},
"Content-Type": {
"type": "string"
},
"Content-Length": {
"type": "string"
}
}
},
"body": {
"type": "object",
"properties": {
"@odata.context": {
"type": "string"
},
"value": {
"type": "array",
"items": {
"type": "object",
"properties": {
"@odata.id": {
"type": "string"
},
"showFilterButton": {
"type": "boolean"
},
"id": {
"type": "string"
},
"highlightLastColumn": {
"type": "boolean"
},
"highlightFirstColumn": {
"type": "boolean"
},
"legacyId": {
"type": "string"
},
"style": {
"type": "string"
},
"name": {
"type": "string"
},
"showBandedColumns": {
"type": "boolean"
},
"showBandedRows": {
"type": "boolean"
},
"showHeaders": {
"type": "boolean"
},
"showTotals": {
"type": "boolean"
}
},
"required": [
"@odata.id",
"id",
"name"
]
}
}
}
}
}
}