You’re offline. This is a read only version of the page.
Hi,
I have a stored procedure that is returning a numeric value with the use of RETURN(@Number).
When I call the procedure from microsoft flows the return code propagated is empty.
Thanks,
Hi @sundayDriver,
Could you please share a screenshot of your flow’s configuration?
Further, could you please show a bit more about your stored procedure?
The return code indicates the execution status of a procedure. As with OUTPUT parameters, you must save the return code in a variable when the procedure is executed in order to use the return code value in the calling program.
I have made a test on my side and could not be able to get return code by executing the stored procedure. The screenshot of my stored procedure as below:The result of executing the procedure as below:
So the return code propagated is empty when we call the procedure from Microsoft Flow. But we can use variable to store the return code and print it as below:
More details about Returning Data Using a Return Code in stored procedure, please read the article as below:
Returning Data Using a Return Code
Best regards,
Kris
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
