How do I use OutputParameters from "Execute Stored Procedure" action's Stored Procedure ?

(1) Share

Report

Posted on by yoshihirok

1,724

I want to use Output value from my Stored Procedure in "SQL Server - Execute Stored Procedure" action.

Now, I can use "ReturnCode".

My Stored Procedure:

ALTER PROCEDURE [dbo].[DNN_Rousei_Test]
(
	@Param1 nvarchar(10),
	@Result nvarchar(10) OUT
)
AS
BEGIN
	SET NOCOUNT ON;

	SELECT @Result = @Param1 + '!!'

	RETURN 0
END

My Flow:

Regards

Yoshihiro Kawabata;

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

aerowork 5 on at

Like (1)

Report

I would also like to know how to use the SQL data as an output to other steps.

Was this reply helpful? Yes No
v-yamao-msft on at

Like (1)

Report

Hi Yoshihiro,

This article about “Connecting up Microsoft Flow, SQL and Twilio” would be a reference for you.

The link of the article is:
https://flow.microsoft.com/pt-br/blog/connecting-flow-sql-twilio/

Best regards,
Mabel Mao

Was this reply helpful? Yes No
yoshihirok 1,724 on at

Like (1)

Report

Hi, @v-yamao-msft

This article does not include my issue.
"Connecting up Microsoft Flow, SQL and Twilio".

I want to know How do I use OutputParameters frrom Execute Stored Procedure.
This article seems to call SPROC, but dont use OutputParameters.

Regards,
Yoshihiro Kawabata

Was this reply helpful? Yes No
Ed_Solman 4 on at

Like (1)

Report

I was having the same issue, trying to access the Output Parameters from a SQL stored proc. Say my proc was outputting values X and Y. I created a new table in SQL that had columns X and Y, then changed the proc so it wrote the X and Y values to the X and Y columns in the new table, instead of outputting them. I then used the SQL Get Rows flow action to retrieve the values from the table and could then use them in subsequent flow actions.

One further point.. My table only has 1 record containing the X and Y value from the last time the procedure ran, because I just overwrite it each time. I tried using the 'SQL Get Row' (a single row) action, but I've no idea how the 'Row Id' parameter works and can't find any help on it. So I ended up using the 'SQL Get Rows' (plural) instead, which automatically put a 'For Each' wrapper around any subsequent actions where you use the values, as it assumes you might potentially retrieve multiple rows of data, and need to perform those actions for each row.

All a bit of a dirty workaround, but it works OK.

Hope that helps:)

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report

Hi all, is there any update on this topic?
Many thanks.

Was this reply helpful? Yes No
sundayDriver on at

Like (1)

Report

@yoshihirok, @Meneghino, @aerowork

I found that there is an idea posted about this topic:
https://powerusers.microsoft.com/t5/Flow-Ideas/Map-SQL-output-for-use-in-other-steps/idi-p/6766

Was this reply helpful? Yes No