Bijay Kumar 
I ran into this problem the first time I built an inventory flow for a client who ran a small distribution business. Their Excel Online (Business) table stored every quantity as a decimal, even whole units like 24 came through as 24.0, because Excel treats every number as a floating-point value internally. The client’s SharePoint … Read more >>>
A few months ago, I worked on an HR leave request Canvas app where the team kept asking the same question: “Why does the date show 12:00 AM everywhere?” The app saved leave dates correctly to a SharePoint list, but the screens looked messy because users only cared about the date, not the time. This … Read more >>>
You build a flow, pull some data from a SharePoint list or Excel file, and everything looks fine… until you try to add two numbers and your result is 1020 instead of 30. The value is coming in as a string (text), not a number, and suddenly your calculations, conditions, and approvals start behaving in … Read more >>>
You have a sales tracker in your app, but the records are just one long list. When your manager asks for total sales by region, open deals by rep, or order counts by status, scrolling through raw rows does not help. That is exactly where the Power Apps GroupBy Function helps. It lets you group … Read more >>>
Need each employee to see only their own records in your Power Apps app? That is a common setup in HR, service, and operations apps, and Power Apps makes it possible by using the signed-in user details from User() and matching them to your data. A simple business example is an Employee Asset Requests app. … Read more >>>
If you’ve ever needed to pull items from a SharePoint list that fall within a specific date range — say, all support tickets opened between January 1 and March 31 — you’ve probably hit a wall trying to figure out the right syntax. Date filtering in SharePoint is one of those things that looks simple … Read more >>>
If you’ve ever built an SPFx web part and needed users to pick something from a SharePoint list, like a department, a project, or a product category, you already know the challenge. Hard-coding options in a dropdown is a quick hack that breaks the moment the list changes. What you really want is a live … Read more >>>
Recently, I was building an SPFx Quiz Application web part using React. In this application, users can attempt a quiz and receive their results through email after submission. To send emails, I used Microsoft Graph’s /me/sendMail endpoint through MSGraphClientV3. This endpoint requires the Mail.Send delegated permission. Everything was working perfectly when internal users submitted the … Read more >>>
Is your SharePoint list full of dates and hard to understand at a glance? When everything appears as rows of data, it becomes difficult to track deadlines, project timelines, events, or schedules. The good news is that SharePoint has a Calendar View that can turn those rows into a simple calendar layout. Instead of scrolling … Read more >>>
Most Power BI dashboards fail for a surprisingly simple reason — not because the data is wrong, but because they were built without a clear audience in mind. I’ve seen dashboards with 30 visuals on one page that told no story at all, and I’ve seen a single-page dashboard with 5 KPIs that helped 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…