Power Platform Community Forum Thread Details

Hi,

I am facing very strange issue with SQL stored procedure and connecting it via Microsoft Flow.

I had created a stored procedure which takes input that is set as nvarchar(max). If I test stored procedure over SSMS it works fine while if i call it from Ms.Flow i get below error message.

The 'inputs.parameters' of workflow operation 'Execute_stored_procedure_(V2)' of type 'OpenApiConnection' is not valid. Error details: The API operation 'ExecuteProcedure_V2' requires the property 'parameters/Comments' to be a string of maximum length '-1' but is of length '20'.

I had another sql database for my other project which uses same table, SP and Ms Flow. I transferred everything from that tenancy to current to test this issue. I see issue on this database.

My flow is running in preview version. Database where SP+Ms.Flow with nvarchar(max) is basic plan while one with issue is standard plan.

I also found issue with int column. If pass details to SP with int column it throws similar issue. As a work around i changed variable to nvarchar(255) and then cast it to int in query it worked.

Need help on fixing this issue.

Thanks

Priyank Bhat

Categories:

Using connectors