We have around 10 vehicles (fireengines) and for each, we created a "ressources" account as a device. We also have 4 ressources accounts for our rooms and trainng area.
Everybody can book a room or a vehicle by creating an event and putting the ressource in the invitation.
Now i would like to create an overview of booked vehicles and rooms and show them on a info screen so that everybody sees, if there is a event in a room and if a vehicle is booked or if he can use it. best would be to have it on a sharpoint site.
in addition it would be great to have this synced with a google calendar because our internal alarm-tool can only handle google calendar and then we could change tha alarming if a vehicle is blocked.
I found a power automate template to sync a google calendar entry with an office calendar. but the issue is, that if a booking (meeting) is canceled, the google calendar entry will not.
So can anybody give me a hint, how i can create such a synchronisation of the >10 calendars of each vehicle and room, show them on a sharepoint with the innformations: "booked vehicle" "Host" and "Date/Time"?
After an event deleted from a calendar, there are no properties that could be found in the Calendar list, even bin.
As a workaround, you could store necessary information of these events into a SharePoint list or Excel file. Then create a flow with trigger "When an event is deleted" and a structure could loop through all events in Calendar list and SharePoint list, compare them to found the lack event in SharePoint list, then send Email to users. After all, delete the event from SharePoint list.
There is a post shows delete a event from calendar list when an item is deleted in SharePoint list, it could help you better understand it: