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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,270)