cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoHo
New Member

building an overview of booked Ressources

Hi,

we are a voluntary fire department.

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"?

 

 

And then sync this with a goolge calendar?

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @JoHo 

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:

https://powerusers.microsoft.com/t5/Building-Flows/Delete-SharePoint-list-item-deletes-matching-Shar...

After obtaining the necessary information of the deleted event, go to the Google calendar to find the corresponding event and delete it.

Best Regards,

Bof

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,096)