A few weeks back, I was working on a SharePoint Online migration project for a client in the manufacturing space. They had close to 40 department sites, and every single one of them needed the same thing – a document library called “Training Documents” with a fixed set of department folders inside it (HR, Finance, … read more…
A few months ago, I worked with a client who had a SharePoint Online list named Project Tracker that was being fed by a Power Automate flow. Something went wrong with the flow logic one weekend, and by Monday morning, the list had 48,000 junk items sitting in it. The client’s ask was simple: “Can you just empty the list? … read more…
If you’ve been working with SharePoint Framework for a while, you already know that keeping your SPFx version current isn’t just a “nice to have.” It keeps your solutions compatible with the latest SharePoint Online changes, patches security issues, and unlocks new features. But the upgrade process can feel a bit overwhelming if you’re staring … read more…
If you’ve built even one SPFx web part that reads from a SharePoint list, you’ve run into this moment: you fetch the list, get back 500 rows you don’t need, and wonder, “Why can’t I just get the 10 items I actually want?” That’s exactly what this guide covers. I’ll walk you through every practical way to … read more…
A few weeks ago, while working with a client on a SharePoint Online storage cleanup project, I got a very simple-sounding request: “Bijay, can you tell us which document libraries are eating up all our storage?” Sounds easy, right? But when you have 40+ SharePoint sites and hundreds of document libraries, clicking through each site one … read more…
A sales manager opens a monthly performance dashboard and wants to select a quiet day to confirm that no orders arrived. Instead, the Power BI date slicer skips that date completely. It only lists dates where the sales table has rows. I have seen this issue often in client reports built from Excel exports, SharePoint … read more…
A sales manager opens a monthly Power BI report and asks a simple question: “When did this customer first buy from us?” The data comes from Excel files stored in SharePoint, and the report already shows revenue, orders, and product performance. Yet finding the first transaction date correctly becomes difficult once users start filtering by … read more…
If you’ve ever built an SPFx web part and noticed it looks like an uninvited guest — sporting a bright blue palette on a red-themed SharePoint site — you already know why reading the current theme matters. Your web part should blend in, not stick out like a sore thumb. In this tutorial, I’ll walk … read more…
