delegation warning on choices column filter

(0) Share

Report

Posted on by twister

418

Hi All,

How do I cater this 3 delegation warning issue? Status is choices column in sharepoint list..

"Not Started (" &CountRows(Filter(pm_main,status.Value="Not Started")) &")"

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @twister
"Not Started (" & With({_Item:pm_main},CountRows(Filter(_Item,status.Value="Not Started"))) &")"

Gallery Filter Example
With( {_Item: [@pm_main]}, SortByColumns( Filter( _Item, StartsWith( Status.Value, TextSearchBox1.Text ) ), "Title", If( SortDescending1, Descending, Ascending ) ) )
twister 418 on at

Like
a
(0)

Report
Copy link

Link copied!

@StalinPonnusamy thanks...its worked...
djidji 168 on at

Like
a
(3)

Report
Copy link

Link copied!

Hello, I have bad news for you, I couldn't believe there was no delegation warning with the "with" function, I tested on my side to solve a current problem that I have, and tried with different delegation limits.
The result: the formula with the function "with" does indeed show no delegation warning:
But in fact, it is as well limitated as the formula with the delegation warning. In the screenshot, the delegation limit was set to 3 (default is 500). There is no change at all between the two formula.
So I advise you to not use this solution if your dataset will get more than 2000 registration.
My supposition is there is no detection of delegation warning yet with the "with" function.

I beleve unfortunatly there is no solutions for these kinds of problems, that depends of the data set, I have encountered another solution with the utilisation of a gallery but it does not work as well (it is limited on what the gallery actually show), that only erase the delegation message with no actual impact with the data return.

Sorry and best regards,
Get me tuned if you have any solution with sharepoint datasets.