Cheat sheet
Power Apps Gallery Filtering Cheat Sheet
Delegation-aware gallery filter formulas for search boxes, status chips, date ranges, user filters, and queue screens.
Power Apps gallery filterdelegationSearch gallery
Who this helps
Makers building galleries that need to keep working after the list gets large.
What to standardize
- Start with delegable filters first.
- Use StartsWith for SharePoint search when possible.
- Combine status and ownership filters carefully.
- Avoid wrapping columns in non-delegable transformations.
Examples
Status and search
Filter a request gallery by status and title search.
Formula / code
Filter(
Requests,
RequestStatus.Value = cmbStatus.Selected.Value,
StartsWith(Title, txtSearch.Text)
)Expected result: The gallery filters by selected status and typed title prefix.
Common mistakes
- Using Search on large SharePoint lists
- Lowercasing the column in the filter
- Ignoring delegation warnings