Error Code: 400, The Response is not in JSON format

[kwaxe]

I have a workflow that takes in a new (.xlsx) that we manually upload to the server everyday that then updates an existing sharepoint list of items. Recently there has been a failure every other day that I cannot find a reason as to why it fails. This fail happens when trying to update an item that already exists in a list.

"error": 

"code": 400,

"source": "flow-apim-msmanaged-na-eastus2-01.azure-apim.net",

"clientRequestId": "xxx-xxx-xxx-xxx-xxx",

"message": "The response is not in a JSON format.",

"innerError":"The server encountered an error processing the request. See server logs for more details"

The way I've been able to resolve this is by resetting the values in both [When a file is created or modified(properties only)] and [Get tables] actions. 

How can I go about running the flow without having a failure every other day?

[rrovira]

Hello, @kwaxe!

Could you post a picture of your flow (right where the error pops up)?

Thanks in advance,

Rodrigo

[kwaxe]

Hey @rrovira , I have posted the images below, I am not sure which specific parts of the flow you need to see, I will mention there is some sensitive data so I cannot show the entire flow with the variables without blocking sensitive data. Let me know if there are any specific parts you need to see and I will post it.

[Anonymous]

Will you be helping with this issue?