cancel
Showing results for
Did you mean:
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

## 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

7 REPLIES 7
Highlighted
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

## Re: 500 row limit

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

Highlighted
Anonymous
Not applicable

## Re: 500 row limit

SQL server

Highlighted
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

## 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

Announcements

#### Microsoft Ignite

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

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.