cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HubbardInc
Helper II
Helper II

Delegation Issue

Can someone please help me with this delegation warning. I'm not sure how to change my formula for this gallery to be delegate-able. I have the same problem with my item counters as well. Thank you.PowerApps FilterGallery7.jpgPowerApps FilterGallery8.jpg

6 REPLIES 6
eka24
Super User III
Super User III

If the status column is a choice column, change that portion to;

 

StatusColumn.Value

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

On the first picture i sent, on the if statement, that option worked, however when performing the CountRows function, it did not. CountRows is not a delegate-able function? 

eka24
Super User III
Super User III

Did you change to StatusColumn.Value?

Also:

Yes CountRows cannot be delegated. How many rows are you dealing with, more than 2000 even after filtering?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

This is the current formula.

 

CountRows(Filter('IT Support Tickets','Ticket Status'.Value = "In-Progress"))

 

It should return the count of items where the sticket status = "In-Progress"

 

But if CountRows can't be delegated, what are my options?

You didn’t mention what your source for this is. If you use common data service, you can build system views filtered to the records with the desired status to filter your gallery https://www.google.com/amp/s/www.inogic.com/blog/2019/12/avoid-delegation-while-filtering-records-in...

 

how many total records are in your source?

You can use a collection but i asked you how many rows do you have?

Also on you File...Advance settings have increase the delegation to 2000?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,526)