What’s Next?
- An email and phone call from one of our representatives.
- A time & cost estimation.
- A follow up conversation for your feedback and questions.
Customer is a certified competitive retail electricity and natural gas supply provider operating in 27 service territories in six states and Washington, D.C. Supply electricity and natural gas solutions for over 460,000 residential and business customers and take pride in making it easy for customers to buy, manage and use energy. Based in Columbus, Ohio and Chicago, Illinois, the customer is committed to excellence by serving customers with value, innovation and many years of industry experience. Established in 2002, Customer is a wholly owned subsidiary, one of the largest electric utilities in the United States and ranked 185 of the Fortune 500. The Customer was developing an interest in Microsoft Power Apps.
Customer was going through a digital transformation leveraging Microsoft Cloud Platform. Microsoft Power Apps and Power Automate platform was chosen to replace legacy applications within the organization. After a rigorous RFP process, our Business Apps team was chosen to replace its first legacy energy pricing application using Power Apps and Power Automate.
After conducting a detailed assessment of the client’s requirements, our Business Apps team recommended an architecture using Power Apps UI along with Power Automate to integrate with the on-Premise data sources leveraging API’s. The Power Apps UI allowed the users to easily navigate across the Menu bar and access the Pricing Queues and other screens. Additional functionalities included getting data for a specific date range, filter set up for all the columns to sort data as per need, access to historical data, color-coded rows to easily identify different workflow type, tabular view of information, security restrictions to allow users only with required permission to go beyond the landing screen, forecast reviews to determine usage for a certain period of time etc. Power Automate workflows were created to connect to the on-premises API and returns data which would be used by Power Apps application leveraging the Power Apps customer connector and On-Premise Data Gateway. The APIs were built to provide interaction with on premise data sources and contained the business rules and procedures to secure data. Token based authentication was used to generate the list of permission a User would have within the system. The overall solution was built with using reusable custom components and the user journey is a complete workflow as below: - Platform Independent: PowerApps is platform independent and can run on any devices - Low code Development: PowerApps is a low code development model. - Easy deployment and versioning: PowerApps provided its own versioning so no need to integrate with other source control systems. - Export to Excel: Using Power Automate/MS flow we can download the data in excel for from PowerApps.
VNB Consulting helped a preventive maintenance company to develop a cutting-edge system that revolutionized their service delivery…
VIEW DETAILSVNB provided a high-level assessment of their ‘As-is’ process and recommended Future State & Strategy for …
VIEW DETAILS