Sharepoint list and calendars

[wickit]

Background: Was asked to setup a list for the staff to add trips events etc with some custom areas. All setup working great. set list to calendar view for ease of access.

 

Now staff asking for access to said list/calendar to outlook. SharePoint lists can't be added to outlook calendars!

 

Now my thought was, if I create a new Calendar on SharePoint and add all the extra custom columns, export the list and them import to new calendar I would be on a winner......

NOPE, can't be done.

 

I have tried the following:

Opened exported list in Excel and tried to export Table to a SharePoint list, This will only create a new list on SharePoint and will not let me write to new calendar.

 

 

Any ideas of my next move is?

[mwnci]

I would use Power Automate for this. Create a flow that takes from the date column and creates an event in a specific calendar. You would be best to do this at the point when the item is added to the list in the first place.

[KK20]

sharepoint calendars can be added to outlook (I use one). go to your full calendar (not the little events web part). Click calendar tab to open the ribbon, click connect to outlook. A popup will open in outlook asking permission to join the calendar. Say yes and you get a separate calendar in outlook.

 

Now the bad news. It is really flaky in outlook, you get errors saying the event has changed, you get popups saying the event is in use would you like to save in your personal calendar (which then adds the event to your own calendar instead of the sharepoint one). Categories dont always change colour, sometimes they do, sometimes not.

 

ignore me, you said LIST not calendar. However the note about the flakiness might dissuade you. A shared mailbox calendar works well though.

Edited November 24, 2022 by KK20