Showing results for 
Search instead for 
Did you mean: 
New Member

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

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.



"code": 400,

"source": "",

"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,


New Member

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.






Not applicable

Will you be helping with this issue?  

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,041)