Power Apps CountRows Function [Including the Delegation Fix]

Power Apps CountRows in a Gallery

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…

Power Apps Dropdown Show Only Unique Values [Step-by-Step]

Power Apps Dropdown Show Only Unique Values

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…

Power Apps First Function – With Examples

First Function in Power Apps

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…

Power Apps Remove Function – The Complete Guide to Delete Records

power apps confirmation popup before deleting a record

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…

Preferred Solution in Power Platform: What It Is and How I Use It

How to Set up Preferred Solution

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…

Power Apps Naming Conventions: The Complete Guide (With Examples)

Power Apps Naming Conventions

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…

[Solved] Invalid operation: division by zero in Power Apps

Invalid operation division by zero Power APPs

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…

Power Apps Dropdown Show Multiple Columns — Complete Guide

Power Apps Dropdown Show Multiple Columns

If you’ve ever built a Power Apps form and needed users to pick an employee from a dropdown, you know the pain. The list just shows “John,” but there are three Johns in your SharePoint list. Users have no idea which one to pick. That’s exactly the problem this tutorial solves. I’ll walk you through … read more…

How to Clear a Text Input in Power Apps [4 Easy Methods]

Clear a Text Input in Power Apps

If you’ve ever built a form in Power Apps, you already know this problem. A user fills in some fields, submits the form, and then all that text just sits there. They have to manually delete everything before entering the next record. Not a great experience. Clearing text input fields sounds simple, but there’s more … read more…

How to Add ID Value in Mirror ID Using Power Apps?

How to Add the ID value in Mirror ID using Power Apps

When I was working on an IT Help Desk solution, I needed to retrieve the most recent record using Power Automate and send it to Power Apps. Initially, everything was working fine. I was sorting the list by ID (Descending) to get the latest item. However, during testing, once the list exceeded 5,000 records, the … read more…

Live Webinar

Build an IT Help Desk App using Power Apps and Power Automate

Join this free live session and learn how to build a fully functional IT Help Desk application using Power Apps and Power Automate—step by step.

📅 29th Apr 2026 – 10:00 AM EST | 7:30 PM IST

Download User registration canvas app

DOWNLOAD USER REGISTRATION POWER APPS CANVAS APP

Download a fully functional Power Apps Canvas App (with Power Automate): User Registration App

Power Platform Tutorial

FREE Power Platform Tutorial PDF

Download 135+ Pages FREE PDF on Microsoft Power Platform Tutorial. Learn Now…