Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise