M365 Show -  Microsoft 365 Digital Workplace Daily
M365 Show with Mirko Peters - Microsoft 365 Digital Workplace Daily
Modern SharePoint Pages Done Wrong—Are You Guilty?
0:00
-21:22

Modern SharePoint Pages Done Wrong—Are You Guilty?

Your SharePoint page looks modern, but here’s what most admins don’t realize: those default layouts and buttons might be blocking your next workflow breakthrough. It’s not about fancier graphics—it’s about getting the right data, in the right hands, at the right moment.
We’re unpacking the subtle design mistakes that kill productivity, and the advanced fixes that even Microsoft’s templates don’t mention.

Design Traps: Why Most SharePoint Pages Stall Progress

If you’ve worked with SharePoint for more than a week, you’ve probably seen this: a shiny, modern page that promises progress but somehow feels just as clunky as the classic version you replaced. Everything looks cleaner, brighter, and a bit more “Microsofty,” but after the first login, people start drifting away. So why does a platform built to drive collaboration so often leave teams lost, clicking through an endless loop of lists, libraries, and menu bars? The short answer is: just because it’s “modern” on the surface doesn’t mean it actually works for real business needs underneath. Let’s zoom in on how this plays out day to day.

A typical SharePoint journey goes like this. Someone on IT—or maybe even a keen business user—unlocks Modern Pages after years on classic. There’s buzz in the hallway about new templates, better mobile support, and those snappy web parts. Overnight, your intranet homepage turns from a wall of blue links into something that looks like a news portal. Announcements in bright tiles. Hero web parts with cute icon overlays. You get pats on the back for finally making something that “looks like 2024.” But within two months, complaints start. Stats are out of date. No one knows what’s actually urgent. The site’s prettier, but it hasn’t solved anything old SharePoint struggled with—except now it’s hiding it behind gradients and whitespace.

Here’s the real impact that shows up quietly. Productivity tanks. Teams used to go to SharePoint when they needed to see what was happening—now, they open it, don’t see answers or triggers, and bounce out. You’ll hear things like “We put that on the SharePoint,” but then someone follows up with “Did you check the email?” or “Let me just export this to Excel and mail it around.” The site itself sits in the background, collecting project docs nobody opens twice. Real workflows keep happening by email or, worse, in rogue Teams chats nobody can trace later.

Picture a project status page someone set up with a modern list and a calendar. The interface looks fine on desktop, but overdue tasks use the same color as new ones, there’s no way to flag things visually, and you can’t trigger a workflow right from the view. The analytics everyone actually wants—for example, how many tasks have slipped this week, or which team members are overloaded—are buried in a Power BI report that takes three separate clicks to open. Over time, that friction adds up. Instead of one glance to see what’s at risk, someone spends half their Monday piecing together updates from three locations. Nothing about that feels modern.

Now, Microsoft’s own research has called this out. They found users start ignoring SharePoint pages that don’t show actionable items or surface what really matters. If a homepage looks nice but doesn’t let you act—like assigning a task or flagging a delay—people move on. It’s a classic case of design missing the point. Modern layouts try to streamline what you see, but out of the box, they almost always limit what you can actually act on. Most web part templates surface static lists, announcements, or image carousels, but if you try to show live business data or trigger a Power Automate flow somewhere, you hit a wall quickly.

What’s the business cost here? It’s not just grumbling in the halls. Delays creep in because teams aren’t nudged to act at the right time. Missed deadlines happen because someone thought an alert would show up on the homepage, but it didn’t. Every cycle, people revert back to their habits: downloading the latest updates to Excel, forwarding new versions as attachments, building side trackers nobody else can see. The company still pays for SharePoint, but all the collaboration and workflow promises are happening outside the system, in spreadsheets and inboxes.

I’ve seen this first-hand with teams who try to add more “intelligence” to a modern SharePoint page. There was a project office that wanted to keep all their KPIs and task dashboards visible, live, and interactive. They found a JSON template that looked promising and spent a weekend tweaking card layouts and color rules. It looked sharp—for about a day. The moment they tried to surface data from their actual list (like highlight overdue items automatically), the formatting got shaky. Web parts started losing connections. A mobile user complained that half the buttons disappeared on their iPad. No matter what they changed, something always slipped through. The dream of a dynamic dashboard faded, replaced by grumpy emails about why SharePoint “never just works.”

At the heart of this, it’s not about how many web parts you stacked on a page or how modern it looks. The real miss is not using the platform to automate and connect business processes right where work happens. If all you’re doing is making an announcement wall a little prettier, you haven’t gained much. The power comes from letting pages trigger reminders, update records, and pull in fresh data without making users jump between three platforms. So how does a SharePoint site actually cross that line—from pretty brochure to workflow engine? It’s not about more templates, it’s about unlocking the right tools and knowing where those templates hit their limits. Let’s get specific about how admins are flipping that switch and turning static sites into active business hubs.

From Static to Dynamic: Unlocking Power with SPFx Extensions

Most SharePoint admins still think about pages as something you build out with web parts and a few rounds of JSON. But what gets missed almost every time is just how much you can actually unlock with SPFx extensions. I’ve seen countless teams hit a ceiling trying to surface live project updates, automate status flags, or get anything interactive beyond just reading a list. So here’s the question: what if your SharePoint page could act on business processes itself, with one click, no jumping across five apps?

Let’s set the scene. You’ve got a project team moving fast, and suddenly the requirements change mid-sprint. Instead of just showing the team a task list, you want them to be able to flag an urgent issue right there—no waiting for an email, no posting in Teams, just click, assign, and let the system notify the right people. Maybe you’re facing a board that needs a quick rundown of the latest risks, or you have finance managers needing real-time figures surfaced without leaving the homepage. Using only web parts and standard templates, you’re out of luck. You can show or hide content, but as soon as you want to actually trigger something useful, or have the page update in front of the user, the platform falls flat.

And this is usually where someone gets the bright idea to keep “improving” the page by layering on more JSON formatting. It works, until it doesn’t. Sure, you can throw together a clever color-coding scheme or a few icons that appear conditionally, but the moment you need the page to talk back—to run a flow, send an alert, or handle live data without constant refreshes—the design quickly gets brittle. JSON was never meant for business automation. If you try to stretch it to do anything beyond layout tweaks, you’re signing up for maintenance headaches every time Microsoft tweaks the platform.

Let’s get specific. Picture a project dashboard where every task’s status is updating as changes happen in the list. Instead of making users refresh the whole page, or guess when something’s slipped, an SPFx command set can highlight overdue items in red, attach a “Send Teams Alert” button, and update the count of open blockers live as you interact. One click triggers a Power Automate flow, sending that late task straight to the right channel—with context, a link, and a deadline. No copying, no pasting, not even an extra tab. Suddenly, your SharePoint site is running the process, not just logging it.

Here’s something that gets overlooked: most organizations never take advantage of these SPFx extensions. Microsoft MVPs have been recommending them for years. You hear the same advice in every SharePoint community webinar—field customizers and command sets are where the real action happens for digital workplaces. But in practice, IT teams get stuck between “off the shelf” and “too much code,” so progress stalls. End users keep asking for the same features that the platform could deliver, if only someone flipped on an extension instead of fighting layout JSON.

So what exactly are SPFx extensions, and why do they matter? At a high level, these are pieces of code you add to a SharePoint site to change how it behaves—not just how it looks. Field customizers tweak what appears in your lists, letting you swap a boring text field for a chart, a progress bar, or a live badge that updates when someone changes the item. Command sets live inside your list and library toolbars—they add those extra buttons like “Send Alert,” “Assign Reviewer,” or even “Flag as Critical” with custom business logic underneath. Header and footer injectors give you persistent banners, controls, or links across the whole site, not just on a single page. And the kicker? They work together, often letting one action trigger something visible across the whole workspace.

Without these, SharePoint is just another interface for data storage. Users end up clicking through to Outlook for notifications, opening Power BI for reporting, or—yes—exporting data to Excel just to analyze what’s going wrong. All that context gets lost in the handoff. You’ve probably seen it yourself: a status report gets out of sync, or someone misses an overdue task because the alert wasn’t right in front of them.

I’ll show you what this looks like in real life. Imagine opening a list and seeing every overdue task immediately turn red. Next to each one is a new button—”Flag in Teams”—courtesy of a simple SPFx command set. Tap it, and the system kicks off an alert with all the task details, assigns a reminder, and marks the item as escalated for everyone to see. No inboxes, no extra steps, just action—right from inside SharePoint. It’s a basic use of SPFx, but the impact on team accountability is huge. People start depending on SharePoint as the hub for getting things done, not just for storing documents.

The best part? Now your site isn’t just a static list or pretty homepage. It’s an interactive nerve center that notifies, tracks, and responds. That’s the difference between compliance-driven “digital paperwork” and a system that actually supports how people work today. But as you might expect, not all extensions deliver the same results—some are game-changers, others turn into support tickets overnight. So let’s talk about what a solid, future-proof extension actually looks like once you roll it out in the real world.

