I have an issue with passing NULL value to stored procedure. The procedure is a simple INSERT INTO some table. When I run the same procedure from Query editor on database with NULL parameters it works fine. When I do it from Flow, I receive error message that parameter was not supplied:
Same Flow with different values (for example @StartQ = 5) works fine. Is there any method to pass a NULL values to stored procedure (I want to have NULL in database table).
Can you please share a screenshot of the flow? Are you passing the null value through an expression or just writing "null"? You might want to try passing through the null expression if not already. Please see the screenshot below:
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
I'm using an expression. Here is my code:
This code generates described error if Executestoredprocedure_FinishQ equals 9999, and works fine in other cases 😞
I would like to see where you are using that expression and I am hoping that you are using the null value from expression editor instead of typing null (as the former would take a null value and the latter would be a string "null")
Hope this Helps!
I have some trouble with uproading screenshot. Please check the link:
Expession was generated by clicking in expression editor 🙂
Is there really no solution passing null into an sql query using an expression??
The only workaround isn't working in all cases: Use a variable and condition. This is ugly and doesn't work with parallized iterations.
Whether you’ve streamed the digital event live, or you're watching on-demand, claim your attendee badge to sport on your profile.
Watch Microsoft Business Applications Summit sessions on-demand.
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications