PowerApps | Fabrikam Utility Billing Center sample app

I just got done with presentations at the yearly Microsoft Dynamics GP Technical Conference in Fargo, ND and had the privilege of delivering a session titled Leveraging your on-premises data with the Power Platform.

During this session I presented a moderately complex sample application that leverages PowerApps AI Builder Form Processing to capture utility bills. These bills are submitted to the Microsoft Dynamics GP ERP application via a call to Microsoft Flow, which then invokes an eConnect API stored procedures to integrate these documents as Accounts Payable invoices.

The Solution

The solution leverages 3 AI Builder forms processing models for 3 distinct utility vendors.

Each model contains 5 form fields, selected during the build process, after training the model with 5 documents.

Each model was published and used to create a PowerApps application - the Fabrikam Utility Billing Center app.

This canvas app, is capable of reading utility bills for each vendor. The document information is stored in a collection and displayed in a gallery for each bill read. The total of all bills read is displayed in summary at the bottom of the gallery.

A button has been added to submit the collection of documents to Microsoft Dynamics GP. In turn, this button executes a Microsoft Flow workflow.

The workflow receives the JSON payload from PowerApps then iterates on the collection to convert the document amount from a string to an actual float value that can be passed into an eConnect API stored procedure, which is invoked via the SQL connector.

All documents are stored in a batch called POWERAPPS in Microsoft Dynamics GP from where they can be reviewed and posted.

An application user can choose to select a specific transaction from the batch and perform additional reviews.

I have a couple videos zooming into some of the techniques I used to create this end to end solution so be sure to watch them and subscribe to my YouTube channel:

For an overview of Microsoft Dynamics GP click here.

To download eConnect and eConnect Programmer's reference guide, click here.

I have added this application, the workflow, the stored procedure wrappers to the eConnect API stored procedures, and the slide deck to my GitHub repository, here.

Until next post!

Mariano Gomez, MVP


Popular posts from this blog

Power Apps - Application Monitoring with Azure Application Insights

DBMS: 12 Microsoft Dynamics GP: 0 error when updating to Microsoft Dynamics GP 2013 R2

eConnect Integration Service for Microsoft Dynamics GP 2010