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.