This month’s PowerApps Community call we will discuss and demonstrate common PowerApps development techniques.  In other words, things you will do/use almost every time you create PowerApps.  First, we will cover concepts related to user interface styling and user roles.  Then, we will discuss how to implement configuration settings, error handling, and logging and telemetry. 

https://aka.ms/PowerAppsCommunityWebinar 

Seems like it should be an easy task, right?  You want to count the records in a SQL Server on-premise table and return that count to PowerApps.  Since you can't invoke a Stored Procedure directly from PowerApps (that idea is currently under review), you'll have to get by with a little help from PowerApps' friend Flow, followed by some "magic" in PowerApps to be able to make use of that count.