Deborah Melkin shares a note about Power Apps:
When I write a SQL Query, I never have to worry if the way I’m writing a query will automatically create a limit on the number of records being returned if I’m not specifying TOP or OFFSET…FETCH. If my query wants to return 1 million records, it will return 1 million records.
PowerApps doesn’t work that way.
Click through to see how it does work, including some of the limitations around it.