SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-3116823%22%20slang%3D%22en-US%22%3ECreating%20a%20Sharepoint%20Item%20%22message%22%3A%20%22The%20response%20is%20not%20in%20a%20JSON%20format.%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3116823%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20run%20into%20an%20error%20message%20while%20trying%20to%20create%20a%20SharePoint%20list%20item%20in%20Power%20Automate.%26nbsp%3B%20The%20error%20message%20in%20full%20is%20as%20follows%3A%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CDIV%3E%3CDIV%3E%3CSTRONG%3E%3CEM%3E%26nbsp%3B%22message%22%3A%26nbsp%3B%22The%26nbsp%3Bresponse%26nbsp%3Bis%26nbsp%3Bnot%26nbsp%3Bin%26nbsp%3Ba%26nbsp%3BJSON%26nbsp%3Bformat.%22%2C%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%3E%3CSTRONG%3E%3CEM%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%22innerError%22%3A%26nbsp%3B%22404%26nbsp%3BFILE%26nbsp%3BNOT%26nbsp%3BFOUND%22%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%3CSTRONG%3E%3CEM%3E%26nbsp%3B%20%26nbsp%3B%3C%2FEM%3E%3C%2FSTRONG%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3EHere%20is%20my%20screen%20shot%20of%20my%20flow%20for%20further%20context%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Flow%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345297i8C53468510975961%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Program.png%22%20alt%3D%22Flow%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFlow%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20similar%20flows%20before%20using%20variables%20without%20any%20issues%20and%20I%20cannot%20figure%20out%20the%20error.%26nbsp%3B%20%26nbsp%3BAs%20a%20way%20of%20trouble%20shooting%2C%20I%20took%20a%20look%20at%20my%20code%20for%20my%20inputs%20and%20it%20looks%20as%20follows%2C%20Keep%20in%20mind%20this%20is%20my%20failed%20code.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%7B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22host%22%3A%20%7B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22connectionReferenceName%22%3A%20%22shared_sharepointonline%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22operationId%22%3A%20%22PostItem%22%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%7D%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22parameters%22%3A%20%7B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22dataset%22%3A%20%22%3CA%20href%3D%22https%3A%2F%2Fcollinsclothiers365.sharepoint.com%2Fsites%2FLondon%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fcollinsclothiers365.sharepoint.com%2Fsites%2FLondon%20%3C%2FA%3E%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22table%22%3A%20%22ff218924-3d4c-469f-8c1d-25e4042ca13f%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22item%22%3A%20%7B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22Title%22%3A%20%2227%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22Store%22%3A%20%22London%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22CustomerFirstName%22%3A%20%22Test%20Test%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22CustomerPhoneNumber%22%3A%201234567890%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22CustomerEmail%22%3A%20%22Email%20address%20removed%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22DateRequired%22%3A%20%222022-03-27%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22LinktoFile%22%3A%20%22%3CA%20href%3D%22https%3A%2F%2Fcollinsclothiers365.sharepoint.com%2F%3Au%3A%2Fs%2FMicrosoftFormSubmissions%2FETQMNYvihvhBtOMH6cfiHUEBtzBfN88U-_Mle3-bVFspyA%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fcollinsclothiers365.sharepoint.com%2F%3Au%3A%2Fs%2FMicrosoftFormSubmissions%2FETQMNYvihvhBtOMH6cfiHUEBtzBfN88U-_Mle3-bVFspyA%3C%2FA%3E%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22SubmissionDate%22%3A%20%222022-02-02T15%3A32%3A59Z%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22OrderStatus%22%3A%20%7B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22Value%22%3A%20%22ORDERED%22%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%7D%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%7D%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%7D%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%7D%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20trial%20run%2C%20I%20entered%20my%20values%20manually%20into%20creating%20a%20list%20item%20without%20using%20the%20predefined%20compose%20values.%26nbsp%3B%20Primarily%20to%20see%20what%20its%20code%20looked%20like.%26nbsp%3B%20It%20works%20fine%20without%20passing%20in%20the%20variables.%26nbsp%3B%20%26nbsp%3BThe%20successful%20code%26nbsp%3B%20looks%20like%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%7B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22host%22%3A%20%7B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22connectionReferenceName%22%3A%20%22shared_sharepointonline%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22operationId%22%3A%20%22PostItem%22%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%7D%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22parameters%22%3A%20%7B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22dataset%22%3A%20%22%3CA%20href%3D%22https%3A%2F%2Fcollinsclothiers365.sharepoint.com%2Fsites%2FLondon%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fcollinsclothiers365.sharepoint.com%2Fsites%2FLondon%3C%2FA%3E%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22table%22%3A%20%22ff218924-3d4c-469f-8c1d-25e4042ca13f%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22item%2FTitle%22%3A%20%2227%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22item%2FStore%22%3A%20%22London%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22item%2FCustomerFirstName%22%3A%20%22Test%20Test%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22item%2FCustomerPhoneNumber%22%3A%201234567890%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22item%2FCustomerEmail%22%3A%20%22Email%20address%20removed%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22item%2FOrderStatus%2FValue%22%3A%20%22ORDERED%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22item%2FDateRequired%22%3A%20%222022-03-27%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22item%2FLinktoFile%22%3A%20%22%3CA%20href%3D%22https%3A%2F%2Fcollinsclothiers365.sharepoint.com%2F%3Au%3A%2Fs%2FMicrosoftFormSubmissions%2FETQMNYvihvhBtOMH6cfiHUEBtzBfN88U-_Mle3-bVFspyA%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fcollinsclothiers365.sharepoint.com%2F%3Au%3A%2Fs%2FMicrosoftFormSubmissions%2FETQMNYvihvhBtOMH6cfiHUEBtzBfN88U-_Mle3-bVFspyA%3C%2FA%3E%22%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%22item%2FSubmissionDate%22%3A%20%222022-02-02T15%3A32%3A59Z%22%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%7D%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%7D%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20really%20see%20a%20difference%20in%20how%20it%20is%20laid%20out.%20I%20have%20spent%20a%20few%20days%20now%20looking%20over%20it%20and%20reviewing%20my%20JSON%20without%20really%20getting%20anywhere%20I'm%20not%20really%20sure%20what%20to%20check%20next.%26nbsp%3B%20I%20spent%20most%20of%20my%20time%20looking%20for%20the%20JSON%20code%20as%20it%20related%20to%20my%20error%20message%3CEM%3E%26nbsp%3B%22The%20response%20is%20not%20in%20a%20JSON%20format.%22%26nbsp%3B%3C%2FEM%3EHowever%2C%20I%20have%20spent%20very%20limited%20time%20looking%20into%20the%20other%20part%20of%20my%20error%20which%20read%26nbsp%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22innerError%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22404%26nbsp%3BFILE%26nbsp%3BNOT%26nbsp%3BFOUND%22.%26nbsp%3B%20I'm%20starting%20to%20wonder%20if%20this%20is%20more%20the%20problem%20and%20not%20the%20JSON%2C%20but%20I%20really%20don't%20know%20what%20it%20is%20referring%20to%20or%20how%20to%20trouble%20shoot.%26nbsp%3B%20Any%20tips%2Fideas%20would%20be%20great.%26nbsp%3B%20Thanks%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3116823%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3119507%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20Sharepoint%20Item%20%22message%22%3A%20%22The%20response%20is%20not%20in%20a%20JSON%20format.%26amp%3Bquot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3119507%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1205619%22%20target%3D%22_blank%22%3E%40pwintert%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20difference%20I%20can%20see%20between%20the%20two%20datasets%20that%20you%20have%20pasted%20in%20the%20post%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThe%20URL%20in%20the%20%22dataset%22%20for%20the%20failed%20dataset%20is%3A%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fcollinsclothiers365.sharepoint.com%2Fsites%2FLondon%25E2%2580%258B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcollinsclothiers365.sharepoint.com%2Fsites%2FLondon%25E2%2580%258B%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ekarim_0-1644016494331.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345436iF083CAC807198C2E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ekarim_0-1644016494331.png%22%20alt%3D%22ekarim_0-1644016494331.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThere%20seems%20to%20be%20a%20fullstop%20or%20period%20character%20at%20the%20end%20of%20the%20URL.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EWhereas%20the%20working%20dataset%20is%3A%3C%2FSTRONG%3E%3CBR%20%2F%3E%22%3CA%20href%3D%22https%3A%2F%2Fcollinsclothiers365.sharepoint.com%2Fsites%2FLondon%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcollinsclothiers365.sharepoint.com%2Fsites%2FLondon%3C%2FA%3E%22%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ekarim_1-1644016625346.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F345438iD07C5DC6547F0A53%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ekarim_1-1644016625346.png%22%20alt%3D%22ekarim_1-1644016625346.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEllis%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.",
    "innerError": "404 FILE NOT FOUND"
 

    Here is my screen shot of my flow for further context:

