I recently built an IT helpdesk tracker for a client, and the first version had one screen. A plain Power Apps Gallery showing every open ticket. It worked fine until the list crossed 300 rows. The support team started scrolling forever to find their own tickets. The fix wasn’t a new screen or a fancy … Read more >>>
Every retail or finance report I’ve built eventually hits the same request: “Can you show me total sales by region and product category, together?” A sales manager doesn’t just want one total — they want the numbers broken down by two, sometimes three, columns at once. That’s exactly where grouping and summing by multiple columns … Read more >>>
I still remember the first dashboard I built for a regional sales team. I had slicers stacked on every page, and the report crawled. A senior BI lead on the client side asked me a simple question: “Why aren’t you using filters instead?” That one question changed how I design every report since. If you’re … Read more >>>
I still remember the first time a client asked me to turn their SharePoint sales list into “something they could actually look at.” They had a SharePoint list with 200 rows of order data and an Excel sheet full of regional targets, and nobody could see the story hiding inside either one. That’s the exact … Read more >>>
I once inherited a sales dashboard that pulled data from a colleague’s local Excel file — stored on her personal laptop. The day she went on leave, the report broke. I had to move that data source to a shared SharePoint folder, fast, without rebuilding the entire report from scratch. That’s when I learned every … Read more >>>
In this SPFx tutorial, I’ll show you how to use the GroupedList control inside a SharePoint Framework (SPFx) client-side web part. Two quick notes before we start, because both trip people up when they’re following an older blog post. First, this control used to be called Office UI Fabric React GroupedList. Microsoft renamed the whole … Read more >>>
An HR coordinator opens an employee directory to find everyone who joined during a particular week. Instead of scrolling through hundreds of records, they choose a start date and an end date, and the employee gallery updates immediately. I have built this pattern in many Canvas apps, including HR onboarding apps, leave management trackers, approval … Read more >>>
A blank dropdown selection looks harmless until it creates a bad record in a business app. I have seen this happen in HR apps where a coordinator filters employees by department, leaves the filter empty, and suddenly assumes the gallery has no records. In a recent Canvas app for a 200-employee company, the HR team … Read more >>>
Are you getting the error TS2307: Cannot find module ‘@pnp/sp/presets/all’ or its corresponding type declarations while building a SharePoint Framework (SPFx) web part? This error usually occurs when your SPFx project does not have the required PnPjs package installed, the installed PnPjs version does not match your import syntax, or dependencies were not restored correctly … Read more >>>
An HR team I worked with needed a simple leave request app for 200 employees. Employees had to choose one or more leave types—Annual Leave, Sick Leave, Work From Home, or Compensatory Off—without scrolling through a long form or typing inconsistent values. A Power Apps Listbox worked well for that screen. It gave users a … Read more >>>
Learn how to build an intelligent invoice processing solution using:
Learn how to build a real-world Invoice Management System using a SharePoint Integration Power Apps Form with a repeating table—supporting multiple invoice line items.
📅 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
Download 135 Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…