Hello All,
I'm having trouble with a flow triggered by an MS form submission.
The form is submitted properly and I see responses both in the excel file and on the form itself, but the flow fails at the "get response details" action.
Below is the error message:
Error reading JArray from JsonReader. Path '', line 0, position 0.
at Newtonsoft.Json.Linq.JArray.Load(JsonReader reader, JsonLoadSettings settings)
at Newtonsoft.Json.Linq.JArray.Parse(String json, JsonLoadSettings settings)
{
"statusCode": 500,
"headers": {
"Access-Control-Allow-Methods": "GET, PUT, PATCH, DELETE, POST",
"Access-Control-Allow-Origin": "*",
"Access-Control-Max-Age": "3600",
"Access-Control-Expose-Headers": "*",
"Date": "Mon, 16 Jan 2023 23:39:20 GMT",
"Content-Length": "504",
"Content-Type": "application/json"
},
"body": {
"error": {
"code": 500,
"message": "Error reading JArray from JsonReader. Path '', line 0, position 0.\r\n at Newtonsoft.Json.Linq.JArray.Load(JsonReader reader, JsonLoadSettings settings)\r\n at Newtonsoft.Json.Linq.JArray.Parse(String json, JsonLoadSettings settings)",
"source": "flow-apim-msmanaged-na-eastus2-01.azure-apim.net",
"path": "choose[2]\\when[1]\\choose[1]\\when[1]",
"policyId": "",
"clientRequestId": "bd8f79da-a3ef-477c-97e9-4d5a7595e53f"
}
}
}
Does anyone know why this is happening and/ or has a workaround to this? Is there any way I can retrieve the submission data from the form without using the "get response details" since I'm having trouble with it?
Thank you!
