A sales manager often starts with a familiar problem: several Excel files, a SharePoint list, and no quick way to see monthly sales, top products, or low-performing regions. I have worked with teams that spent hours combining files and updating summary tables before every review meeting. That process changes quickly when you create a report … read more…
I’ve been building Power Apps since the days when you had to explain to people what a “canvas app” even was. Over the years, I’ve shipped apps for HR onboarding, field inspections, asset tracking, approval workflows, and more inventory systems than I care to count — for teams of five people and for organizations with … read more…
A sales manager opens a monthly performance report and sees regions, products, stores, and salespeople listed as large filter panels across the page. The report works, but the top half looks crowded. I have seen this often when teams move Excel reports into Power BI and want the same filtering control without sacrificing valuable dashboard … read more…
Three functions, one job that sounds identical: find records. That is exactly why new Power Apps makers pick the wrong one, and then spend an afternoon wondering why the gallery is empty or why the delegation warning refuses to go away. I have lost count of how many Power Apps apps I have opened where … read more…
Whenever I need to test list view thresholds, indexing, filtering, or performance in SharePoint Online, the first thing I need is a list with a lot of data in it. And by “a lot”, I mean more than 5,000 items, because that is the magic number where SharePoint starts behaving differently. In this tutorial, I … read more…
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…
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