Please Rotate Your Device

Client Background

The client is a UK power network operator responsible for maintaining and upgrading overhead power lines and underground electricity cables.  Driven by research, innovation, and customer service, as well as the constant changes to how electricity is consumed, the client delivers the power network to support millions of people and properties connected to the National Grid.

The Challenge

Having recently invested in Microsoft Office 365, the client wanted to utilise Microsoft’s low-code application development technology, Power Apps, to create a mobile app that would streamline some of the existing processes for their field engineers.  This required dynamic forms that would allow them to digitally collect the information gathered from vehicle inspections and audits as well as reporting any performance observations or near-misses encountered.

The client had already performed the data analysis and mapped out the design requirements for four unique electronic forms to capture this information. However, Power Apps expertise was required to expand upon the capability available to individual business users. Jumar was approached because of its experience in developing complex tablet and mobile apps using the Microsoft Power Platform and its Microsoft Gold Partner status.

The Solution

Instead of creating individual applications for each form required, Jumar took a data-driven approach to develop a single field engineer app for all four surveys.  To do this, Jumar’s Power App experts created a cloud-hosted SQL database and the necessary data scripts that would be required for each field engineer survey.  A Microsoft flow was then created to automate the transferal of data to their business reporting systems.

Once built, Jumar configured the field engineer application onsite to ensure a seamless integration with their other Office 365 solutions.  Power Apps training was also provided so that the client’s team could continue to update the mobile app in the future to meet any changes in field engineer inspection and survey requirements.

Benefits

By capturing data from multiple structured and unstructured sources electronically, the client was able to streamline their field processes as well as integrate their data into the necessary reporting tools.

This singular field engineer app created a one-stop shop for the field engineers to complete their surveys and eliminated several time-consuming processes.  It also improved efficiency for the client and enabled vital information to be presented in a clear and concise format.

Furthermore, by consolidating several forms into one data-driven application, it reduced the dependency on multiple business owners maintaining and updating the app as and when required.  The training provided by the Power Apps experts also ensured their IT team had the necessary skill set to maintain and develop further applications using the Power Platform.

Following the successful delivery of the project, the Jumar group continues to provide resourcing support to the power network operator.

Coronavirus update from Jumar – click here.