cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vsslasd
Advocate V
Advocate V

Delegation Warning Message on formula in Text box issued on a SQL Server View

We are receiving a Delegation Warning Message on a  formula in Text box issued on a SQL Server View:

"Tasks" & Char(13) &"Complete " & Char(13) & CountRows(Filter('[dbo].[vwFTM_SC]',Service_Call_ID=ThisItem.Service_Call_ID && (Complete=1 || NA=1))) &"/"& CountRows(Filter('[dbo].[vwFTM_SC]', Service_Call_ID=ThisItem.Service_Call_ID))

 

It looks like it is working correctly, but want to have a better understanding of if this is going to be an issue or not.

 

We have 25,000+ rows in this view.

 

As mentioned, it does look like it is working correctly. I know a PowerApps Collection can only hold 2,000 rows. But this is a SQL View and not a PowerApps collection.

 

How does PowerApps handle this view ? Does it send the Where clause to the Server, and only return those rows requested, so processing is done on SQL Server, or is processing done on the Entire 25,000 row record set within PowerApps ?

 

And What is the best method for dealing with larger datasets ?

 

A stored procedure it would seem would resolve this issue by returning the appropriate rows via a where clause using a variable, but Stored Procedures are not supported in PowerApps.

Thank you

2 REPLIES 2
v-xida-msft
Community Support
Community Support

Hi @vsslasd,

Could you please share more details about the Delegation warning issue with your formula?

I think the Delegation warning issue may be related to the CountRows() function within your formula.

Currently, within PowerApps, the CountRows() function could not be delegated within PowerApps. Please check the following article for more details:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#aggregate-functions

 

If you want to handle this Delegation warning issue within your app, I afraid that there is no way to achieve your needs in PowerApps currently.

Please also check and see if the following blog would help in your scenario:

https://blog.coeo.com/davidmorrison/powerapps-500-record-limit-delegation-and-how-to-work-around-it

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks for posting in the community @vsslasd. Can you advise if you're still receiving this message and if the above reply was helpful? 

 

Thank you,

 

@Anonymous 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,097)