SharePoint Cleanup Strategy: The Blob Storage Fix for Hoarding and Bad Search

(00:00:00) SharePoint's Confidence Illusion (00:00:14) The Relevance Problem in SharePoint (00:00:32) The Dangers of Duplicate Files (00:01:39) Governance Beyond Checkboxes (00:02:46) The Warehouse District Solution (00:06:50) The Permission Puzzle (00:09:24) The Delegated "On Behalf Of" Model (00:12:35) The Three-Step Offload Process (00:19:11) Measuring Success and Scaling Up (00:21:15) Key Takeaways and Call to Action In this episode of M365.fm, Mirko Peters shows how to stop SharePoint from behaving like a digital landfill — without starting a political war over deleting files. If your environment is full of Final_v7 documents, fake “Archive” folders, and confused users opening the wrong version every day, this conversation gives you a concrete, admin‑ and security‑approved pattern: offloading stale drafts and duplicates from SharePoint to Azure Blob Storage with a full audit trail and one‑click restore.WHAT YOU WILL LEARNWhy your SharePoint and Copilot results feel “wrong” even though search and indexing are technically workingHow duplicates, pseudo‑archives, and friendly hoarding distort ranking signals and bury the real canonical documentWhy you don’t have a storage problem — you have a relevance and governance problemHow a simple architecture fixes it: an SPFx ListView Command Set for “Move to Blob,” an Azure Function that copies files server‑to‑server, Azure Blob Storage as the warehouse, and Azure Table Storage as the immutable ledgerWhy delegated auth with On‑Behalf‑Of flow passes security review, and why global application permissions don’tHow to build practical identification rules for duplicates and stale drafts using hashes, last access, edit frequency, and ageHow the move process actually works: copy → hash verify → ledger entry → delete, with SharePoint recycle safetyHow one‑click restore rehydrates files (with metadata) so users stop fearing cleanup and start trusting the systemThe measurable payoff: better search precision, cleaner Copilot answers, lower storage costs, and fewer “Which version is the right one?” argumentsTHE CORE INSIGHTSharePoint doesn’t hurt your users because it runs out of space; it hurts them because it loses signal. When every draft, duplicate, and “just in case” copy lives forever in the same libraries, your ranking signals collapse: search, Copilot, and even manual browsing start returning noise instead of the canonical document. Users stop trusting what they see, so they hoard even more — and the spiral continues.The way out is not a heroic delete project; it is a safe, reversible offload pattern. By moving low‑value drafts and duplicates into a governed Blob archive with a ledger and one‑click restore, you shrink the active surface of SharePoint without deleting history. That instantly improves relevance for search and Copilot, calms storage growth, and gives you a cleanup story that security, compliance, and business owners can all say “yes” to.WHO THIS EPISODE IS FORThis episode is ideal for SharePoint administrators, Microsoft 365 architects, IT leaders, governance and compliance teams, and anyone fighting duplicate content, storage growth, and bad search results in SharePoint. If you’re under pressure to clean up without breaking trust — or to improve Copilot accuracy without “more AI magic” — this episode gives you a step‑by‑step cleanup and offload pattern you can pilot in a single noisy library and scale from there.ABOUT THE HOSTMirko Peters is a Microsoft 365 consultant and digital workplace architect focused on building disciplined, lifecycle‑driven content platforms on the Microsoft cloud. Through M365.fm, Mirko shares practical governance patterns, automation designs, and real‑world cleanup stories that help organizations turn SharePoint from a hoarding problem into a searchable, Copilot‑ready knowledge backbone.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support.