web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps / Flow / Azu...
Power Apps
Answered

PowerApps / Flow / Azure SQL Intermitent Connection problems

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I use a number of Flows connected to PowerApps to retrive information from Azure hosted SQL database (many of these call stored procedures to improve performance). 

From time to time everything locks up/times out - today has been especially bad with load/update times running into several minutes instead of the usual seconds.

 

The intial PowerApp loads and then hangs while the data is being retrived via the Flows. Running the Flows directly the response time has gone up from a few seconds to minutes on one test, the next time I run the same Flow it's back to seconds.

 

Everything has been stable up to now but today has been so bad the apps are unusable.

 

Searching around I can't find any information on the status of PowerApps & Flow except 'everything is running normally' - which it isn't. Looking at the Azure dashboard there doesn't appear to be any issues.

 

Does anyone else get problems like this?

If you do how are you able to pin point the issue and more importantly fix it - rather than having to wait for it to fix itself.

 

I've had several very grumpy users today and general development work has been almost impossible due to the time taking to save/update.

Categories:
  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Could you tell me what data sources that your app and flow connect with?

    Currently, I haven't met this kind of problem.

    I suggest you clear your browser's cache, update it to the latest version and try again.

    What's more, please make sure that you are in good condition of network, which will effect the app's performance too.

    If the problem still exists, I suggest you ask for help here:

    https://powerapps.microsoft.com/en-us/support/pro/ticket/

     

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi Phoebe

    The browser cache isn't the problem as the issue affects multiple users using different PCs/Macs and browser combinations - Clearing my browser cache and/or switching to a different browser is also one of my first tests to discount any local issues.

     

    The current data path is 'PowerApp - Flow - Azure SQL db' - with flow connecting to either the SQL tables directly or to stored proceedures. I have triggered the stored proceedures directly and these are working as expected.

     

    Looking at the run history for one of my flows (see attached) you can see that normal run time is typically 0 to 3 seconds. However, when the issue occured the time increased significantly, up to 3m 22s plus one failure.This pattern is repeated accross most of my other flows.

     

    Nothing has changed with the underlying data structure, Flow design or PowerApp code calling the Flow.

     

    At the moment normal service appears to have been resumed.

    If it happens again I'll get straight on to support - hopefully to catch the problem while its happening.

     

    Cheers

    Gary

     

    Run History.PNG
  • Verified answer
    v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Ok, thanks for your feedback.

    Do you have any other problem?
    If you've solved your problem, could you change your issue's status to "Answered"?

    Thanks!

     

    Best regards,

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Didn't real solve anything, it just started working again - to me it appeared to have been a server/hosting issue.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 396 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 323

#3
WarrenBelz Profile Picture

WarrenBelz 193 Most Valuable Professional

Last 30 days Overall leaderboard