Bijay Kumar 
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 >>>
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 >>>
Learn how to automatically create a SharePoint Online list and all its columns from an Excel file using Power Automate—without using any Premium connectors.
📅 4th AUG 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…