Skip to main content
Community site session details

Community site session details

Session Id : l+qmHU+bPSevSq0GkUBRJJ
Power Apps - Building Power Apps
Unanswered

SQL connection status

Like (2) ShareShare
ReportReport
Posted on 21 Jan 2018 21:18:12 by 179

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?

Categories:
  • v-micsh-msft Profile Picture
    on 23 Jan 2018 at 11:01:17
    Re: SQL connection status

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete