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

 

View solution in original post

7 REPLIES 7
Meneghino
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.

Meneghino
Level 10

Re: 500 row limit

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

What is your data source?

Anonymous
Not applicable

Re: 500 row limit

SQL server

Meneghino
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?

Meneghino
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

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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