Utilities Services Company Leverage Power Apps To Extend Dynamics SL ERP Functionality For Its Field Crew

Overview


VNB Consulting assisted an utilities services company build a Power Apps solution for its mobile task force to manage work orders

Customer Profile

Customer is a leading super-regional provider of outsourced services to natural gas and electric utilities. They offer a comprehensive suite of services with best-in-class operational capabilities and results. They provide professional, superior, project execution to large investor-owned utilities, cooperatives and municipalities. Customer’s end-to-end offerings are guided by their strong experienced management team, at both the executive and operational levels. They initially expressed interest in Power Apps.

Customer Situation


Dynamics SL ERP vnb consulting powerapps

Being in the business of providing services to Gas and Electric companies, the customer was looking to modernize its field services operations by replacing an old excel based process to a mobile solution with direct integration to its on-premise ERP. In response to customer's RFP, we proposed a solution of building an intelligent field services operation by leveraging Microsoft Power Apps, Flow, Azure SQL and Azure Data Factory. VNB Consulting Services was subsequently chosen as the partner to implement the solution and provide post go live support.

VNB Solution


Integrate Line of Business and EDI

VNB Consulting Services team kicked off the project with discovery of the current business processes and proposed the new mobile friendly architecture. The new field services functionality using Microsoft Power Apps enabled the crew foreman to create new activities, add labor hours, units and materials against activities with ease. Power Apps UI was connected with Azure SQL database backend to store the data collected from field. A sync process using Azure Data Factory was built to sync data between on-premise Dynamics SL ERP and Azure SQL database. The new solution allowed field crews to communicate more effectively with back office and keep customers better informed about the status of their work orders. Microsoft Flow was leveraged to create a robust approval and notification mechanism.

Customer Benefits

  • New Power Apps solution provided a mobile user friendly interface for the crew members resulting in higher productivity.
  • Fully automated solution improved the communication between field crew, back office and end customers resulting in improved customer service

Related Case Studies


Preventive Maintenance Inspection | Model-driven Power App

Preventive Maintenance Company Revolutionized their Service Delivery with a Model-Driven Power Platform App

VNB Consulting helped a preventive maintenance company to develop a cutting-edge system that revolutionized their service delivery…

VIEW DETAILS
Microsoft Dynamics 365 for Business Central | How Fabric helps Business Central customers with Data and Analytics

Roadmap and Strategy for a Power Company to Design and Build a Robust Data & Analytics Platform with Microsoft Fabric

VNB provided a high-level assessment of their ‘As-is’ process and recommended Future State & Strategy for …

VIEW DETAILS