Showing results for 
Search instead for 
Did you mean: 

401 SharePoint - The response is not in a JSON format


A user received the following error - see below - when trying to grab data from SharePoint. 

All days before things worked fine but now it failed. 

Why is that?

Best regards, 



error": {

   "code": 401,

   "source": "",

   "clientRequestId": "ef01ca07-ac09-4e47-8e84-3b5127116e42",

   "message": "The response is not in a JSON format.",

   "innerError": "No connection could be made because the target machine actively refused it"

Community Support
Community Support


Hi @lreinhard7 ,


What is the current test result on your side, I have tested it on my side, and the SharePoint connector related actions can be used normally.

It seems that your data comes from an On-prem data source, please check if the status of the connection is successfully connected.

Alternatively, you could try to update or recreate the connection and see if a similar error still exists.


Best Regards,

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


We tested once again over the last two days but could not replicate the issue. 

I have no clue what happened but now the problem seems gone. 

The SharePoint is actually not an on-prem but a cloud hosted one. 

Will continue to watch whether the issue comes up again .

For the moment things seem to be fixed though. 

Many thanks and best regards, 


Regular Visitor


I actually have the same error NOW. But only if a collegue is triggering the flow.



Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (3,713)