How to create a recurrent event
This time a short blog about creating recurrent events. In SharePoint events lists you have the option to create events with recurrence settings. In this blog I will show you how you can create such an event via Power Automate.
Inspiration
This question from sharepointuser1:
Everything’s working fine except I noticed that when an event is recurring – the recurring settings don’t carry over on the individual team’s calendar.
Power Users Community thread: SharePoint Calendar – Recurring Event and Create Item Action.
RecurrenceData field
Like mentioned in the Power Users thread the challenge is to set the recurrence settings. Luckily there are some nice posts on the Internet which give a bit of insight on what this schema looks like.
First of all this REST API + Expand Recurring Calendar Events? thread on StackExchange was very useful. That thread made clear that you are able to retrieve the RecurrenceData field with a Send an HTTP request action. Below is an example of that in Power Automate.
Recurrence Data schema
I also found this great blog from Justin on the SharePoint recurrence data schema. A blog from 2010 but it looks like the schema is still relevant. That resource is especially useful to find and explore the different patterns of the RecurrenceData field.
Below is for example a pattern for once a week on Sunday (weekly). The recurrence stops after two repeats.
Flow setup
The following flow can use this recurrence pattern and create a new event.
1. Add a Manually trigger a flow trigger action.
2. Add a Send an HTTP request to SharePoint action. Use a POST method and make sure it the URI is using the Events list.
3. For the body you can use something like below. Like mentioned earlier, this is a pattern for once a week on a Sunday (weekly). The recurrence stops after two repeats.
Happy testing!
Hi,
I followed the guidance you had posted at this site, https://powerusers.microsoft.com/t5/Building-Flows/SharePoint-Calendar-Recurring-Event-and-Create-Item-Action/td-p/1474151. However to address my problem, it is not working. I have successfully created a flow that will send Outlook meeting events to the Attendees Outlook calendar when an event is created on the SharePoint calendar. I have a secondary flow that successfully updates the meeting on the Attendees calendar when the event on the SharePoint Calendar is updated. This works great for single day events. The problem I am having is with recurring events. Recurring events are placed on the Attendees calendar as one long meeting. The recurrence duration of the meeting is calculated from the start of the first occurrence to the end of the last occurrence. I need the duration to be the duration of the meeting for each occurrence. Can you help me with that? Thank you.