A Microsoft Power Platform solution that automates the complete coffee machine request lifecycle, from employee request submission to approval and fulfillment. The solution uses Power Apps, Dataverse, Power Automate, and Business Process Flows to streamline ordering, approval, and back-office processing.
Developed a responsive Canvas App that enables employees to browse, compare, and request coffee machines.
- Browse coffee machines grouped by machine categories.
- Filter available machines by selecting a category from the navigation panel.
- Compare multiple coffee machines by selecting products and viewing their specifications side by side.
- Review product details such as machine features and properties before selecting.
- Complete a request form by providing employee and location information.
- Submit the selected machine request, which is automatically stored in Microsoft
- Return to the home screen to submit additional machine requests.
Designed and configured Microsoft Dataverse tables to support coffee machine ordering and fulfillment processes.
- Create a Machine Order table to store employee requests, selected machine details, user information, and order status.
- Create a Machine Procurement Process table to support the back-office fulfillment workflow and Business Process Flow stages.
- Configured columns, relationships, forms, and views to organize machine request and procurement data.
- Used Dataverse as the centralized data source connecting the Canvas App, Model- driven App, and Power Automate workflows.
- Implemented structured data management to support request tracking from submission through procurement and completion.
Developed an automated approval workflow to streamline the coffee machine request process.
- Triggered the flow when a machine request is created or updated in the Machine Order Dataverse table.
- Used the Start and wait for an approval action to send approval requests to the designated approver via Outlook.
- Evaluated the approver's response using conditional logic to determine whether the request was Approved or Rejected.
- Updated the corresponding request record in Dataverse with the approval status.
- Automatically send email notifications to the requestor informing them whether their machine request had been approved or rejected.
- Eliminated manual follow-ups by automating the approval and notification process, ensuring timely communication and accurate status tracking.
Developed a Model-driven App for back-office administrators to manage and process coffee machine requests.
-
Displayed all submitted machine requests in a centralized view for efficient request management.
-
Enabled administrators to view detailed information for each machine request.
-
Integrated a Business Process Flow to guide administrators through each stage of the machine procurement and fulfillment process.
-
Allowed administrators to track request progress from initial submission through procurement, setup, and final distribution.
-
Provided a structured interface for managing request statuses and ensuring a consistent fulfillment workflow.
Implemented a Business Process Flow to standardize and guide the coffee machine procurement process from request to delivery.
- Guided administrators through a structured, sequential workflow consisting of
- Required users to complete the necessary information at each stage before progressing to the next, ensuring data completeness and process consistency.
- Enabled end-to-end tracking of each machine request throughout the procurement and distribution lifecycle.
- Improved visibility into request status and ensured a standardized fulfillment process across all machine orders.
- Microsoft Power Apps (Canvas App, Model-driven App)
- Low-Code Application Development