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

Overview


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


covid-19 powerapps portal

A Global Merchant Bank Builds COVID-19 Resource Center using PowerApps Portal

VNB assisted a global boutique merchant bank build a resource center for COVID-19 for its internal and external users using PowerApps Portal

VIEW DETAILS
microsoft power automate powerapps for banking

A Global Boutique Merchant Bank Replaces Its Legacy Portal With PowerApps

VNB assisted a global boutique merchant bank replace its legacy custom portal with PowerApps, SharePoint Online and Power Automate

VIEW DETAILS