Problem with data format when trying to upadate item on Sharepoint list

(1) Share

Report

Posted on by Alicja

Hello,
I am trying send an http request to Sharepoint calendar to update event by using flow like this:

This is a body:

{
"formValues": 
[

{"FieldName": "EventDate", "FieldValue": "5/10/2020 0:00 AM"},
{"FieldName": "EndDate", "FieldValue": "5/10/2020 0:00 AM"},
{"FieldName": "fAllDayEvent", "FieldValue": "True"}
],
"bNewDocumentUpdate": true
}

This is a response:

{
 "d": {
 "ValidateUpdateListItem": {
 "__metadata": {
 "type": "Collection(SP.ListItemFormUpdateValue)"
 },
 "results": [
 {
 "ErrorMessage": "Enter a date and time like this: 2/23/2012 2:25 PM",
 "FieldName": "EventDate",
 "FieldValue": "5/10/2020 0:00 AM",
 "HasException": true,
 "ItemId": 34
 },
 {
 "ErrorMessage": "Enter a date and time like this: 2/23/2012 2:25 PM",
 "FieldName": "EndDate",
 "FieldValue": "5/10/2020 0:00 AM",
 "HasException": true,
 "ItemId": 34
 },
 {
 "ErrorMessage": null,
 "FieldName": "fAllDayEvent",
 "FieldValue": "True",
 "HasException": false,
 "ItemId": 34
 }
 ]
 }
 }
}

I was formatted datetime by using the formula:

formatDateTime( if(empty(triggerBody()?['XXX']),triggerBody()?['YYY'],triggerBody()?['ZZZ']),'M/d/yyyy H:mm tt')
Also I was trying insert there for example: 'M/d/yyyy H:m tt', 'MM/dd/yyyy HH:mm tt', but nothing is work, always the same exception. Does somebody have any ideas what can also I try ?

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Alicja 22 on at

Like (1)

Report
Copy link

Link copied!
I am using now formulas like below and it works for me:
{ "formValues": [ {"FieldName": "EventDate", "FieldValue": "@{formatDateTime(variables('StartDate'), 'yyyy-MM-dd 12:00:00')}"}, {"FieldName": "EndDate", "FieldValue": "@{formatDateTime(variables('EndDate'), 'yyyy-MM-dd 23:59:00')}"}, {"FieldName": "fAllDayEvent", "FieldValue": "True"} ], "bNewDocumentUpdate": true }

Thank you for your help 😉

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Alicja ,

If you want to create/update the event as an all-day event, EndDate needs to be yyyy-MM-ddT23:59:00.

Please check the following links:

https://powerusers.microsoft.com/t5/I-Found-A-Bug/All-Day-Event-in-a-SharePoint-Calendar-is-not-recognized-as-a/td-p/278310

https://github.com/SharePoint/sp-dev-docs/issues/2755

Best Regards,

Was this reply helpful? Yes No
Alicja 22 on at

Like (1)

Report
Copy link

Link copied!
It is not working for me.
Input body:
{ "formValues": [ {"FieldName": "EventDate", "FieldValue": "2020-05-20T00:00:00Z"}, {"FieldName": "EndDate", "FieldValue": "2020-05-20T00:00:00Z"}, {"FieldName": "fAllDayEvent", "FieldValue": "True"} ], "bNewDocumentUpdate": true }
Output body:

{ "d": { "ValidateUpdateListItem": { "__metadata": { "type": "Collection(SP.ListItemFormUpdateValue)" }, "results": [ { "ErrorMessage": "You must specify a valid date within the range of 1/1/1900 and 12/31/8900.", "FieldName": "EventDate", "FieldValue": "2020-05-20T00:00:00Z", "HasException": true, "ItemId": 43 }, { "ErrorMessage": "You must specify a valid date within the range of 1/1/1900 and 12/31/8900.", "FieldName": "EndDate", "FieldValue": "2020-05-20T00:00:00Z", "HasException": true, "ItemId": 43 }, { "ErrorMessage": null, "FieldName": "fAllDayEvent", "FieldValue": "True", "HasException": false, "ItemId": 43 } ] } } }

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Alicja ,

Please try this format: yyyy-MM-ddTHH:mm:ssZ

Best Regards,

Was this reply helpful? Yes No