cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Community Champion
Community Champion

Re: Delegation Issue

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.

Highlighted
Helper I
Helper I

Re: Delegation Issue

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? 

Highlighted
Community Champion
Community Champion

Re: Delegation Issue

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.

Highlighted
Helper I
Helper I

Re: Delegation Issue

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?

Highlighted

Re: Delegation Issue

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?

Highlighted
Community Champion
Community Champion

Re: Delegation Issue

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,446)