Stored Procedure Input Parameter Needed Power Automate

Question

Hi,&nbsp;I currently have a Stored Procedure that does not have any Input Parameters, it basically updates a Calendar Table, setting columns like&nbsp; CurrentDay, PreviousDay, CurrentMonth etc... to 1 or 0 if the conditions matches.I wanted to use Power Automate to run this stored procedure at 12:00 everyday but it failed because Power Automate only executes Stored Procedures with an Input Parameter&nbsp;https://docs.microsoft.com/en-us/connectors/sql/#execute-stored-procedure-(v2)&nbsp;&nbsp;What is the most efficient way to add an Input Parameter to my current stored procedure but basically does nothing but still does the update is meant to do.&nbsp;Thanks&nbsp;

bake13 · Answer

Hi&nbsp;SqlAvfc&nbsp;-- You could add a parameter similar to that shown below.&nbsp; The parameter does nothing at all but satisfies the Power Automate stored procedure requirement.&nbsp; Take care.
&nbsp;
create stored procedure ThisIsAstoredProcedure
    @RequiredParam BIT
AS
    'Logic Here'
To execute the stored procedure:
EXEC ThisIsAstoredProcedure @RequiredParam=1
&nbsp;&nbsp;

jt387 · Answer

SqlAvfc&nbsp;I found entering {} , works were no parameters are required.&nbsp;

Forum Discussion

Stored Procedure Input Parameter Needed Power Automate

2 Replies

Resources