Power Apps · Delegation Deep Dive

Power Apps Delegation — Complete Guide

A plain-English, example-driven guide to understanding Delegation in Power Apps — what it is, why it matters, yellow warning fixes, SharePoint/Dataverse/SQL rules, and real-world solutions.

← Back to Portfolio Hub
✔Delegable = the filter/sort runs on the SERVER. All records considered. Safe for large data.
✘Non-delegable = Power Apps downloads up to 2,000 records, then filters on your device. Records beyond that are never seen.
⚠Yellow triangle = Power Apps warning you that a formula is non-delegable.
🛠Fix options: use a delegable function instead, or load data into a collection first.
01
What is Delegation?
Plain-English explanation with analogies
 02
The Yellow Warning Triangle
What it means and when to care
 03
The Row Limit Explained
Why 500/2000 rows exists
 04
Delegable vs Non-Delegable
Which functions work with which sources
 05
SharePoint Delegation Guide
What works and what doesn't
 06
Dataverse Delegation Guide
The best delegation support available
 07
SQL Server Delegation Guide
Rules for SQL Server / Azure SQL
 08
Fix: Load into a Collection
The most common fix, step by step
 09
Fix: Use Delegable Alternatives
Swap non-delegable functions
 10
Fix: Indexed Columns & Query Design
Structure data for better delegation
 11
Real-World Scenarios
10 common app patterns, delegation-safe
 12
Common Mistakes
Top 10 beginner delegation mistakes
 13
Quick Reference Card
One-page cheat sheet
View source on GitHub · Back to Portfolio Hub · Companion repo: Power Apps Formulas Reference