Power Platform Community Forum Thread Details

Hi team,

I have a very simple flow and SQL store procedure, but it is always long running and can't get the result successfully in automate flow.

Here is the SQL store procedure:

create procedure Trade_vw_Val
AS
select sum([AMOUNT]) as "TradeAmt" from [Intervention_2.0].[dbo].[vw_Trade_AIR_NonAIR_Intervention_Del]

EXEC [dbo].[Trade_vw_Val]

and here is the flow I created:

If I ran this SQL in SSMS, only takes 8 secs with below result:

select sum([AMOUNT]) as "TradeAmt" from [Intervention_2.0].[dbo].[vw_Trade_AIR_NonAIR_Intervention_Del]

But I can't succeed in automate flow.

Could you please kindly advise? thank you!

Categories:

Execute stored procedure long running