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
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.