FlowFlow

 

I have created similar flows before using variables without any issues and I cannot figure out the error.   As a way of trouble shooting, I took a look at my code for my inputs and it looks as follows, Keep in mind this is my failed code. 

 

{
"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "PostItem"
},
"parameters": {
"dataset": "https://collinsclothiers365.sharepoint.com/sites/London​",
"table": "ff218924-3d4c-469f-8c1d-25e4042ca13f",
"item": {
"Title": "27",
"Store": "London",
"CustomerFirstName": "Test Test",
"CustomerPhoneNumber": 1234567890,
"CustomerEmail": "Email address removed",
"DateRequired": "2022-03-27",
"LinktoFile": "https://collinsclothiers365.sharepoint.com/:u:/s/MicrosoftFormSubmissions/ETQMNYvihvhBtOMH6cfiHUEBtz...",
"SubmissionDate": "2022-02-02T15:32:59Z",
"OrderStatus": {
"Value": "ORDERED"
}
}
}
}

 

As a trial run, I entered my values manually into creating a list item without using the predefined compose values.  Primarily to see what its code looked like.  It works fine without passing in the variables.   The successful code  looks like the following:

 

{
"host": {
"connectionReferenceName": "shared_sharepointonline",
"operationId": "PostItem"
},
"parameters": {
"dataset": "https://collinsclothiers365.sharepoint.com/sites/London",
"table": "ff218924-3d4c-469f-8c1d-25e4042ca13f",
"item/Title": "27",
"item/Store": "London",
"item/CustomerFirstName": "Test Test",
"item/CustomerPhoneNumber": 1234567890,
"item/CustomerEmail": "Email address removed",
"item/OrderStatus/Value": "ORDERED",
"item/DateRequired": "2022-03-27",
"item/LinktoFile": "https://collinsclothiers365.sharepoint.com/:u:/s/MicrosoftFormSubmissions/ETQMNYvihvhBtOMH6cfiHUEBtz...",
"item/SubmissionDate": "2022-02-02T15:32:59Z"
}
}

 

I cannot really see a difference in how it is laid out. I have spent a few days now looking over it and reviewing my JSON without really getting anywhere I'm not really sure what to check next.  I spent most of my time looking for the JSON code as it related to my error message "The response is not in a JSON format." However, I have spent very limited time looking into the other part of my error which read  "innerError""404 FILE NOT FOUND".  I'm starting to wonder if this is more the problem and not the JSON, but I really don't know what it is referring to or how to trouble shoot.  Any tips/ideas would be great.  Thanks 

1 Reply
best response confirmed by pwintert (New Contributor)
Solution

@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

ekarim_0-1644016494331.png

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"

ekarim_1-1644016625346.png

 

Hope this helps.

 

Ellis