Silversands Logo

Silversands Ltd, Albany Business Park, Cabot Lane
Poole, Dorset, BH17 7BX

Customer Portal
Fire Service site bookings managed by Silversands Power Platform application hero image

Fire Service site bookings managed by Silversands Power Platform application

Technology used :

Power Platform

Fire Service site bookings managed by Silversands Power Platform application hero image
What were the challenges?
  • Fire service sites and locations can be used for meetings, training, and other events but the booking process was very disjointed 
  • Site bookings were managed locally by each fire station or location 
  • Excel was used to track bookings 
  • Cancellations were difficult to manage 
  • No central view of bookings made admin difficult 
  • Related risk assessment requirements were manually generated 
  • Overall, the process was very inefficient and prone to difficulties
What was the solution?
  • As part of a process improvement strategy, a service-wide Site Bookings application was required 
  • Microsoft Power Pages was defined as the primary solution to support internal and external user access 
  • Guided process helps organisers find the right space for their event 
  • Automated assessment of Risk Assessment requirements is made 
  • Staff can see an overall view of site bookings 
  • An organiser can log into review, amend or cancel a booking
What were the results?
  • The local and manual management of bookings has been replaced by a service-wide portal 
  • Organisers can easily find a suitable space anywhere in the organisation’s locations  
  • Risk assessment records are generated automatically where required 
  • Amendment or cancellation of booking is easy 
  • Admin staff can review bookings across the organisation’s entire estate
  • Ultimately, site bookings are much more efficient and a more pleasant experience for all users 

The Background

A typical requirement within the fire service is to book rooms or areas in a fire station, headquarters or other for varied purposes including training, meetings, and community events. These bookings may be made by staff and external people, including the police, who share their headquarters with the fire service.

In the case of this fire service, the bookings for each site were managed locally using spreadsheets and calendar entries. There was no central view of bookings or availability of locations across the service and any no-shows would mean a space remaining unavailable when it could be rebooked by someone else.

Alongside the booking of spaces, there may also need to be a risk assessment completed. For example, if an external organisation wanted to use a fire station for a community event, that would require a risk assessment but an internal booking for a meeting room would not need one.

As you might imagine, the decentralised nature of the booking process, the potential requirements for risk assessments and the general management of bookings resulted in a very manual, inefficient, disjointed, and largely uncontrollable process.

Since this fire service is in the course of digitising many processes using the Microsoft Power Platform, this site bookings process was seen as one that would deliver a major benefit across the organisation, and we were asked to create a solution as part of our ongoing service contract.

Background
  • Site bookings process was very manual, disjointed and inefficient
  • No central view of bookings
  • Cancelations were difficult to manage
  • Related risk assessment requirements were manually created
<p>“Helping our customers to become more efficient makes up a high proportion of the work we do and our Power Platform solutions are really key to delivering this.”</p>

“Helping our customers to become more efficient makes up a high proportion of the work we do and our Power Platform solutions are really key to delivering this.”

Mike Tansey, Account Director, Silversands

The Solution

Following a requirements gathering exercise, and analysis of the current process, the key requirements for the Site Bookings application were defined as:

Ordinarily, the solution to this requirement might have been delivered using Canvas and Model-Driven Power Apps. However, the need to support interaction with non-fire service people meant that the licensing requirements for Power Apps could not be met using existing licences. Consequently, the decision was made to use Power Pages, which enabled a web-based booking interface to be created.

The automation underpinning the site functions such as notifications and interfacing with the existing Risk Assessment Power Platform application were developed using Power Automate and all data sat securely in the same Dataverse that the administration applications utilised.

Power Platform booking request entry form displayed on a computer

"When external users need to interact with a Power Platform solution, licensing and access can be overly complex. Using Power Pages allows us to reduce the administrative stress around access and deliver highly functional, secure solutions that bring together Microsoft 365, Power Platform, and beyond."

Mark Dutton, Power Platform Technical Lead, Silversands

An integrated suite of apps

This Site Bookings app is just one of several complimentary apps that are currently under development or have been developed, including for Risk Assessments, Staff Inductions and Incident Reporting.

The selection of the Dataverse as the common data store, enables all the Power Platform solutions to share and utilise the same data set.

Solution
  • Microsoft Power Platform solution design replicates and improves on manual process
  • Solution uses Power Pages to support access for fore service and non-fire service people
  • Bookings can be created, amended and cancelled as required
  • Guided process gathers requirements and filters available spaces
  • Automated risk assessment requirement capability
  • Email notifications for successful booking
  • Global calendar view for admin staff
  • Site branded to align with public website
Man looking at Power Platform site booking review screen

The Results

Where previously site bookings were managed locally using Excel and the whole process was fragmented and subject to a number of manageability issues, the implementation of the Site Bookings application has revolutionised the entire process.

  • The local and manual management of bookings has been replaced by a service-wide portal, available to internal staff and external event organisers.
  • Organisers can easily find a suitable space anywhere in the organisation’s locations and which fits the profile of the event, whether it is a meeting for 2 or 50 people, a training course, or a community event.
  • Bookings can be cancelled with relevant notifications sent to interested parties.
  • Bookings are assessed in real time to determine whether a related risk assessment record should be generated and linked
  • Organisers can login to review, amend or cancel bookings, as needed
  • Admin staff can review and manage bookings across the service’s entire estate

As a cross-service solution, site bookings are much more efficient, a more pleasant experience for event organisers, easier to manage for admins and an order of magnitude better than what was in place previously.

Benefits
  • Inefficient and fragmented manual process replaced with Power Platform solution
  • Internal and external event organisers can make bookings through a web site
  • Organisers can easily find suitable and available spaces, filtered by requirements
  • Bookings can be cancelled or amended easily
  • Risk assessment records are automatically created if necessary
  • Admin staff can manage bookings across the entire service