Bijay Kumar 
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 >>>
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 >>>
You build a simple leave request Canvas app for an HR team. An employee selects a date, but you need to stop them from requesting leave on Saturday or Sunday. Then Power Apps suddenly shows: “Can’t convert this data type. Power Apps can’t convert this Date to a Boolean.” I have seen this issue when … Read more >>>
An HR coordinator opens a new leave request, chooses a temporary manager in the Approver combo box, and then changes their mind. If the app keeps that old selection after they cancel or submit the form, the next request can go to the wrong person. I have seen this small issue create real approval delays … Read more >>>
An HR team managing leave requests often starts with one SharePoint list and a simple Canvas app. At first, everyone can scan the request gallery easily. Then the list grows to hundreds of records, managers want only pending requests, and employees need to find leave entries from their department. I recently built this type of … Read more >>>
A few months ago, I worked on a simple HR leave tracking app for a client who had one problem I see all the time. Their team had clean employee data sitting in Excel, but they wanted to use that data inside a Canvas app without rebuilding everything manually. That is exactly where a Power … 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…