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 >>>
Imagine your HR team in a 200-employee company using a simple Power Apps Canvas app to manage leave requests stored in a SharePoint list. The app works, but very quickly people start asking for more: “Can I see only my pending requests?”, “Can I filter by department?”, “Can managers quickly see just ‘Approved’ leaves?” Without … Read more >>>
I often see this issue in service desk and inventory apps. A Power Apps Dropdown connected to a SharePoint list shows “IT,” “HR,” and “Finance” several times because multiple records use the same department value. That makes a simple filter look unpolished and forces users to scroll through repeated options. The good news is that … Read more >>>
When I build an HR Leave Request app for a small company, the first complaint is always the same: “Why are employees still typing department, leave type, and manager name manually?” Misspellings, inconsistent values, and messy reports soon follow. The fix is simple but powerful — move those fields to Power Apps Dropdown controls bound … 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 >>>
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 >>>
Your Power Automate flow is ready: it creates a SharePoint list item, sends an approval, maybe even posts to Teams. Everything works in testing, until you realize one thing: you don’t reliably have the user’s email address. Sometimes you need the person who triggered the flow, sometimes the creator of a list item, sometimes the … 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 >>>
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…