cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

500 row limit

Is 500 row limit is solved? Still, I can see only max of 500 rows in my function.

 

For example: Source has 1000 lines and my countif function should return me 600 lines after meeting certain criteria but it returns only 500 lines as a result.

 

Any solution will be really helpful.

 

500 rows limitation is very less.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: 500 row limit

For CountIf:

 

CountIf(Filter(MyTable, Year=2015), XXX = YYY) + 
CountIf(Filter(MyTable, Year=2016), XXX = YYY) +
CountIf(Filter(MyTable, Year=2017), XXX = YYY)

This should work if each year has <=500 records

 

Similar for GroupBy

 

View solution in original post

7 REPLIES 7
Highlighted
Community Champion
Community Champion

Re: 500 row limit

hi @Anonymous

as you can see from here, the limit is slowly being lifted for a number of data sources and functions.

countif is not yet delegated, however.

you can maybe work around by combining Sum and Filter if you are using SQL Server as a data source.

Highlighted
Anonymous
Not applicable

Re: 500 row limit

is there any solution to solve it when I use group by?

 

in my current group by in a drop down, I get the result only for first 500.

Highlighted
Community Champion
Community Champion

Re: 500 row limit

If you read the same table you see that GroupBy is also not delegated.

What is your data source?

Highlighted
Anonymous
Not applicable

Re: 500 row limit

SQL server

Highlighted
Community Champion
Community Champion

Re: 500 row limit

Then you need to segment the data with Filter to chunks of up to 500 rows each and then add the result of the CountIf on each individual chunk.

Highlighted
Anonymous
Not applicable

Re: 500 row limit

Could you please provide me any example for both my problems countif and groupby?

Highlighted
Community Champion
Community Champion

Re: 500 row limit

For CountIf:

 

CountIf(Filter(MyTable, Year=2015), XXX = YYY) + 
CountIf(Filter(MyTable, Year=2016), XXX = YYY) +
CountIf(Filter(MyTable, Year=2017), XXX = YYY)

This should work if each year has <=500 records

 

Similar for GroupBy

 

View solution in original post

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (2,996)