The most recently updated SharePoint, Power Apps, Power Automate and Power BI tutorials from EnjoySharePoint. Every tutorial is tested in a real Microsoft 365 tenant.
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 leave request form and needs to assign an employee’s manager as the approver. Typing an email address into a text box works at first, but it quickly creates problems. Someone enters the wrong address, another person uses an old name, and the approval workflow goes to the wrong person. I … 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 >>>
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 >>>
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 >>>
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 >>>
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 >>>
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 >>>
You build a canvas app, and before long, the same formula shows up in five different places. You copy a LookUp once, then again for another label, then again for a visibility rule. A week later, you need to change that logic, and now you have to hunt through the whole app to fix it. … Read more >>>
122 copy-paste formulas with real examples, sent straight to your inbox.
Your free Power Automate Expressions Cheat Sheet is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to