Hero image from West Yorkshire Police
Policing Matters

West Yorkshire Police use Forms and Automate to improve driver safety

West Yorkshire Police has recently introduced dash mounted cameras in police vehicles to increase safety for officers and staff and increase confidence with communities.

Any complaints or, challenges can be quickly resolved because of this. However, it could have also created a dis-benefit for the force with manual re keying, trawling of data or, even reverting to paper around the reporting, tracking and administration of any footage. 

The force has utilised NEP enabled functionality of M365 forms to make a fresh clean reporting mechanism.

Along with this Power Automate has been used to create a report, triggered by a reoccurrence once a month. This taking out all the manual re keying that would have occurred if M365 not been in place.

The flow lists all requests in the spread sheet, gets the SPOC email address, filters the data by district, creates separate CSVs and sends individual emails with those CSVs attached to the SPOCs.

These reports can be used by the districts to monitor the requests and workload as well as track benefits.

Workflow to support Power Automate on this functionality

Back to top
Back to top


Sign up to make sure you get all the latest straight to your inbox