Power Platform Community Forum Thread Details

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,

Categories:

Using flows

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: