The Inventory Problem Before Any M365 Reorganization: Why You Don’t Actually Know What You Have

6 min read

The Inventory Problem Before Any M365 Reorganization: Why You Don’t Actually Know What You Have

It’s Monday, 9:04 AM. Leadership just announced a business unit reorganization, and your inbox has a calendar invite titled “M365 Tenant Restructure – Kickoff.” You have six weeks. You open a blank spreadsheet, type “Inventory” at the top, and immediately realize you have no idea where to start – because Microsoft never gave you one.

If that scene feels familiar, you’re not behind. You’re standing exactly where every M365 admin and governance lead stands at the start of a reorg: in front of a tenant you technically own but don’t fully see.Why This Is Harder Than It Should Be

M365 didn’t grow as one product. It grew workload by workload – SharePoint, then Groups, Teams, Power Platform, Planner, and Power BI and each workload kept its own admin surface. The cross-workload glue (which Team is backed by which Group, which Group owns which SharePoint site, which Power Automate flow points at which list) lives in Microsoft Graph, but only if you compose it yourself across multiple endpoints.

That’s why same-tenant reorganization inventory is structurally different from an M&A migration. In an M&A, you’re moving between tenants and the boundary is clean. In a reorg, you’re rewiring relationships inside a single tenant, and every undocumented dependency becomes a landmine.

The honest consequence: reorganization scope is consistently underestimated, and dependencies discovered mid-project create scope creep, timeline risk, and escalation calls nobody enjoys.

Pain Point 1: There Is No Single Pane of Glass

Microsoft does not provide a tenant-wide inventory tool that enumerates Groups, Teams, SharePoint sites, OneDrive accounts, Planner plans, Power Automate flows, Power Apps, Power BI workspaces, sensitivity labels, retention policies, Conditional Access policies, and the cross-references between them.

The native tool gap is real:

  • Microsoft Lighthouse is positioned for MSPs managing multiple tenants
  • The Microsoft 365 admin center reports are workload-scoped (one workload at a time)
  • PnP PowerShell only works if you’re prepared to write and maintain custom scripts

What admins actually do: PnP PowerShell with custom Graph API queries to compose cross-workload inventory, third-party assessment tools like Apps4.Pro Migration Manager, and SharePoint Advanced Management (SAM) for Copilot-readiness specifically.

This problem shows up at every reorganization initiation. It’s universal.

Pain Point 2: The Shadow Power Platform Iceberg

Three years ago, someone in finance built a Power Automate flow that approves invoices off a SharePoint list. They moved teams. The flow still runs. You don’t know it exists. They’ve forgotten it exists until you reorganize the underlying SharePoint site and payments quietly stop for a week.

This isn’t a one-off. Citizen-developer Power Automate flows, Power Apps, and Power BI assets are tied to specific user identities, SharePoint sites, and connection references. Reorganize the underlying site or Group and these assets break silently.

Root cause: Power Platform’s value proposition is citizen development. The cost is reduced central IT visibility – by design.

What to do before reorg kickoff:

  • Pull a Power Platform admin center inventory across every environment
  • Deploy the Power Platform CoE Starter Kit for ongoing visibility
  • Run PowerShell enumeration of Power Automate flows by SharePoint site reference to map dependencies you’d otherwise discover at 2 AM during cutover

Pain Point 3: The 30–50% You Shouldn’t Be Migrating At All

Tenants are hoarders. Every mature M365 environment accumulates:

  • Orphaned Groups with no owner
  • Abandoned Teams with no activity for 12+ months
  • Stale SharePoint sites with no edits in 18+ months
  • Unowned OneDrive accounts belonging to users past retention

Why does this just sit there? M365 has no built-in lifecycle policy that auto-archives inactive content, and the Groups expiration policy that does exist is opt-in and ignores inactive owners.

The cost is concrete: reorganization scope inflated by 30–50% with content nobody uses, plus storage and licensing costs that keep arriving every month for assets with no business owner.

Steal Microsoft’s internal practice: every container attested every 6 months by a named full-time employee. Combine that with a pre-reorganization audit using SharePoint admin center activity reports, Microsoft Graph queries for Group activity, and PowerShell composite queries and you walk into the reorg with a smaller, cleaner scope.

Pain Point 4: External Sharing Is a Dependency Surface You Can’t See

Every site owner in your tenant has been able to share externally for years – with named guests, anonymous links, or organization-wide links. External sharing is decentralized by design; tenant-wide visibility is an afterthought.

Reorganize a site URL and you don’t just affect your employees. You break access for the customer collaborating in that site, the vendor with a guest account, the auditor who bookmarked an anonymous link. The classic outcome: customer or vendor escalations within days of reorganization completion.

Native tool gap: SharePoint Advanced Management (SAM) provides tenant-wide external sharing reports but only if your organization has Copilot licenses. Outside SAM, you’re aggregating with PowerShell.

A complete external-sharing pre-reorg checklist:

  • Tenant-wide enumeration of all external sharing relationships across SharePoint, OneDrive, and Teams
  • A communication plan for external partners affected by site URL changes
  • Sharing link redirect testing wherever the platform allows it

Native Tools vs. Workarounds vs. Purpose-Built

Need

Native Tool

Gap

Practical Workaround

Tenant-wide inventory

None

No unified view across workloads

PnP PowerShell + Graph composition, or Apps4.Pro Migration Manager 

Multi-tenant view

Microsoft Lighthouse

MSP-focused, not for single-tenant reorg

Skip; not the right tool 

Workload reports

M365 admin center

Workload-scoped only

Manual cross-reference 

Power Platform discovery

Power Platform admin center

Per-environment, no SharePoint cross-ref

CoE Starter Kit + PowerShell 

Stale asset cleanup

Groups expiration policy

Opt-in, ignores inactive owners

Composite Graph/PowerShell + 6-month attestation 

External sharing audit

SharePoint Advanced Management

Requires Copilot licenses

PowerShell aggregation 

Where Apps4.Pro Migration Manager Fits

Every workaround above is real, valid, and works – if you have the PowerShell expertise, the time to maintain custom scripts, and the budget to absorb the weeks of manual stitching that go into a same-tenant reorganization.

Most teams don’t. That’s the gap purpose-built tooling like Apps4.Pro Migration Manager closes – replacing a multi-week composition project with a cross-workload inventory that already understands how Groups, Teams, sites, OneDrives, and Power Platform assets relate to each other.

It’s the difference between starting your reorg with a map and starting it with a flashlight.

Ready to See Your Tenant Clearly Before the Reorg Kickoff?

If you have a reorganization on the horizon – or you suspect your tenant has more shadow dependencies than your last audit revealed – start with a complete inventory, not a blank spreadsheet.

👉 [Book a 30-minute Apps4.Pro tenant discovery session] and walk into your kickoff meeting with a map, not a flashlight.

See all series: Same-Tenant Reorganization Series

Migrate Everything to Microsoft 365

Exchange Online SharePoint Online OneDrive For Business Microsoft Teams Microsoft Planner Viva Engage (Yammer) Microsoft Bookings Microsoft Forms Power Automate Microsoft Power BI Exchange Online SharePoint Online OneDrive For Business Microsoft Teams Microsoft Planner Viva Engage (Yammer) Microsoft Bookings Microsoft Forms Power Automate Microsoft Power BI
  • No Data Loss
  • Zero Downtime
  • ISO-Certified Protection

Start your free 15-days trial today !


4.5 out of 5

Bot Logo

Apps4.Pro Bot

Hey!👋 Ready to make your Microsoft 365 migration journey easier? Tell me what you’re looking.

What gets migrated?
I have a sales question
I'm here for tech support
Learn about Apps4.Pro