Enabling a mobile workforce with Power Apps and SharePoint Online for
Yarra Valley Water
Yarra Valley Water is the largest of Melbourne’s three water corporations. Managing infrastructure and assets worth over $4 billion and employing 600 people.
Client
Yarra Valley Water
Services
SharePoint Online, Power Automate, Power Apps
Industry
Utilities
Organisation type
Medium (500 – 1000 employees)
Country
Australia
Context
Every day, more than 1.9 million people and 50,000 businesses, rely on Yarra Valley’s Water and sanitation services.
Their large mobile workforce needed a mobile safety solution that staff could use out in the field to conduct timely, reliable and accurate safety audits and incident reports. They also needed access to up-to-date safety information and alerts to make quick decisions on the job.
Engage Squared used Power Apps to create and roll out a pilot app in two weeks. The success of the pilot led to the creation of a full solution, now featuring daily automation of safety tasks and the management and archiving of reports–all powered with SharePoint Online, Flow and Power Apps.
Engage Squared partners with our clients across all industries to develop and implement Digital Workplace Strategy that has the employee experience at its core with a focus on immediate quick wins with an evolving formula to support their long-term needs.
The challenge
Yarra Valley Water’s mobile workforce didn’t have the modern tools they needed to complete important safety activities onsite—they relied on paper forms and emailing or calling the head office.
Paper binders filled with important safety procedures kept staff informed about the correct way to complete a safety activity, but the time it took to distribute and update documentation made it more difficult to maintain safety compliance.
While Microsoft 365 was already being used for team collaboration with tools such as SharePoint Online and Skype for Business, existing business applications remained in on-premise environments such as SharePoint 2013. InfoPath forms were used to complete reports back in the office and stored in SharePoint 2013 lists, however the gap in time between the incident and completing the InfoPath form report could be quite long.
Fatigue assessments filled out on paper resulted in a poor experience for employees as well as inconsistent reporting for incidents and hazards from the field.
It was also a challenge to quickly communicate important safety alerts to their workforce, as emails could be missed in staff inboxes.
These challenges created an opportunity for Yarra Valley Water to review and simplify existing safety processes. They knew they needed a platform to enable rapid mobile development and distribution to their workforce – not only for safety scenarios, but for other business cases. What they didn’t know is which platform would best support this. Prior to contacting Engage Squared, Yarra Valley Water had spent a year and a half scoping solutions but had yet to settle on a plan forward.
The solution
Yarra Valley Water were looking to achieve two main objectives:
- Determine which platform would enable them to rapidly develop mobile solutions they could easily distribute to their workforce.
- Create a mobile safety app that provided a quality end-user experience, kept their workforce informed daily and provided reports over time.
Engage Squared worked with Yarra Valley Water to conduct workshops introducing staff to the capabilities of Power Apps –from user interface design, reading and writing to data storage locations, to the lifecycle management of applications. Three safety activities were chosen to build into a pilot app: pre-work safety checks, access to safety procedure documentation and access to important safety alerts.
In two weeks the app was created, tested, and rolled-out to a pilot group. The positive feedback from the pilot group gave Yarra Valley Water the confidence Power Apps was the right platform of choice for their needs, as they could quickly test and validate their requirements. Creation of the full solution commenced.
The Power App provides:
- real-time alerts, automated fatigue assessment scoring that results in mandatory follow-up actions,
- hazard and incident reporting,
- an in-app safe work procedures library, and a
- pre-work safety audit with dynamic instructions
Staff can use their phone to take photos as they fill out reports without having to write separate emails and hunt for attachments, while their GPS logs the location of any issues. This means the main office can instantly see the photos and where they were taken, without needing to send someone out to review the details later.
Microsoft Flow listens to activities within SharePoint. When a new safety report, hazard, or incident is created, Flow checks a SharePoint list then sends an email to notify the correct team to action the submission. If any photos were taken, they’re automatically attached to the email to ensure the team can see the information as quickly as possible.
Meanwhile, all the data is stored in SharePoint Online lists, enabling the safety team to create reports in Excel and Power BI. The in-app safety alerts are easily created by the safety team in a list, reducing the time needed to push out a time-sensitive message and providing a consistent user interface in the app for users. This means the safety team can be anywhere while creating and analyse the data, without needing to use virtual desktops to access their on-premise SharePoint 2013 environment.
The result
The end result is a production mobile business safety app that dramatically improves safety processes and compliance, as well as a strategic platform to deliver future application solutions.
Through this solution we’ve helped Yarra Valley Water:
- Increase the efficiency and consistency of safety procedures
- Drastically reduce their compliance overhead
- Expose and uplift the quality of reporting and analytics data
