Skip to main content
Community site session details

Community site session details

Session Id : 01D+ARbxJnRqX7CI7GBSHq
Power Automate - Building Flows
Unanswered

Execute Stored procedure V2 timeout after 2 minutes

Like (0) ShareShare
ReportReport
Posted on 14 Jan 2020 10:53:48 by

Hi,

 

I am trying to execute Stored Procedure(SP) in Power Automate which takes 10 mins to complete but SP timeout after 2 minutes.

Even when the timeout is changed to 1 hour, somehow it is not using it

 

Capture.PNG

  • LaelLeeH Profile Picture
    91 on 09 Feb 2023 at 10:20:17
    Re: Execute Stored procedure V2 timeout after 2 minutes

    Hi @LeeHarris 

    I have the same problem and yes, my stored procedure does run perfectly well when executed in SQL.  Mine takes just over 2 mins when executed directly in SQL. I suspect it has something to do with a second stored proc which I am triggering from inside the stored proc called from the flow. When that second (nested) stored proc takes over two minutes to run, then the flow times out. If that one runs under 2 mins, then flow is fine. Is that possible? Is there a workaround?

     

    Regards

    Lael

  • JoshuaAsh Profile Picture
    14 on 23 Oct 2022 at 23:38:29
    Re: Execute Stored procedure V2 timeout after 2 minutes

    Date of posting: 01-14-2020 06:53 PM

     

    wisdom_of_the_ancients
  • jpardomartinez Profile Picture
    4 on 28 Oct 2020 at 19:57:54
    Re: Execute Stored procedure V2 timeout after 2 minutes Heeeeelp!

    Hi,

    I have the same problem. Did you find a solution?

    Thanks!

  • Community Power Platform Member Profile Picture
    on 14 Jan 2020 at 14:28:31
    Re: Execute Stored procedure V2 timeout after 2 minutes

    Hi @LeeHarris : The Stored procedure works fine in SQL

  • LeeHarris Profile Picture
    1,026 on 14 Jan 2020 at 11:32:38
    Re: Execute Stored procedure V2 timeout after 2 minutes

    Hi @Anonymous 

    Does your Stored Procedure complete successfully without timing out when executed directly in SQL (assuming it also takes 10 minutes to execute)?

     

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 Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2