0

I want to add an iCalendar to a SharePoint calendar, but I cannot find anywhere how to do it.

In outlook you can do it easily by clicking "Add Calendar - From Internet...": add ics to Outlook

But on SharePoint, there is not such a thing on the Calendar Ribbon: SharePoint calendar ribbon

The main purpose is that you subscribe on an iCalendar, so that the appointments in the calendar can automatically gets updated in the SharePoint calendar. Everyone who has access to the SharePoint page will then see the appointments.

Does anyone know to do this? I cannot believe that this functionality is not available in SharePoint.

I use SharePoint 365, as part of Office 365.

0

Actually, when you add a calendar from the internet, it will add it as a separate calendar in your outlook, it won't "merge" the events from that calendar in your existing calendar. Same with SharePoint. You can have the SharePoint calendar mapped to outlook so you can see the events in Outlook, but when you add a calendar from the internet it won't merge those events to it, same as it did with Outlook Calendars.

| improve this answer | |
  • Hi Mohamed, thanks for your comment. In Outlook you can merge calendars into one view. And in SharePoint you can overlay multiple ones in same calendar. However, eventhough it would not merge it, I still want to know, how can I then add .ics calendar as a new calendar then. – Ozhan Karkukli Jun 10 at 12:01
  • Yes, you can have overlays, but that's not an actual merge. If you want to take the events from that calendar, you can do a onetime import from the Outlook to SharePoint. Here's an example: youtube.com/watch?v=GhupNIhJPZY – Mohamed Derhalli Jun 10 at 13:01
  • Thanks Mohamed, I also already saw that youtube movie. The thing is, I don't want to have static import, but one that is dynamic. That you subscribe to, and if new appointments get in, that it automatically gets updated. For example. we have release calendar internally (in Jira), that we export via iCalendar function. I want to make this releases also available via SharePoint to our customers. But you can imaging all the time new releases will added to the calendar, you want it automatically added to the SharePoint also. – Ozhan Karkukli Jun 10 at 13:47
  • In that case, am not sure if there's something that you can do from Power Automate, although I know Jira connectors in Power Automate are premium and not sure if it could connect to events in Jira. Maybe someone else would have a better idea. – Mohamed Derhalli Jun 10 at 14:19
0

After looking for almost two weeks, I think I got it. I will post it here in case someone else has the same questions.

SharePoint has not such functionality standard. I import first the .isc file in Google calendar. And with Microsoft Power Automate I got info from Google Calendar into SharePoint Calendar.

It's not something you do in 5 minutes. It took me couple of days to figure out how it works and to create all the needed flows. But now if I know everything, it would still cost me between 30 and 60 minutes.

Get info in Google Calendar

Because Google Calendar support ical functionality, and because it has good integration with Microsoft Power Automate, we are first going to load the ical in Google Calendar.

We are going to do importing of ical in Google Calendar with a Google Script. The reason for this is that if you do it manually, Google syncs with the ical on a irregular bases. By doing it with a script, we can control the interval of syncing. I use this script: https://github.com/derekantrican/GAS-ICS-Sync Please follow the instructions carefully.

Using Microsoft Power Automate to Push data to SharePoint Calendar

Microsoft Power Automate (previously known as Microsoft Flow) is an automation tooling of Microsoft. With this tool you can can create automation flows with drag-and-drop.

For the purpose of placing information to SharePoint Calendar, multiple flows are created. The flows can be found by going to flows.microsoft.com and click in the left navigation menu on “My Flows“ and then on “Team Flows“. Here you will find list of all flows that are created.

In general, for each calendar that needs to be added to SharePoint, three flows are created:

  • One for adding new calendar item
  • One for updating a calendar item
  • One for deleting a calendar item.

Things to do on SharePoint

Make sure that you create on you SharePoint Calendar a new Column to store an unique ID for the calendar Event. I called my EventID and used

triggerBody()?['extendedProperties']?['private']?['id']

You need to check if this information is filled in your google json call to Microsoft Power Automate.

This EventID field I use to search the event in the Update and Delete Flow.

I hope this helps someone.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.