38
I see how to call a Stored Procedure in Power Automate, but can I pass parameters, and get the values back ?
Can I set @MY_Variable1 INT to a number first ?
For instance, if I want to run EXEC My_StoredProcedure @MY_Variable1 INT , @MY_Variable2 INT
Then I want to use the result @MY_Variable2 later in Power Automate.
And what does the error message mean ?
I am getting the same error message when trying to use the Execute Stored Procedure action. The stored procedure name is not appearing to be selected, so I have to type it in, but then I receive the same error that you have. Wonder if the stored procedure action is not supported with on-prem SQL databases?
Share
Report
All responses (
Answers (
