Migrated an Excel Online-based workflow to a Canvas App for a fashion business. The app manages the full custom tailoring order flow, including measurement updates, order details, and accessory sourcing from suppliers, while supporting multi-department usage in one system.
Digitizing Bespoke Fashion: How We Built Knatchbull’s End-to-End Order & Sourcing App
Overview
The challenges
Concurrent department usage: Multiple departments use the app at the same time, requiring inline editing and clear data ownership.
Live shopify–dataverse sync: Shopify data needs to sync continuously into Dataverse to keep order information up to date.
Large excel logic migration: The original Excel system contains many columns, formulas, and linked data fields that need to be rebuilt in the Canvas App.
Cross-department business logic: Order processing logic spans across sales, tailoring, sourcing, and operations, requiring careful workflow mapping.
The solutions
Used Power Fx to rebuild existing Excel formulas inside the Canvas App.
Used Collections to reduce loading time and improve the user experience.
Built Power Automate flows to sync Shopify data into Dataverse continuously.
Used Power Query to clean and transform raw Excel data before loading it into the app.
Tech stack
Have a similar challenge?.
Our team is ready to scope your project and share how we’d approach it.

