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

[vsslasd]

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

[v-xida-msft]

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,

[Anonymous]

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