Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 0b1qxvy14URn3W6WFfUcua
Power Apps - Microsoft Dataverse
Unanswered

Model Driven Apps vs Power Apps

Like (0) ShareShare
ReportReport
Posted on 13 Oct 2023 18:24:08 by 251

I have been experimenting with Dataverse building a Model Driven app in a Dataverse solution. It seems like a very complicated environment wrought with booby traps, so to speak, for developers without IT and software engineering backgrounds, which I don't possess. I also noticed sharing a Model Driven app includes providing access to the entire design backend to users. This confused my users, not to mention them having the ability to wreck my objects in my solution, which is why I am extremely hesitant to use Model Driven apps. On the other hand, they seem comfortable to using Power Apps forms, which I built from SharePoint lists and Access forms I developed using Dataverse tables as the data sources. I guess by question is this: which is better user-friendly experience and faster choice for development and deployment, Model Driven Apps, Power Apps or Access? 

Categories:
  • Tal22 Profile Picture
    251 on 16 Oct 2023 at 17:11:51
    Re: Model Driven Apps vs Power Apps

    I am not interested in anybody "easily" showing me why I can add columns in some tables and not others when this is not an issue with the other applications I mentioned? It is not like I packaged my tables and imported as a managed environment. In developmental stages, there should be no reason for these types of barriers. Is this technically a flaw with the platform? Technically, I suppose not.  But is it a flaw in user design? Definitely! 

     

    According to a report published by AIIM two-thirds of the organizations using SharePoint says that the major cause of low adoption rate includes inadequate user training and complexity in using the platform. (Translate, busy people don't have weeks, if not months to learn the platform) With Dataverse and Power Apps being even more complicated, it is no wonder that there is very low user adoption. And so, one has to ask, giving the low adoption rate, is this platform a true productivity tool?  No. It is not because it fails to meet the needs of users via good UI and UX. And this renders Power Platform, along with SharePoint, flawed technology. 

     

    As a dominant monopoly, Microsoft focuses on large organizations employing folks like you. Not small org's with folks like me. Despite their no code, low code claim, the twisted, complexity to navigate the platform shows there is little consideration for "Citizen Developers" by Microsoft. 

     

    I really wish you tech folks would understand this. Instead, you reward bad technology be being totally oblivious to the idea that that good tech should be easier to use.

     

    Being user friendly is why Apple is so successful. They make intuitive technology with great user experience in mind. Could you imagine if Microsoft made a "smart" phone?  I can't. Not with Microsoft's history of making simple complicated. 

     

    In the not-too-distant future, this will all be a moot point when AI renders developers and platforms like this obsolete. On that note, I'm betting Microsoft will make Co-Pilot another annoying product too complicated to use. 

  • Michael E. Gernaey Profile Picture
    42,027 Super User 2025 Season 1 on 15 Oct 2023 at 18:17:15
    Re: Model Driven Apps vs Power Apps

    @Tal22 

     

    Unfortunately, you drank the "I hate MS coolaide" and blame your lack of understanding.

     

    So I wont waste my time explaining the easily understood reasons why you can in some or the other, because I am sure you drang some "education" coolaide too 🙂

  • Tal22 Profile Picture
    251 on 15 Oct 2023 at 17:18:59
    Re: Model Driven Apps vs Power Apps

    Generic words? What language should I speak in? Tech laden, computerese jargon?  

     

    I did take a few classes. I get most of it. What I don't get is why I am unable to add a column to an existing table. I can easily do this in Excel, Access, SharePoint Lists and a few non-Microsoft cloud apps. Yes, I can add columns to a few of my tables, but I am unable to modify others. I find this extremely bizarre. That said, I guess I don't know the limitations and quarks of Dataverse. Quarks like not being able to modify some tables, while being able to modify others. Easily adding a column should not be a challenge. But I guess there is some backend, permissions / admin center function that I must learn to navigate. Which means, as the app developer, I have to give myself particular rights to modify tables that I created in the first place? 

     

    It is these types of inconsistencies that makes it frustrating to develop in Dataverse. And, can you admit, that it is incredibly clunky requiring 10-15 more clicks than SharePoint lists, or any other well-designed application, to navigate?  Is this platform not extremely unintuitive and way to complex then is should be? 

     

    Dataverse, Model Driven apps, accessing and establishing security roles - pretzel logic for folks like me who don't have decades of experience with Azure, D365, O365, and more.

     

    What I take exception to is those who say, "learn the platform". I easily learned Access precisely because the UI is logical, well organized and fairly easy to navigate. I previously built a cloud based, collaborative apps and database solutions using Kintone in less than a month precisely because it is a highly productive, low code, no code, intuitive WYSIWYG HpaPaaS designed for rapid development. And so, just precisely what do I need to learn to add a column to a table that I previously created and customized with added columns?

     

    Unfortunately, my organization drank the MS cool aid and bought into the MS BS that this was a user-friendly platform for citizen developers. It is anything but. I work with Millennials and Gen Z, supposed digital natives who look at Dataverse and Power Apps proclaim, "WTF"?  

     

    This is what I am calling it now. A WTF experience. 

     

  • Michael E. Gernaey Profile Picture
    42,027 Super User 2025 Season 1 on 14 Oct 2023 at 16:01:46
    Re: Model Driven Apps vs Power Apps

    Hi @Tal22 

     

    unfortunately thats just all generic words, its just clear you dont know how to use it, which is fine, but it doesnt mean its the platforms fault.

     

    I do wish you luck. I suggest you guys take some classes

  • Tal22 Profile Picture
    251 on 14 Oct 2023 at 14:57:50
    Re: Model Driven Apps vs Power Apps

    I built a test Model app and have gotten the "something went wrong" or other error messages when trying to use the visualize tool and exporting. I did assign roles but that didn't work either. Users can still see and access the objects. Also, I cannot add columns to an existing table. I don't encounter these issues developing in Access. An Access DB can be distributed as encrypted front-end file that locks users out of seeing and accessing objects. Configuring is simple to do so. Access also can add columns (fields) to an existing table. From this perspective the best practice to create tables is to do so in Access and then export into Dataverse. However, I cannot find a way to export Access tables into a Dataverse solution. But I am not sure if doing so is necessary. In the meantime, there might be a licensing issue or a bug on my company's 365 account. All my users supposedly have a Power App license, but it is hard to decipher the myriad licensing levels. I am hoping my IT person can resolve this, but they do not know how Dataverse works. 

  • Michael E. Gernaey Profile Picture
    42,027 Super User 2025 Season 1 on 13 Oct 2023 at 18:57:04
    Re: Model Driven Apps vs Power Apps

    Hi @Tal22 

     

    Just to clarify, what you said isn't true and its just lack of knowledge.

     

    You are not opening up your objects or backends to the users, nor the solutions. Locking this stuff down leverages Role based security that you configure. If you configure it wrong sure you can do anything, but the App itself, whether you build a Canvas App or Model driven its all the same.

     

    There isn't a specific answer to your question because its hard to articulate since you do not have experience. Thats not a knock, but imagine you have never driven a car before and do not understand terms.

     

    What's better my Volvo or my Porsche. They both drive, they both get me there, what is really the difference that a newbie cares about /shrug who knows.

     

    Canvas Apps are great for building business focused apps that aren't required to be modeled based on the Data itself.

     

    Model driven apps are great because they have loads of features like automatic form building (based on the data model), search and a zillion other low code things.

     

    Funny enough some people prefer MDApps versus CApps, even when IMHO it made no sense.

     

    Who will share you, who is the audience, what features do they need as it relates to the DATA, not the feature or function you app provides.

     

    Its much easier to write apps that jack up the data using Canvas Apps, then it is Model Driven. Model drive are, in some ways, may seem harder if you do not understand all the low code capabilities in them etc, so it would seem like hey let me make this easy simple custom UI (Cavnas App) and im golden /shrug, personal preference in many cases.


    If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started