Power Platform Community Forum Thread Details

Hi,

I have a source that has a list of dates in "Date" (Stored in "dd/mm/yyyy" format). I also have a calculated column called "Month Completed" (Stored in "mmmm yyyy" format).

I am trying to create a label with a count to count the current completed tasks within the month. However, I get a delegation error. As this list will likely get larger than 2000 I am trying to resolve the delegation warning.

Delegation warning is coming from this part of the code "Month(Date) = Month(Now()) &&"

Code:

CountRows(
 Filter(
 'Site Audits',
 Month(Date) = Month(Now()) && ( If(
 LookUp(
 'Engineer List',
 EngineerName = User().FullName
 ).Title = "Service Manager",
 Region = LookUp(
 'Engineer List',
 EngineerName = User().FullName
 ).Region,
 Title = User().FullName
 ) )
 )
)

Categories:

Building Power Apps

Hi @Jcurtis260 ,
Almost every element of what you have is not Delegable (I assume you are using SharePoint) -

CountRows(),
Month() used on your date field
The relational Lookup to 'Engineer List'

I cannot test his presently and all it does is "mask" the Delegation issue if you are working with a big list

With(
 {
 wRole:
 LookUp(
 'Engineer List',
 EngineerName = User().FullName
 ),
 wMonth: Month(Now())
 },
 With(
 {
 wData:
 Filter(
 'Site Audits',
 wRole.Title <> "Service Manager" ||
 Region = wRole.Region
 )
 },
 CountRows(
 Filter(
 wData,
 Month(Date) = wMonth
 )
 )
 )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps