cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ungarala1
Helper V
Helper V

Delegation Warning

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

4 REPLIES 4
zmansuri
Super User
Super User

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
Super User
Super User

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"))

 

 

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
Super User
Super User

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)

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,893)