Thank your for choosing Power Platform Community.
This is a fantastic and thoughtfully scoped challenge—your architectural instincts are clearly sharp. Given the scale, complexity, and UI/UX expectations, a hybrid approach using Model-Driven Apps (MDA) with embedded Canvas pages or custom pages seems like the most strategic path forward.
Here’s how the trade-offs stack up:
🔷 Model-Driven Strengths
Data integrity & scalability: With 200+ Dataverse tables and complex relationships, MDA’s data-first architecture ensures consistency and performance.
Security: Role-based access control and field-level security are native strengths.
ALM & governance: Easier to manage in enterprise environments with built-in support for solutions and environments.
🔶 Canvas App Advantages
UI/UX flexibility: Ideal for crafting pixel-perfect, bilingual interfaces and tailoring experiences for different user personas.
Custom logic: Power Fx and connectors allow for rich interactivity and integration with SAP and third-party APIs.
🌐 Why Hybrid?
Custom Pages in MDA: These allow you to embed Canvas-like experiences directly into Model-Driven Apps, offering the best of both worlds—structured data handling with flexible UI where it matters most.
Performance: You avoid overloading Canvas with large datasets and complex relationships, which can degrade performance at scale.
Maintainability: You can isolate Canvas pages for specific tasks (e.g., onboarding, dashboards) while keeping core processes in MDA.
If this fixes the issue, please mark as resolved to help others with find it.
Happy to help
Robu1
SuperUser| Moderator
