Best approach: Canvas vs Model-Driven for large-scale, integrated enterprise solution?

(1) Share

Report

Posted on by AamirMehmood

Hi everyone,

I’m currently leading the architecture of a Power Platform solution and would appreciate advice from the community. The app we’re designing has an enterprise-grade scope—with over 200 Dataverse tables, complex relationships, SAP and third-party integrations, and must support a bilingual interface. The user base includes 2,500 internal users, 500 partner users, and around 150 external users.

While we recognize the strengths of both Canvas and Model-Driven apps, the business is particularly focused on a flexible and polished UI/UX, which leans us toward Canvas. However, we are cautious about performance, security, scalability, and development effort at this scale.

Given these constraints, would you recommend a Canvas-only, Model-Driven, or hybrid (MDA + embedded Canvas page) approach? What trade-offs should we consider from your experience?

Thanks in advance for your insights, looking forward to hearing how others have approached similar challenges.

Best regards,

Aamir

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

MS.Ragavendar 6,334 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@AamirMehmood,

Considering this requirement - 200 Dataverse tables, complex relationships, SAP and third-party integrations, and must support a bilingual interface.

With canvas app its possible with this all acceptance criteria.

But if you will load huge no of records to the app which might lead an performance issue.

With respect to UI/UX only canvas can provide better visual.

Canvas App Standards

https://www.matthewdevaney.com/power-apps-coding-standards-for-canvas-apps/

Model Driven Best Practices

https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/best-practices/

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
Erikpgh1 44 on at

Like (0)

Report
Copy link

Link copied!

One of the best vid / blog posts on Security and how to set up

Episode 1/10: Introduction to Dataverse Security

My curated List of Power Apps Vids many are past the basics of Model Driven Apps.

https://youtube.com/playlist?list=PLd1fR1P3_2bWEu2KqjiHn3E5zwvIKWBAu&si=vtsq-ItWiDp5rp9X

Multi Lingual MDA Bing Videos

I went through a similar analysis and the Canvas will get you the pixel perfect, but MDA can quickly get you to the multiple interfaces that you will need with that many tables. My recommendation is to use a Hybrid approach. For a project that I am working on, we started with a Model driven for our dev and that path quickly went to add a hybrid model. There is a lot of good content that can be built in Model driven and augment with a canvas model pages, especially when there is a need for simplification or complex calculations via patching is needed.

As it grows you can also do more development using PFC content in the MDA or canvas models.

Was this reply helpful? Yes No
AamirMehmood 7 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much, Ms.Ragavendar and Erikpgh1, for your input. I truly appreciate it.

I understand that all of this is technically possible within a Canvas App. However, my question is more focused on the feasibility and suitability within the specific context outlined in my original post.

I’d greatly appreciate any additional feedback from others in the community, it would be helpful to have more perspectives on this scenario.

Thank you.

Aamir

Was this reply helpful? Yes No