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 Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,530)