Custom Solid Wood Door Manufacturer Automate Order Intake Process using Power Apps and Power Automate RPA


VNB Consulting assisted a Customer Solid Wood Door Manufacturer Automate Order Intake and Measurement Details Process leveraging Microsoft Power Apps and Power Automate RPA

Customer Profile

Customer is a leading manufacturer of custom solid wood cabinet doors and drawer fronts. Based in Houston, the customer is committed to excellence by serving their clients with value, innovation, and many years of industry experience.

Customer Situation


Customer’s sales team had a requirement to go digital with their order intake process. The current tool/aid for collecting order and measurement details was based on a MS Excel sheet. The customer was looking at a more modern capability to help with Orders intake and processing. The application will be used by their sales and customer service teams to take new orders and help service existing orders, update their client of order delivery status etc.

Our Solution Offering


After reviewing the MS excel workbook used for order capturing, our App and Integration team did a detailed assessment of the client’s end to end requirements relating to their Order processing. Our team recommended a Microsoft Power Apps based solution for the requirement and provided a user-friendly design of the application. The seed data from the excel related to Door and Drawers and distinct parts was collated into a Dataverse based data repository. All door and drawers seed data, Orders along with Customer details is stored in Dataverse too. Customer was using a custom CSV generated from their Excel workbook to import order details into their on-premises existing desktop application SuperDoor which was used to provide estimates and building doors and drawer. The team envisioned, designed, and implemented a Microsoft Power Platform powered Ops platform for the Customer which consists of a Canvas App and a Model Driven App based Administration app. These apps help in Order intake and processing to back end for the Customer sales and customer service teams. Using Power Automate Desktop RPA (Desktop Flow) based automation, these Orders were added into SuperDoor back-end system. The Ops platform has enabled the Customer’s sales and customer service teams to do the following: * Intake Order details, * Enter measurement details along with Door material, parts, and components information. * Generate estimates. * Send customer notifications and SMS * Export Orders into SuperDoor

The solution brought numerous benefits to the client, including but not limited to:

  • The customer solution was powered by Microsoft Power Platform to digitize their Ordering business process. This led to an overall ease of doing business and improved over all satisfaction of the end clients of the Customer. The project can be easily considered a complete Digital Transformation for the Customer’s Ordering business process and now boasts of a low-code modern app, Robotic Process Automation integration with a legacy desktop application and automation for manual tasks including end client notifications.
  • Microsoft PowerApps provides designer view which is extremely easy to understand by business users and operations teams.
  • With adequate training, Power Apps are easier to use, build, maintain and carry out any updates if required.
  • Power Apps based solution is easy to use for the users who are already working with Microsoft 365. They have a good integrated experience on the app along with the other M365 apps in use in the organization.

Related Case Studies


Retail Electricity and Natural Gas Supply Provider build a Pricing App using React.JS with TypeScript

VNB Consulting assisted a Retail Electricity & Natural Gas Supply Provider to build an app for their …..


Power and Utilities Organization Consolidate Multiple CRMs to Target New Markets

VNB Consulting assisted a Power and Utilities organization to consolidate multiple CRMs into a single Dynamics 365 CE environment