cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AK123
Helper I
Helper I

Error 404 when writing to sharepoint

I am writing something to file and then to sharepoint. Writing to file is ok, however unable to write to Sharepoint

Input seems to be correct read. Which field is causing the error.

 

Input

AK123_0-1646649905795.png

 

Error:

{
    "statusCode"400,
    "headers": {
        "Vary""Origin",
        "X-SharePointHealthScore""3",
        "X-MS-SPConnector""1",
        "X-SP-SERVERSTATE""ReadOnly=0",
        "DATASERVICEVERSION""3.0",
        "SPClientServiceRequestDuration""31",
        "SPRequestGuid""db58da2f-2a01-4202-bc5c-f4af9e2a0d89",
        "request-id""db58da2f-2a01-4202-bc5c-f4af9e2a0d89",
        "MS-CV""L9pY2wEqAkK8XPSvnioNiQ.0",
        "Strict-Transport-Security""max-age=31536000",
        "X-FRAME-OPTIONS""SAMEORIGIN",
        "Content-Security-Policy""frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com;",
        "MicrosoftSharePointTeamServices""16.0.0.22223",
        "X-Content-Type-Options""nosniff",
        "X-MS-InvokeApp""1; RequireReadOnly",
        "Timing-Allow-Origin""*",
        "x-ms-apihub-cached-response""false",
        "x-ms-apihub-obo""true",
        "Cache-Control""max-age=0, private",
        "Date""Mon, 07 Mar 2022 10:35:11 GMT",
        "P3P""CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
        "X-AspNet-Version""4.0.30319",
        "X-Powered-By""ASP.NET",
        "Content-Length""195",
        "Content-Type""application/json",
        "Expires""Sun, 20 Feb 2022 10:35:12 GMT",
        "Last-Modified""Mon, 07 Mar 2022 10:35:12 GMT"
    },
    "body": {
        "status"400,
        "message""Input string was not in a correct format.\r\nclientRequestId: db58da2f-2a01-4202-bc5c-f4af9e2a0d89\r\nserviceRequestId: db58da2f-2a01-4202-bc5c-f4af9e2a0d89"
    }
}
 
Flow
AK123_2-1646650141764.png

 

 
Sharepoint fields 
AK123_1-1646650106696.png

 

 
2 REPLIES 2
ScottShearer
Super User
Super User

@AK123 

I suspect that the issue is with the Submission time column entry.  If I cam correct, use a formatDateTime() expression to format the date/time in the same manner as you see for the Approver Response date.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
AK123
Helper I
Helper I

Thanks you are correct 'Submission time' is the field.. I Get this error now

I updated it to  formatDateTime (body('Get_response_details')?['submitDate'])

 

Error I get now is 

Invalid cast from 'DateTime' to 'Double'.
clientRequestId: 9f6a9ceb-b52f-4248-b6b2-ced4c3811065
serviceRequestId: 9f6a9ceb-b52f-4248-b6b2-ced4c3811065

 

 

{
  "Title""Khanna, Anmol",
  "field_1""2022-03-09T11:05:01Z",
  "field_2"null,
  "field_3""2022-03-09T11:04:44.0000000",
  "field_4""Test",
  "field_5""2022-03-10",
  "field_6""Yes - Visit is requested for >3days",
  "field_7""Test",
  "field_8""A1234",
  "field_9""Nominated parent/guardian of an admitted child (under the age of 18 years) ",
  "field_10""RPH Inpatient",
  "field_11""2K",
  "field_12""",
  "field_13""",
  "field_14""",
  "field_16""test"
}

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (5,448)