Building Advanced Layouts: JSON Templates Without Breaking Everything

If you’ve ever thought JSON formatting was the shortcut to slick SharePoint dashboards, you’re not the only one. On the surface, Microsoft’s page templates look like a blank slate for creative layouts—columns, conditional color rules, icons that show or hide depending on status. It feels like you should be able to build a fully custom command center just by pasting in some JSON, picking a few layout tricks, and letting users have at it. In reality, though, the moment you start building a more advanced page—think multi-section dashboards, nested conditional formatting, or custom grouping—you start noticing the cracks.

Picture this: you’re deep in the SharePoint “Advanced formatting” panel, layering logic for a list view that highlights urgent tasks, shades every other row, and shows a star if a project is over budget. You manage to get something that looks solid in your own browser. But then a coworker checks the same page on a tablet, and half the formatting collapses. The nested sections realign in weird ways, buttons drift to the wrong spots, or web parts load out of order. Someone else reports that a Power App embedded in the page now refuses to load. And nobody can explain why what worked yesterday is now broken after a small Microsoft update.

The reality is, the more ambitious your JSON layout becomes, the more ways there are for it to fail. Modern SharePoint is always evolving behind the scenes—Microsoft rolls out tweaks, adds new column types, or ships a minor interface change—so templates that once felt stable suddenly break or misbehave, especially on mobile or low-resolution screens. There’s no warning when a critical button gets orphaned or a color-coding rule stops applying. Admins often spend hours adjusting little details—pixel nudges, JSON syntax changes, displayOrder re-shuffles—just to keep the original vision intact.

Ask any SharePoint site owner who’s gone “all-in” on JSON, and you’ll hear a familiar story. I watched a team lead pour two days into a dashboard—carefully arranging tiles, adding rollup cards, and setting up buttons to filter their project queue. The next Monday, users started reporting that the “Add New” button was missing on mobile, while others noticed the footer bar floating halfway up the page on Chrome. The workaround? More trial and error, refreshing, and combing through the Microsoft Tech Community for half-documented fixes. The initial excitement of a high-impact dashboard faded fast and got replaced by a steady drip of user complaints.

What’s striking is that Microsoft’s own documentation tends to cover only textbook scenarios: a list with a single column, some background colors, maybe an icon or two. But most business needs venture way beyond that. They involve dynamic web parts, multiple data sources, workflow triggers, and mobile support that holds up on every device. The gap between what gets demoed in a training video and what users demand in the real world is huge.

So, is there a way to push JSON further without setting yourself up for a maintenance nightmare? The answer usually isn’t “more formatting.” The real trick is blending JSON with SPFx field customizers or command sets. For example, you can keep JSON focused on layout basics—column widths, minimal conditional colors, maybe a headline bar—and let SPFx handle anything interactive or tied to updates. If you want a button to trigger a Power Automate flow, don’t try to fake it with a hyperlink and icon in a JSON block. Instead, drop in a custom command or field extension linked to real logic.

There’s a practical rule I try to share: use JSON for what it does well—styling, visibility, and basic layout. The moment you need interaction, automation, or dynamic data from outside SharePoint, it’s time for SPFx. Otherwise, you’ll end up with a page that looks great one week and needs constant tweaks the next.

Let’s look at a real before-and-after example. One team built a dashboard with heavy conditional JSON—icons for every status, color for risk, custom spacing, and even embedded pseudo-buttons. It held up on desktop, barely, but new hires on tablets complained about glitches, and every minor Microsoft update broke something—colors, buttons, or even entire card layouts. Eventually, they rebuilt the core layout using simple JSON for the basics, but shifted every button and alert to SPFx extensions. Overnight, the same dashboard ran smoother, updates shipped without breaking views, and mobile glitches disappeared. The time they once spent on frantic fixes got repurposed into building new features.

At the end of the day, knowing where JSON’s power stops—and when to call in SPFx—is what keeps your SharePoint hub from turning fragile. It's not about which format is “better.” It’s about longevity and letting each tool handle what it does best. Push JSON too far and you’re on call every time Microsoft tweaks a web part. Strike the balance and you avoid creating layouts that eat up more support hours than they save.

But dashboards and layouts are only half the story. Many teams hit another wall when they try to pull in live data from outside SharePoint, automate task flags, or sync status with a third-party system. That’s where the conversation turns to integrations and real-time automations, not just layout.

Integrating and Automating: Real-Time Data, Task Flagging, and External Sources

