The Ask
A supplier of renewable fuel contacted us with a requirement for a system that would automate their procedures for overseeing the transfer of various materials stored in piles between their internal and external locations.
The Challenge
They previously had an outdated integration that demanded significant effort to sustain and only met some of their needs. Our objective was to substitute the current integration with Power Automate, enhancing its efficiency and ease of maintenance while also incorporating extra features to fulfil their requirements. This project also revealed several additional potential scenarios that had not been previously recognized; thus, it was crucial for us to adjust the project during the development phase to guarantee that the final product was suitable for its intended use.
The Solution
In the absence of a UX designer, we successfully crafted the application’s visual elements based on our insights into what would best serve both the business and user experience. We created an ER diagram to represent the desired data model, considering the existing model and its integration. Following this, we established the tables in Microsoft Dataverse. We employed Power Apps to design the application’s user interface and Power Automate to connect their existing Dynamics 365 Business Central system with the underlying tables. We then devised a distinct flow to encapsulate the business logic (orchestration) and organized the remaining solution using triggers, functions, and processes.
The Outcome
We successfully replaced the current integration with an upgraded front-end system and automation utilizing the Power Platform. Maintaining effective communication with the client was crucial in understanding their primary pain points, allowing us to deliver more than the originally intended solution within the client’s budget. The client expressed satisfaction with our work, and we are currently in discussions regarding potential enhancements and additional projects to further optimize their systems and processes while continuously providing support for the existing solution.