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!

MG.-
Mariano Gomez, MVP