Yes, you can connect your Power Apps app with data source other than SharePoint and office365 outlook connection. If you specifically want to know how your power app can connect with SQL Server then there are documents on MS Learn explaining steps to connect SQL Server from PowerApps.

If your data source is other than SQL Server then still it can be done by custom connectors.