cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TimoMigchielsen
Post Prodigy
Post Prodigy

Other option than countrows

Hello!

For my application I have a ticket system with a certain status. I have a dashboard where you can see how many tickets there are for each status. 


Looks like this:
https://gyazo.com/a1b79e3adbc25130af0a0d324122e196

I used excel in the first place but because I need to use more than 2000 rows for my filter, I want to use sharepoint. How can I make this formula work without having a deligation error?

1 ACCEPTED SOLUTION

Accepted Solutions

After a few years the status with "all" will have more than 2000 rows. But I simply do not like to see the error. But if there is no other way to do this, I guess it will be fine.

@mdevaney 

View solution in original post

3 REPLIES 3
mdevaney
Super User
Super User

@TimoMigchielsen 

Are you going to have more than 2,000 tickets in any specific status at once?  If no, you can safely ignore the delegation limit.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

After a few years the status with "all" will have more than 2000 rows. But I simply do not like to see the error. But if there is no other way to do this, I guess it will be fine.

@mdevaney 

View solution in original post

@TimMigchielsen
If this issue is solved for now please close the thread.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (923)