SQL connection status

[strategery]

Does anyone know a good way to test a SQL data connection quickly? Right now all I know to do is attempt to collect from a table and check for empty, but it's pretty slow. Perhaps there's somewhere to set the timeout? I'm wanting to modify my existing app to handle times when the server is being rebooted or we have network issues. All I've found thus far or checking connection of any kind is Connection.Connected, which is only useful for losing network connection completely. Any ideas/suggestions?

[v-micsh-msft]

Hi @strategery,

Based on what I know, there is no function available for the SQL Server Connection to check the connection status.

For all the available signals, please check:

Acceleration, App, Compass, Connection, and Location signals in PowerApps

For Office 365 connection, there is function:

Office365Users.TestConnection()

available to check the connection status.

You may consider to submit an idea on this part, to suggest to add a testing connection status for special connections (Such as SQL Server).

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Regards,

Michael