Learn how to create and use apps in Microsoft Power Apps from our useful Power Apps tutorials.
Getting the “The JSON function cannot serialize tables/objects with a nested property called ‘_ownerid_value’ of type ‘Polymorphic’” error in Power Apps? I ran into this exact issue while building a Power Apps Canvas App against a Dataverse table. I was trying to extract column names from a collection using the JSON function — and out of nowhere, … read more…
If you’ve been building a Power Apps canvas app connected to a SharePoint list or Dataverse table and hit this error: “The JSON function cannot serialize tables / objects with a nested property called ‘{Attachments}’ of type ‘Table(Attachment)’” You’re in the right place. I’ve run into this exact error myself while trying to extract column … read more…
In Power Apps, you can show a completely different home screen to each user based on their department, role, or email — no premium license needed, no code outside the formula bar. This tutorial walks you through the modern, Microsoft-recommended way to do it using App.StartScreen, plus I’ll cover what’s changed since the old App.OnStart approach and why … read more…
If you’ve been working with Power Apps for 8+ years, you already know the basics inside out. You’ve built canvas apps, connected SharePoint lists, and used Power Automate. This isn’t that guide. This is for the conversations where the interviewer leans forward and says, “Okay, but how would you handle that at enterprise scale?” I’ve put … read more…
If you’ve worked with Power Apps and Power Automate for even a short time, you’ve probably run into JSON. And honestly, the first time I saw JSON in Power Apps, it felt confusing. But once I understood how to work with it, it became one of the most powerful tools in my apps. In this … read more…
Searching a SharePoint list in Power Apps sounds simple — until you hit a delegation warning, a Choice field that breaks your formula, or a Person column that returns absolutely nothing. I’ve built dozens of Power Apps for clients and internal teams, and these exact problems come up every single time. In this tutorial, I’ll … read more…
CountRows looks like one of the simplest functions in Power Apps — until it silently gives you the wrong number. If your SharePoint list has 1,200 records but CountRows keeps returning 500, you’ve hit the delegation limit. And if you tried the “just use a Collection” workaround — surprise, that doesn’t fix it either. In … read more…
If you’ve ever connected a Power Apps dropdown to a SharePoint list and ended up with the same value appearing 15 times, you know how frustrating that can be. Your users don’t need to see “Marketing” repeated over and over — they just want to pick it once and move on. In this tutorial, I’m … read more…
If you’ve ever built a Power Apps canvas app connected to a SharePoint list, you’ve probably run into a situation where you only need one record — the first one in a list, the most recent entry, or just the top result from a filtered query. That’s exactly where the First function in Power Apps comes in handy. In … read more…
If you’ve built even one Power Apps canvas app, you already know that adding and editing records is straightforward. But deleting them? That’s where most people get stuck, or worse, they write a formula that silently does nothing. In this tutorial, I’m going to walk you through everything you need to know about the Remove function … read more…
When I first started working with solutions in the Power Platform, I mostly ignored the Preferred Solution setting. I created apps, flows, and tables directly in the default environment and didn’t think much about where those components were stored. Later, when the project grew, and I started organizing components inside solutions, I realized something important: … read more…
If you’ve ever opened someone else’s Power Apps canvas app and had absolutely no idea what Label5, TextInput3, or Variable2 is supposed to do — you already know why naming conventions matter. And honestly, I’ve been there too. I’ve come back to my own apps after a few weeks and spent 20 minutes figuring out what I built. That’s … read more…
When I was working on an IT Help Desk solution using Power Apps and Power Automate, I needed to get ticket data using Power Automate and send it to Power Apps. Everything was working fine at first. But the problem started when I tried to get data from a multi-select Person column called Assigned To. … read more…
Recently, while working on an IT Help Desk solution in Power Apps, I tried to retrieve all the records using Power Automate to avoid delegation issues. However, we cannot retrieve all the records at once. To solve this, I implemented pagination, where records are loaded page by page. After completing the development, when I ran … read more…
This free guide walks you through the 30 most-used Power Apps functions with real business examples, exact syntax, and results you can see.
Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App