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?
Hello, @kwaxe!
Could you post a picture of your flow (right where the error pops up)?
Thanks in advance,
Rodrigo
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.
Will you be helping with this issue?