If you walk through most SharePoint sites, there’s a familiar pattern: you see news posts, document libraries, and web parts laid out in tidy rows, but the pulse of the business is always a step behind. A project manager checks in and sees project lists, but if they look for which tasks dragged past deadline this week or want live sales analytics, they start clicking off to a separate dashboard or waiting for the Excel export to finish. It’s odd how often real action points just don’t show up—even on modern pages packed with features. We’ve all heard “SharePoint can do that,” but what’s actually possible now, and why do so many sites end up missing the mark?

Let’s picture this with a real scenario. You run a busy project team. The task tracker sits in SharePoint—every task, assignee, status, and due date lined up. It’s well-organized, but when a deadline slips, nothing just happens. The task sits there, bold font or no, waiting for someone to notice before a client update goes sideways. If you want an alert to pop up in Teams or show overdue flags in real time, the usual answer is a workaround: extra lists, manual refresh, or gluing charts together in Power BI. Most users develop a muscle memory for this—they scan SharePoint for static info, then switch to Outlook or Teams to actually move work forward.

It’s not that SharePoint can’t do live flagging and automation. The default experience just leaves most organizations in the shallow end. JSON formatting can make a late task turn red, but it can’t notify the team, or escalate the item, or show you changing numbers as work gets done. You end up with pretty status icons, but they don’t drive outcomes. It’s frustrating because users expect better. If TikTok and Outlook can surface real-time updates, surely a business portal should be able to do the same.

Here’s where things start getting interesting. SPFx field customizers and command sets finally break the “static list” pattern. With the right extension, you’re not limited to changing colors or adding a tooltip. You can actually trigger next steps—think launching a Power Automate flow, hitting an internal API, or even posting a message to Teams from a SharePoint page with a single click. For example, a well-built list view command set lets a manager flag overdue tasks as “critical.” One tap, and the task not only changes color in the view but instantly dispatches a custom Teams alert, complete with task details and a deep link back to the list. Suddenly, SharePoint isn’t just a digital noticeboard—it’s acting as a workflow nerve center.

Now, this is where real business value comes in. When you pair SharePoint with the Power Platform, Azure Functions, or even custom APIs, you start unlocking integrations that go beyond what’s possible straight out of the box. Power Automate flows can respond to task changes, trigger reminders, or route escalations through Teams, Outlook, or SMS. Azure Functions let you tap into more advanced logic or external systems—like pulling in financial data, updating inventory, or syncing with a partner’s project plan. REST APIs open doors to third-party data sources, from CRM tools to industry-specific applications. The point is, SharePoint doesn’t need to silo information anymore. It can reach out, interact, and reflect changes from platforms outside its own ecosystem.

Let’s see how this plays out visually. Imagine a project dashboard front and center on your SharePoint home. Task stats update as items change—no refresh needed. If inventory drops below a threshold in your ERP system, a colored indicator flips from green to yellow in real time. Active risks or compliance warnings appear for managers, right on the same portal where documents live. Links trigger flows, show pop-ups with live numbers, or pull summary reports without anyone leaving the page. This is miles ahead of the usual “download to Excel, make a chart, then upload it again” cycle.

Of course, adding this level of integration comes with its own set of watch points. Security matters. When you connect SharePoint to external APIs or introduce automated flows, you’re opening up new points of risk—permissions, data exposure, and organizational compliance all need checks and balances. Throttling is another headache; API calls made on every item render or too many Power Automate triggers can run you into Microsoft’s service limits pretty quickly, especially if you’re not caching results. Then there’s update risk—Microsoft changes things under the hood, and a hardcoded API endpoint or permissioned flow can break quietly, leading to silent failures or nagging user complaints. It pays to document dependencies and test every scenario, especially those corner cases where custom integrations might fail.

But done right, SharePoint becomes a real workflow hub. You get actual triggers, live data, and context right where the work happens. Sites stop being graveyards for documents and old news, and instead become places users go to actually get things moving—assign, flag, escalate, and review, without needing another platform in the mix.

So as more teams look at these integrations, it’s worth thinking about how all this plays into business processes and bottom-line results. Automated alerts and real-time data don’t just make life easier—they reduce errors, catch risks faster, and keep everyone moving with less handholding and repetition.

Conclusion

Most SharePoint sites look sharp but stay stuck showing static lists because no one pushes beyond the defaults. If you’re still sending reminders manually or exporting data just to see what changed, you’re missing what these pages can really deliver. Turning SharePoint into a true workflow hub is about knowing when to hand things off—from styling with JSON to real automation with SPFx and Power Platform. Every manual step you cut saves time, reduces errors, and keeps your team focused where it matters. Subscribe for practical M365 fixes, and drop your biggest SharePoint frustration in the comments.

Discussion about this episode

User's avatar