PowerApps and Large SQL Server Tables

This video deals with how PowerApps deals with a large SQL Server table of over 42,000 rows and shows how you can use the Filter function and operators to get back results from the large table. It also discusses the problem with some operators and date fields and how to create collections with nested Sort and Filter functions and how PowerApps fetches the data from the large table.

[andrewpythag]

Thanks Kathryn for a very informative walkthrough! I hope that the 100 record query batch limit is addressable at some point soon - perhaps as you suggest with a "get more records" function. As a workaround currently I am adding a CountRows function to a label control and if the result is 100 then I present a further text label with a message to indicate their could be more rows requiring manual intervention!

[ItsAlreadyDone]

hi mam i dont know how to connect power apps to sql server i am facing error

[MrSnaga]

In gallery how this information is reflected?

[BarryMorganR]

Though not ideal, maybe it would be good practice to add a text field that represents "Displaying XX of records returned." displayed at the bottom of the table?

[pauloflaherty]

Hi Kathryn. Thanks for the video.
With a delegable data source (where results are returned 100 at a time) the '...' that appears at the bottom of the table or gallery is supposed to indicate that there are more rows and can be tapped/clicked to load the next 100, but it is not a very obvious UI element when running in a web browser.

[thomasroberts]

Would it be possible to convert the date to a number to do > or < on date value?

[victorespinoza]

Thanks for your time and effort to put this video on YoutTube but next time you make a video make sure you have good volume. My Volume is the max and I can barely hear you. Thanks for the info.