Recreating Recurring Sharepoint Calendar Events

[Jrogles]

I'm trying to make a daily flow that checks a sharepoint site's event calendar, and any event marked as birthday (or recurring/etc) -- I'd like to create a new event with all of the same information except the start and end date's year is incremented by one. I'm trying to sidestep the modern ui's ignoring of recurring events, while also avoiding having to make an event: every year for every employee.

*** Updated the main post instead of replying: ***

Current Problem:

502 Bad Gateway on the HTTP Request to Sharepoint trying to Update the Create Item with the fAllDayEvent param set to true. Any help is greatly appreciated on the HTTP Request.

Current Flow:

Current Failed Test with a 502 Bad Gateway -- Event Time Date Error

More on the error:

The Events are still made:

[Jrogles]

cleaning up thread

[Jrogles]

more cleanup

[Jrogles]

thread cleanup, made a lot of progress

[Jrogles]

Here is the full text of the 502 Error.

{

"error": {

"code": 502,

"source": "flow-apim-msmanaged-na-eastus2-01.azure-apim.net",

"clientRequestId": "cbc5a112-576f-4682-b8f4-234058867f03",

"message": "BadGateway",

"innerError": {

"status": 502,

"message": "Invalid date/time value.\n\nA date/time field contains invalid data. Please check the value and try again.\r\nclientRequestId: cbc5a112-576f-4682-b8f4-234058867f03\r\nserviceRequestId: 50aeca9e-d0f2-8000-7958-ecc8417b6892",

"source": "____/sites/H20/_api/web/lists/GetByTitle('Events')/items(454)",

"errors": [

"-2130575332",

"Microsoft.SharePoint.SPException"

]

}

}

}

I'm really unsure how using the original start time, the add to time action, and a even a formatDateTime can still yield me bad date/time data for entry on the object.

The new event is created fine with those date/times -- so why is updating the all day event flag, throwing an invalid date/time error? Is this completely unsupported functionality for sharepoint calendars now?

Also trying to use the Expression True value for fAllDayEvent param throws a 400 invalid JSON error. 

[Jrogles]

So I think this is boiling down to the fact that the fAllDayEvent isn't being set to a Boolean value for some reason.

Here the new item is set to:

<d:fAllDayEvent m:null="true" />

Instead of what the existing item's fAllDayEvent is set as:

<d:fAllDayEvent m:type="Edm.Boolean">true</d:fAllDayEvent>

Not having any luck with these--

"fAllDayEvent":true

"fAllDayEvent" : "True"

"fAllDayEvent" : "true"

"fAllDAyEvent" : "{expression 'true'}

How should I format the JSON body of the HTTP request to get the proper syntax on the update-item set?

[Jrogles · Accepted solution]

Solution!! The fAllDayEvent flag needs to be passed with new start/end times with the hh:mm:ss removed.

Thanks to @v-yamao-msft for pointing me to this article on my other thread.

Here are the two final flows I used (I realize they can be combined) to recreate recurring, all-day events on Sharepoint Online Event Calendars:

Recurring Events:

addDays function:

addDays(utcNow('yyyy-MM-dd'),-1,'yyyy-MM-dd')

utcNowfunction:

utcNow('yyyy-MM-dd')

Category Value contains "Birthdays"

addDays function:

addDays(utcNow('yyyy-MM-dd'),1,'yyyy-MM-dd')

empty function:

empty(body('CheckIfItExists')?['value'])

Make any new Birthday - an all day event

formatDateTime #1 & #2:

formatDateTime(triggerBody()?['EventDate'],'M/d/yyyy')

URI:

_api/web/lists/GetByTitle('Events')/items(@{triggerBody()?['ID']})

Headers:

{
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE",
"Accept": "application/json;odata=verbose"
}

Body:

{
"__metadata": {
"type" : "SP.Data.EventsListItem"},
"fAllDayEvent" : "True",
"EventDate" :"@{formatDateTime(triggerBody()?['EventDate'],'M/d/yyyy')}",
"EndDate" :"@{formatDateTime(triggerBody()?['EventDate'],'M/d/yyyy')}"
}

[whcweb]

Trying to update SharePoint Online Event list using MS flow HTTP to Sharepoint Action but running into the following error "A type named 'SP.Data.EventsListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type."

Any ideas what I am doing wrong or missing?  Below is my Request and the Response I get. 

:Request

Header:
{
"Content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE",
"Accept": "application/json;odata=verbose"
}
Body:
{
"__metadata": {
"type" : "SP.Data.EventsListItem"},
"fAllDayEvent" : "True",
"EventDate" : "@{formatDateTime(body('Create_item')['EventDate'],'M/d/yyyy')}",
"EndDate" : "@{formatDateTime(body('Create_item')['EventDate'],'M/d/yyyy')}"
}

:Response

{

"status": 400,

"message": "A type named 'SP.Data.EventsListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type.\r\nclientRequestId: eaae8b9c-8fbc-4513-a14d-de9e581111dd\r\nserviceRequestId: 10acef9e-c0a7-8000-8706-7a79ffb54afa",

"source": "[tenanturl][site]/_api/web/lists/GetByTitle('Events')/items(429)",

"errors": [

"-1",

"Microsoft.SharePoint.Client.InvalidClientQueryException"

]

}

[Michael_P]

WHCWeb

I ran into the same error: "A type named 'SP.Data.EventsListItem' could not be resolved by the model"

I resolved it by updating the reference to "Events" in the "SP.Data.EventsListItems" to match the name of my calendar/list.  The example json code provided assumes the calendar/list is called "Events".  If it is not, then you need to update the json code.  If your calendar/list is call "Example" then you need to change the code to refer to "SP.Data.ExampleListItem".

In my case, my list was called "Birthdays" which meant I had to update the body json code to (bold emphasis added):

{
"__metadata": {
"type" : "SP.Data.BirthdaysListItem"},
"fAllDayEvent" : "True",
"EventDate" :"@{formatDateTime(triggerBody()?['EventDate'],'M/d/yyyy')}",
"EndDate" :"@{formatDateTime(triggerBody()?['EventDate'],'M/d/yyyy')}"
}

Hope this helps.

Regards

Michael

[Anonymous]

 can you list out some of the custom variables for what you did here? I am trying to recreate but can't see everything

[Spreij]

@Jrogles 

Thanks for working this out. Was hoping to use it but I seem to get a error message saying: Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'CheckIfItExists' referenced by 'inputs' in action 'Condition_2' are not defined in the template.'.'.

I followed only your solution steps, reading old informatie I found that CheckifitExists is often overcome by things like this solution: https://powerusers.microsoft.com/t5/Building-Flows/How-to-check-if-an-item-exists-on-a-SharePoint-li...  . However I do not see that in one way or a other set in your solution. Did I miss something? Where did you define CheckIfitExists or how should I go about it?