Hello,
I have a Flow in which I'm calling a SQL Server stored procedure and I want to get the value of the output parameter after execution. It'll be used in Power Apps to tell whether the execution from a stored procedure, which involves an API call, ran successfully. The return message will be descriptive if there was a failure rather than presenting a generic error message.
The logistics of the stored procedure are as follows:
Stored Procedure: Execute_PPS200MI_UpdLine
Parameters (IN): CONO, PUNO, PNLI, PLNS, DWDT
Parameter (OUT): ErrorMessage
Being new to Power Automate/Flow, I haven't found a clean way to get the OutputParameters value. There is where I get stuck.
Below is a screen capture of the flow. For testing purposes, I tried to pass OutputParameters into an email notification but it's not available to paste as a variable into the text of the email body. I will ultimately pass the value back to Power Apps.
Note: I have seen responses to prior inquiries about OutputParameters that answered how to get a result set back from a stored procedure. I only need to get the value of the output parameter, not a result set. Thanks in advance.
