cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anthony_Dob
Continued Contributor
Continued Contributor

Count 50k + records with filtering

Hi all,

 

I have a dashboard in my application that shows counts of particular records with a certain filtration. Let's say 

  • 10 records are New 
  • 20 records are processed
  • 30 records are done

 

This will only work until 50k records as CountRows does not support over 50k records with filtration. I am looking for suggestions to keep a count for this situation after the filtering hits over 50k records.

 

A idea i had is to have a seperate table that has 'CounterRecords' this would look like this

  • New total count: 10
  • Processes total count: 20
  • Done total count: 30

Every time a record would go from New to Processed i would increment Processed and decrease New. I would do the same for other 'Status changes'. However i have a lot of 'CounterRecords' and this would mean that i would need to implement this everywhere in the application where records would change from 'Status'.

 

What would you guys suggest for this scenario? Any 'easier' methods/approaches?

 

Best regards,

Anthony

2 REPLIES 2
Chitrakant27
Resolver II
Resolver II

Hi @Anthony_Dob ,

 

You can use pagination concept to view more than 50k item in Dashboard . I am pasting a reference link in below so that you can get much more idea about it.

 

link-https://www.youtube.com/watch?v=aKsNOsGj72A

 

Thanks,

Chitrakant27

This does not really solve the problem for me. Viewing large data is no problem as my queries are delegable. However i want to see the count of a filtered table even when it hits over 50k results (fetching 50k+ records in memory is no option)

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 (4,493)