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.
"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?
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.