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

CountRows No Longer Delegable for SQL?

I have a CountRows formula that was using an Azure SQL DB table as the source.

 

I am (99%) sure that previously this was not flagged as non-delegable, but starting today, it is. The formula is on the Visible property of an icon which is hidden most of the time, so perhaps the change is just that the blue warning circle was not previously showing for hidden icons.

 

I have modified my formula for CountRows so that the source is a Gallery (which is based on the Azure SQL DB table) and all is well again. 

 

I'm just curious as to whether this is something I missed or whether there has been a change that makes CountRows non-delegable for SQL tables.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: CountRows No Longer Delegable for SQL?

Hi @PaulD1,

 

I agree with MartynasJurkus for this issue.

Check MartynasJurkus's response in the following thread:

CountRows No Longer Supported for SQL? 

Quoted:

"

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)

"

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
TML
Level 8

Re: CountRows No Longer Delegable for SQL?

I get the message that says "Part of this formula cannot be evaluated remotely. CountRows operation is not supported by this connector/service."  I am using an on-premise SQL database.  However, the function is working at the moment and returns the correct count.  I'm just afraid it's going to stop working at some point.  And I agree, the message wasn't there originally.

Community Support Team
Community Support Team

Re: CountRows No Longer Delegable for SQL?

Hi @PaulD1,

 

I agree with MartynasJurkus for this issue.

Check MartynasJurkus's response in the following thread:

CountRows No Longer Supported for SQL? 

Quoted:

"

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)

"

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Super User
Super User

Re: CountRows No Longer Delegable for SQL?

Thanks @v-micsh-msft 

 

So CountRows was never delegable but has only recently started as showing as such in the designer (with the blue warning dot)?

 

I find it concerning that this was not being properly flagged (blue warning dot) previously. I am trying to ensure that all my data calls are delegable so that I won't hit performance problems or the 500 record return limit as my data grows, and I have been relying on the warning within the designer to know when there is a potential issue.

 

I have changed to counting the gallery items now.

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
Users Online
Currently online: 183 members 4,531 guests
Please welcome our newest community members: