SQL Server stored procedure.v2 runs twice on failure

(0) Share

Report

Posted on by DarkLiteOne

234

We have a simple button that launches a flow:

UpdateContext({showLoadingCancellation: true});
'PA>usp_SiteVisitCancellation_AddUpdate'.Run(SiteVisitID, CancelledByID, UserID, Reason.Text);
UpdateContext({showLoadingCancellation: false});

The flow has been created brand new for testing purposes and consists of 2 steps:

When pressing the button once we see the flow is correctly triggered once:

The failure is expected as we do a "THROW" within the SQL Stored procedure on the server.

However, we do notice on the SQL server that the stored procedure is called TWICE. This only happens when the SPROC fails, when it is successful it is only triggered once. It seems to be related to this issue.

After analyzing this further the problem is easily replicated without using PowerApps and simply doing a "Test" run within the flow. The same issue happens and we can see on the server that the SPROC is ran TWICE on failure.

This must be a bug in the action "Execute stored proedure (V2)".

All responses (2)

Answers (0)

DarkLiteOne 234 on at

Like (0)

Report

Re: SQL Server stored procedure.v2 runs twice on failure

Thanks for your help but it's not a timeout issue.
eric-cheng 5,171 on at

Like (0)

Report

Re: SQL Server stored procedure.v2 runs twice on failure

Hi @DarkLiteOne ,

Someone may have a better answer but I found this online here. This is for Logic Apps but should be the same for Power Automate.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up