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

CountRows No Longer Supported for SQL?

I opened my applications this morning and received the following error in one of my formulas that use to work flawlessly:

 

"Part of this formual cannot be evaluated correctly.

CountRows operations is not supported by this connector/service"

 

Here is the formula in question:

 

CountRows(Filter('[dbo].[Items]', Location = "Used"))

This is my session ID and info 

 

Session ID: a913aef8-fc25-985f-c10a-c06b9a75563a
PowerApps 2.0.711

 

I'm using Azure SQL as my database. This formula has been working for months. Why the change in support? Am I going crazy?

 

Brendon

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: CountRows No Longer Supported for SQL?

Hi @BrendonBrooksP1

 

It seems that CountRows() was never supported:

Delegation Info

 

It will still return you the number of rows but it will not return more than 500.

 

What I often do in my apps is that I use CountRows() directly on the gallery or collection.

 

Examples:

CountRows(Gallery.AllItems)

OR

CountRows(MyCollection)

 

2 REPLIES 2
Anonymous
Not applicable

Re: CountRows No Longer Supported for SQL?

Hi @BrendonBrooksP1

 

It seems that CountRows() was never supported:

Delegation Info

 

It will still return you the number of rows but it will not return more than 500.

 

What I often do in my apps is that I use CountRows() directly on the gallery or collection.

 

Examples:

CountRows(Gallery.AllItems)

OR

CountRows(MyCollection)

 

Re: CountRows No Longer Supported for SQL?

@Anonymous

 

Ahh, good point. I'll make those changes. Thanks!

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Top Kudoed Authors
Users Online
Currently online: 63 members 3,898 guests
Please welcome our newest community members: