Anyone that's worked with SQL for any length of time will undoubtedly have seen and heard the following
This post is the first in a series I'll be doing, showing you how to achieve certain things in PowerApps that aren't immediately obvious but are very useful to enable you to create powerful, feature rich applications.
Update - April 2018:
PowerApps now has an experimental feature that can be turned on to increase the 500 row limit. I've not tested it with large sets but its a nice step forward.
To increase the limit, in the app developer studio (web or desktop) go to File->App Settings->Experimental Features and..