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


VNB assisted a utilities services company build a PowerApps 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 PowerApps.

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 customers RFP VNB proposed a solution of building an intelligent field services operation by leveraging Microsoft PowerApps, 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

VNB 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 PowerApps enabled the crew foreman to create new activities, add labor hours, units and materials against activities with ease. PowerApps 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 PowerApps 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


Custom Solid Wood Door Manufacturer Automate Order Intake Process using PowerApps and PowerAutomate RPA

VNB assisted a Customer Solid Wood Door Manufacturer Automate Order Intake and Measurement Details Process leveraging Microsoft PowerApps and PowerAutomate RPA


Urology Healthcare Provider Implements Bed List PowerApps to Streamline Patients Admissions and Care

VNB assisted an Urology Healthcare Provider develop and deploy a PowerApps solution integrated with Athena Practice EHR via FHIR APIs to manage patient admissions and care