Combine Filter and StartsWith
Your formula can be correct and still fail at scale. Let's make that visible.
Lumen's marketing-tasks dataset has been growing. On the right is a live
mini-version of the gallery you've been building, bound to a
30-row dataset by default. The controls are the real ones from
Power Apps: a Status dropdown and a "StartsWith" search input.
The formula box above the gallery shows exactly what Power Apps
would evaluate as Items whenever you touch a control.
Flip the Pad to 600 rows toggle to grow the dataset past Power Apps' 500-row delegation cap. Watch what changes about the result count and the warning banner.
This exercise is part of the course
Introduction to Power Apps
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise