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

power bi project management dashboard solution vnb consulting

Nonprofit Organization Adds PowerBI To Its Processes To Improve Client Management

VNB assisted a nonprofit organization consolidate data from system such as RealPage, Awards, Azure SQL DB, SharePoint and Excel to build a reporting solution to improve client management.

power bi sales dashboard

Power BI Reporting Solution For Better Insights Into Sales Pipeline

VNB assisted a fitness manufacturer build a PowerBI reporting solution to get better insights into leads, opportunities and sales pipeline.