SharePoint List Items to Outlook Calendar

[c9]

Hi,

Looking for assistance with creating a flow that creates an Outlook calendar event, any time an item is added to my SharePoint list. 

Additionally, if an item is updated in the SharePoint list, such as the time or date, I would like for the Outlook calendar event item to auto-update as well... send a meeting update email to attendees. 

Second to last, since the SharePoint list is tied to a regional timezone, would like assistance using the converter feature to auto-adjust the timezone for meeting events, based on each individual's respective timezone, so that the event accurately reflects in their timezone.

Lastly, in the event an item is deleted, I would like for the Outlook event to update to event/meeting canceled, prompting users to remove from calendar. 

Not sure if there is anything else I might be missing, but feel free to share any additional input/advice, as I'm open to additional feedback. 

[WillPage]

Dates in SP date/time columns are all UTC so you don't need to do any conversion - that's done in the client front-end based on the individual's region or the SharePoint site's timezone settings. Just set your meeting event time zone to UTC too and it'll display at the right time in everyone's Outlook calendars

Add a column to your list for the calendar event id. When an item is created or modified (your trigger) you can have a condition that your event id column is null and in the Yes branch, create the calendar event and then update the list item with the event ID that's output from the create event action.

In the No branch just do the update.

You'll need a second flow to trigger when an item is deleted. I'm not 100% sure you'll still have access to the event ID from the deleted item though, but if you do, you can use that to remove the corresponding event from the calendar.

[c9]

So working on the first part of the flow, I created the following to first, make sure a SharePoint list item could be copied over to my Outlook calendar, but second to make sure that the time reflects accurately. 

I've attempted a # of things from running the flow without the Convert Time Zones for both the Start Date Time and End Date Time to using it (as depicted above), none of which seem to be producing the desired outcome, as the time still shows off in my Outlook calendar. 

For both the Convert Time Zone pieces, I've tried 3 different things, 

Test #1
Source Time Zone - UTC

Destination Time Zone - UTC

with the create event time zone set to UTC as well and I see the following on my calendar

To clarify, my SharePoint list item has 2 columns in particular, a Start Date and End Date, which are currently set to 7/5/2024 12:00 PM and 7/5/2024 1:00 PM, so I'm seeing an inverse of what I currently have listed.

When I open the meeting event, this is what I see

Which now displays a different time, but also in UTC, which I assume is because the create event timezone is set to UTC.

Test #2

So then I changed the Convert Time Zone for both the Start Date Time and End Date Time to 

Source Time Zone - UTC

Destination Time Zone - Eastern Standard Time

with the create event time zone still set to UTC for my create event and now I see on my calendar

with this when I open the meeting invite, I see
Start Time - 7/5/2024 12:00 AM (Friday)

End Time - 7/5/2024 1:00 AM (Friday)

despite it showing on my calendar on a Thursday

Test #3

I changed the Convert Time Zone for both the Start Date Time and End Date Time to 

Source Time Zone - UTC

Destination Time Zone - Eastern Standard Time

with the create event time zone set to Eastern Time (US & Canada) for my create event and now I see on my calendar

appears the same as Test #1 calendar view, however...

when I open the meeting (with the create event now set to Eastern Time (US & Canada)... I see

but the timezone also no longer shows