Deletion of a Sharepoint List Item Based on Deletion in a Recurring Series from an Outlook Calendar

(0) Share

Report

Posted on by MB-08122315-0

Hello!

I've created 2 working flows that add to and update a Sharepoint list of events that takes information from my Outlook Calendar and stores event IDs. The issue that I am running into is how Power Automate reads the deletion of a singular event that is part of a recurring calendar series.

A deletion of a single event that is NOT part of a recurring series works fine -- however, I am seeing that IDs are understood differently by Microsoft when a deletion occurs for a recurring series. I also know that it is actually seen as an 'update' to an event series and not an actual deletion.

Does anyone know how to formulate a flow that deletes a corresponding Sharepoint List item when an event that is part of a recurring series on Outlook Calendar is deleted? Or how IDs are understood by Microsoft specifically for recurring events/when events in the series are deleted?

Categories:

Building flows

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @MB-08122315-0,

Have you tried storing the iCalUid and the SeriesMasterId properties as well in your list? This might give you a bit more context about the events as well.

https://learn.microsoft.com/en-us/graph/api/resources/event?view=graph-rest-1.0#properties

Additionally have a look at the List instances endpoint of the Graph API as well:

https://learn.microsoft.com/en-us/graph/api/event-list-instances

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Suggested answer

S-Venkadesh 927 Moderator on at

Like (0)

Report
Hi @MB-08122315-0,

Here is one way to resolve this:

Get event instances

Call the Graph API:
/me/calendar/events/{id}/instances?startDateTime={start_datetime}&endDateTime={end_datetime}

This returns all occurrences of the recurring event within the date range.

Store event instances

Save the returned occurrenceId values (or instance IDs).

These represent the existing event occurrences.

Compare with SharePoint items

Each SharePoint list item should store the related occurrenceId.

Compare SharePoint occurrenceIds with the instances returned by Graph.

Identify deleted instances

If an occurrenceId exists in SharePoint but does not appear in the Graph response, it means that event instance was deleted from the series.

Delete the SharePoint item

Delete the corresponding SharePoint list item for the missing occurrenceId.

I hope this information helps! If it does, please consider giving a 👍.
If this solved your issue, please mark it as ✅ Verified Answer
Best regards,
S-Venkadesh

Was this reply helpful? Yes No