Power Platform Community Forum Thread Details

Good evening,

Im hoping someone might be able to help, i'm getting a delegation warning when trying to filter my gallery and i'm not to sure why. Here is the breakdown of my app

Sharepoint list is the source, its called Progress Tracker, 3 columns are named

Task, (text)

Progress, (text)

Start Date (date)

I have inserted a gallery that looks at this source, it displays fine. I have created 3 buttons (outside the gallery) that i want to filter the gallery on named

All

In Progress

Completed

I have added an Update Context function on the 'On Select' property of each button.

All - On Select = UpdateContext(
{filterAll: true, filterInProgress: false, filterCompleted: false})

In Progress - On Select = UpdateContext(
{filterInProgress: true, filterAll: false, filterCompleted: false})

Completed - On Select = UpdateContext(
{filterCompleted: true, filterInProgress: false, filterAll: false})

I have applied this filter on the items property of the gallery

Filter(
'Progress Tracker',
If(
filterCompleted,
Progress = "Completed",
filterInProgress,
Progress = "In Progress"

filterAll,
)
)

I am getting a delegation error on all the button filters when selected and i am not to sure why, im very new to powerapps and filtering in general so would be really grateful for any advice

Thank you

Categories:

Building Power Apps

@iamrufus

Your formula you provided is not syntactically correct!

Beyond that, the formula editor cannot establish a delegable query when there are If statements in your formula. Always best to avoid If statements in the criteria.

Please consider changing your Formula to the following:

Filter('Progress Tracker',
 !filterCompleted || Progress = "Completed",
 !filterInProgress || Progress = "In Progress"
)

However, I would suggest the following changes to your design...

1) Change the formulas on the Button to the following:

UpdateContext({filterBy: self.Text})

2) Change your Items formula to:

Filter('Progress Tracker',
 filterBy = "All" || Progress = filterBy
)

I hope this is helpful for you.

Community site session details

Getting delegation warning when filtering gallery against a contextupdate variable

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates