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

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

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

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.

Level 10

## Re: 500 row limit

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

Anonymous
Not applicable

SQL server

Level 10

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

Anonymous
Not applicable

## Re: 500 row limit

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

Level 10

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

#### Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

#### Power Platform World Tour

Find out where you can attend!

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

#### Microsoft Learn

Learn how to build the business apps that you need.

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,091)