Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

The response is not in a JSON format - Working with SharePoint List and Flow

I am having a list which has 4800 items. I am iterating a flow on each item to process. While flow is in running mode, it always fails for a random ID with the reason "The response is not in a JSON format.".


Initially I thought of some data problem, but when I ran flow multiple times then I realized that the same error is occurring for different id in different runs. For example,


  1. For ID 3962, flow ran successfully.
  2. For second run, for ID 3962 thrown error
  3. For third run, same error occurred for ID 4528 and for ID 3962, the flow ran successfully.

So any one have idea what may causing an issue? Please find below snapshot.




Actual Error message:



  "error": {
    "code": 502,
    "source": "",
    "clientRequestId": "9c1eb846-a4fd-4891-946d-0a2bac080285",
    "message": "The response is not in a JSON format.",
    "innerError": "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\"\"\">\r\n<HTML><HEAD><TITLE>Service Unavailable</TITLE>\r\n<META HTTP-EQUIV=\"Content-Type\" Content=\"text/html; charset=us-ascii\"></HEAD>\r\n<BODY><h2>Service Unavailable</h2>\r\n<hr><p>HTTP Error 503. The service is unavailable.</p>\r\n</BODY></HTML>\r\n"



Any help or suggestion is most welcome

Community Support Team
Community Support Team

Re: The response is not in a JSON format - Working with SharePoint List and Flow

Hi @aakashdmorya,


The error code 500 or 502 appears means the failure is temporary or transient. It’s possible the server is overloaded or there are network issues between the two servers. It’s also possible there’s an improperly configured firewall or even a coding error.

Please click or tap Resubmit to try the flow again and let me know if the issue still exists.


Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Helpful resources


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,155)