M365 Show Podcast

The Model-Driven App Lie: Use Teams and SharePoint Instead

Opening: The Great Model-Driven MirageModel-Driven Power Apps. They sound impressive, don’t they? “Enterprise-grade automation,” “secure data modeling,” “governance-ready.” It’s the kind of pitch that gets managers nodding before asking a single question, because it sounds responsible. Serious. Adult. The words alone give off a whiff of engineering gravitas—like wearing a lab coat for clicking buttons in a browser.But the truth? Most Power Platform projects that start with Model-Driven ideals end up drowning in their own ambition. They aren’t building productivity—they’re building infrastructure for the idea of productivity. Professionals fall for it because the vocabulary feels weighty: tables in Dataverse, complex security roles, granular permissions, dashboards that no one checks. It all feels so sophisticated you almost forget you’re recreating a to‑do list with bureaucracy attached.And yet, all you’ve built is a fortress around a spreadsheet.That’s the great Model-Driven mirage. On paper, it promises automation nirvana; in reality, it demands a PhD in Dataverse maintenance. It’s sold as “future-proof IT”—what it delivers is more IT. You didn’t centralize data; you centralized pain.So, let’s dismantle the myth. I’ll show you why Model-Driven Apps overcomplicate problems, why their so‑called scalability is theoretical, and how a Fusion Team—your existing people using Teams, SharePoint Lists, and Power Automate—accomplishes the same goal in half the time and a tenth of the stress.And before we’re done, I’ll reveal the single configuration that silently cripples most Model‑Driven deployments. Yes, it’s something your admin probably enabled “for security.”Take a breath. Now let’s begin.Section 1: The Dataverse DelusionHere’s the part Microsoft’s marketing politely whispers in small print: Model‑Driven Apps can’t exist without Dataverse. No Dataverse, no app. That dependency isn’t optional—it’s structural. The so‑called “data backbone” is less a spine and more an anchor. You start craving enterprise-grade capability, but what you actually install is a commitment trap.Building your data model sounds simple at first. “Create your tables, relationships, and forms.” Until you realize you’ve entered an infinite loop of entity definitions, lookups, and column‑level security. Every element of Dataverse demands configuration. You’re not innovating—you’re babysitting.And that’s before you touch security roles, those baroque permission matrices designed to ensure that no one, including you, ever edits a record again. It’s enterprise‑grade, all right: enterprise‑grade babysitting. A single missing privilege can break a form in ways that defy human logic. Congratulations, you just spent three hours troubleshooting a checkbox.Compare Dataverse setup to assembling IKEA furniture—except every Allen wrench is premium, every screw is billed monthly, and halfway through, the manual changes names. You wanted automation; you got assembly instructions written by finance.Then there’s licensing. Dataverse isn’t included with your warm enthusiasm for Power Apps. You’re paying for environments, storage, and user access. Each environment—development, test, production—needs its own allocation, often with separate governance and backup schedules. You thought you were saving time by going low‑code. Instead, you’re budgeting like a CFO on performance review day.Governance? Delightful. Every column, every relationship, every form, every permission—each must align with your organization’s security posture. One misconfigured field and suddenly your Model‑Driven App throws eternal “record not found” errors. And no, the record isn’t missing. It’s sitting right there, sulking behind a mis‑scoped business unit.People love to call Dataverse a “platform.” I call it an ecosystem of dependencies. It’s built for people designing ERP‑level systems—procurement pipelines, compliance auditing, large‑scale resource management. It’s not built for teams that just want to track project tasks or automate an approval. For that, Dataverse is the equivalent of using an aircraft carrier to deliver a pizza.But I’ll be fair: Dataverse is powerful. The problem isn’t that it can’t handle your data; it’s that it always assumes you’ll have ten times more of it later. It’s built to scale—but you pay the tax of that scalability whether you need it or not. It’s like installing an industrial freezer to keep one sandwich fresh.Most organizations don’t need a database that enforces referential integrity across six environments. They need something that lets a project coordinator update status without calling IT for permissions. Dataverse makes that feel like an act of rebellion.So yes, Dataverse is the mansion. It has wings, corridors, servant quarters, and impressive architecture. But most business workflows? They just need a well‑built apartment—roomy enough to get work done, simple enough that anyone can find the light switch.That’s where we transition from the fantasy of constructing digital cathedrals to the pragmatic reality of collaboration. Because when real productivity matters, you stop buying chandeliers and start installing door handles that actually open.Section 2: The Complexity TaxLet’s talk about the hidden tax no one budgets for: complexity. Model‑Driven Apps excel at producing it. They arrive wrapped in corporate respectability—structured forms, standardized views, cohesive user interface—and then quietly invoice you for every change request. The interface may look stable, but it’s stability the way concrete is stable: once it’s poured, you’ll need heavy equipment to move anything.You start with a simple goal: capture project updates. The Model‑Driven approach insists on defining entities, relationships, and view columns before you even enter the first record. Need an extra field? Prepare to update your table, adjust the form, reapply permissions, republish the solution, and notify governance that your audacious creativity has altered the schema. You thought you were running a workflow; turns out you’re now a part‑time database administrator.And the user experience? Rigid. Every form looks like it was designed in the early 201s and frozen in amber. Buttons land where they want, not where users expect. Conditional formatting? Minimal. Visual polish? None. It’s utilitarian to the point of cruelty. Your colleagues open the app once, admire its bureaucratic confidence, and then continue tracking everything in Excel—because at least there, they can color‑code progress without submitting a change request to IT.Here’s the real bottleneck: governance latency. In a Model‑Driven ecosystem, every modification travels through committees. Each committee reviews alignment with “solution lifecycle practices,” which is corporate language for please wait indefinitely while we debate risk posture. By the time your request clears, the business need has evolved. Congratulations—you’re launching last quarter’s requirements tomorrow.And yet, teams rarely abandon the platform mid‑stream. That’s the sunk‑cost trap. They’ve already spent months constructing the schema, so quitting feels like heresy. They redefine the work as “strategic investment” instead of “ongoing ordeal.” The more time and money poured in, the harder it becomes to admit the obvious: the problem wasn’t the team—it was the architecture.Let me give you a real example. A client once asked for a simple request tracker—two lists, three approval steps. In their zeal for best practices, IT insisted on making it “robust.” Out came Dataverse, cascading relationships, and role‑based dashboards. Six months later, they proudly unveiled a tool so intricate it could manage global customer pipelines. Only nobody needed that. The original business unit refused to use it; they built a SharePoint list instead and finished during the testing phase of the other project. They wanted SharePoint-level simplicity and got SAP‑level bureaucracy.Complexity always feels important while you’re building it. It flatters the builder—every decision seems consequential. But once maintenance season arrives, the flattery evaporates, replaced by tickets and training calls. That’s the tax: every tiny change costs exponentially more because the structure forbids spontaneity.Now, if you’re wondering how to build that same capability faster, cheaper, and in apps your users actually open voluntarily, excellent instinct. You’re ready to leave the Model‑Driven estate behind and walk into the neighborhood where collaboration actually happens. And that’s exactly where our next section leads—into the world of Fusion Teams, where productivity got tired of pretending to be infrastructure.Section 3: Enter the Fusion TeamEnter the Fusion Team—the antidote to architectural vanity. This isn’t a new app type. It’s a philosophy: build where your users already live, automate what matters, and stop mistaking data for destiny. Fusion Teams are what happen when business people and makers stop waiting for IT’s permission to be efficient. It’s democratic computing: the union of those who understand the problem with those who can drag‑and‑drop the solution.A Fusion Team uses what Microsoft already handed you: Teams, SharePoint Lists, and Power Automate—with a light dusting of Power Apps or Power BI if required. Think of it as Dataverse Lite assembled from tools everyone already opens before the morning coffee. You’re not forcing anyone to “launch their enterprise app” because the workspace is Teams. The data lives in SharePoint Lists; the automation hums quietly in the background. It’s automation that behaves like wallpaper—useful, invisible, ignored until it stops working.Here’s t