cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kwaxe
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.

 

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

3 REPLIES 3
rrovira
Microsoft
Microsoft

Hello, @kwaxe!

 

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

 

Thanks in advance,

Rodrigo

kwaxe
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.

p2.pngp1.png

 

 

 

 

Anonymous
Not applicable

Will you be helping with this issue?  

Helpful resources

Announcements
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)