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 ?
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 😉
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://github.com/SharePoint/sp-dev-docs/issues/2755
Best Regards,
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
}
]
}
}
}