Forum Discussion

pwintert's avatar
pwintert
Copper Contributor
Feb 04, 2022
Solved

Creating a Sharepoint Item "message": "The response is not in a JSON format."

I have run into an error message while trying to create a SharePoint list item in Power Automate.  The error message in full is as follows:     "message": "The response is not in a JSON format.", ...
Microsoft Flow
sharepoint
  • ekarim's avatar
    ekarim
    Feb 04, 2022

    pwintert 

    The only difference I can see between the two datasets you have pasted in the post is:

     

    The URL in the "dataset" for the failed dataset is:
    https://collinsclothiers365.sharepoint.com/sites/London%E2%80%8B

    There seems to be a fullstop or period character at the end of the URL.

     

    Whereas the working dataset is:
    "https://collinsclothiers365.sharepoint.com/sites/London"

     

    Hope this helps.

     

    Ellis

ekarim's avatar
ekarim
Brass Contributor
Feb 04, 2022

pwintert 

The only difference I can see between the two datasets you have pasted in the post is:

 

The URL in the "dataset" for the failed dataset is:
https://collinsclothiers365.sharepoint.com/sites/London%E2%80%8B

There seems to be a fullstop or period character at the end of the URL.

 

Whereas the working dataset is:
"https://collinsclothiers365.sharepoint.com/sites/London"

 

Hope this helps.

 

Ellis

Resources