Bijay Kumar 
If you’ve built a SharePoint Framework web part that displays list data, sooner or later someone’s going to ask: “Can I download this as an Excel file?” The answer is yes — and it’s actually not that hard once you know which libraries to use and how to wire them together. In this tutorial, I’ll walk … read more…
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 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…
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…
If you’ve been building SharePoint Framework web parts for a while, you know one thing users always ask for: a clean drag-and-drop file upload experience. The default SharePoint upload UI works fine, but when you’re building a custom web part, you want full control. You want users to drop files onto a zone, see them … read more…
When you build a sales dashboard in Power BI Desktop for a retail company, one of the most common requests from a sales manager is: “Show me the latest order date and the highest sales amount by month on one screen.” They want a quick way to see the top numbers without scrolling through tables … read more…
If your team stores documents in email threads, desktop folders, Teams chats, and personal OneDrive accounts, finding the latest file quickly becomes frustrating. I have seen this happen often with HR teams managing policies, finance teams handling invoices, and project teams sharing plans. That is where SharePoint Online helps. It gives your organization one structured … read more…
A sales manager looking at monthly performance in Power BI usually wants simple answers: “How did we do this month?”, “Are we growing vs last year?”, “What are the top 5 regions this quarter?”. The problem is, if your model doesn’t have a proper Calendar table, your time-based analysis quickly becomes messy and unreliable. In … read more…
A sales manager opens a regional performance dashboard before the weekly review. The Region slicer lists East, North, South, and West in alphabetical order. That works, but it hides the story: West generated the highest sales this month, while East needs immediate attention. I have run into this situation often when converting Excel reports into … read more…
Enroll now and get access to all 9 academy courses at no extra cost.
Secure your seat before the batch fills up.
Get the live training plus the complete SPGuides.Academy learning library.
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Learn how to build an invoice management system using SharePoint integration and a repeating table.
📅 2nd September 2026 – 10:00 AM EST | 7:30 PM IST
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App