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


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


Retail Electricity and Natural Gas Supply Provider build a Pricing App using React.JS with TypeScript

VNB Consulting assisted a Retail Electricity & Natural Gas Supply Provider to build an app for their …..


Power and Utilities Organization Consolidate Multiple CRMs to Target New Markets

VNB Consulting assisted a Power and Utilities organization to consolidate multiple CRMs into a single Dynamics 365 CE environment