Delegation Warning

[Ungarala1]

created label to count  dropdown column status value as Not Started one.

CountIf('Notice Tracker',Status.Value="Not Started")

nothing showing value but  with ! yellow mark

[zmansuri]

Countif is not delegated. if you have less than 2000 record in your source you can just ignore the warning. if not try this:

CountRows(Filter('Notice Tracker',Status.Value="Not Started"))

[C-Papa]

Hi, this is a limitation of the data source. PowerApps by default only pulls in 500 records from a query. This can be increased to 2000 in the app settings but can still leave issues, for example, if you have 2001 records in your list and the 2001 record Status.Value="Not Started" then it will not show as it can only process the first 2000. to get round this you will need to carry out a delegable filter and then do the count. this will work as long as you don't have more than 2000 records that have the status Not Started. 

label.text = CountRows(Filter('Notice Tracker',Status.Value="Not Started"))

[Ungarala1]

it showing value but delegation symbol present, if not can we filter using user email like this 

CountRows(Filter('Notice Tracker','Assigned Designer'.Email=User().Email,Status.Value="Completed"))

but this also showing delegation symbol 

[C-Papa]

All CountRows() functions are not delegable so you will always get this warning. its good to filter the data source to the smallest amount possible so your comment above is a good idea. The Filter function within the CountRows is delegable so you should be ok to retrieve 2000 records that meets your criteria. if it make you feel better you could split this out and collect the records and the count them

Button OnSelect or Screen OnVisible = ClearCollect(Col_My_Count,Filter('Notice Tracker','Assigned Designer'.Email=User().Email,Status.Value="Completed"))

then your label.text would be

CountRows(Col_My_Count)