Forum Discussion
SqlAvfc
May 31, 2022Copper Contributor
Stored Procedure Input Parameter Needed Power Automate
Hi, I currently have a Stored Procedure that does not have any Input Parameters, it basically updates a Calendar Table, setting columns like CurrentDay, PreviousDay, CurrentMonth etc... to 1 or ...
bake13
Microsoft
Jun 06, 2022Hi SqlAvfc -- You could add a parameter similar to that shown below. The parameter does nothing at all but satisfies the Power Automate stored procedure requirement. Take care.
create stored procedure ThisIsAstoredProcedure
@RequiredParam BIT
AS
'Logic Here'
To execute the stored procedure:
EXEC ThisIsAstoredProcedure @RequiredParam=1