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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.