cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnjohn123
Super User
Super User

How i can assign Null value to an Integer variable. currently i am getting this error "the variable of type integer cannot be set to null or empty value"

I have the following action to initiate a variable inside my MS Flow :-

 

iniate.png

 

and an action to assign a value to this variable:-

 

sp.png

 

 

But if calling the SQL stored procedure return null>> I will get this error on run-time:-

 

errorruntime.png

 

so how i can assign a null value to an integer variable ?

 

3 REPLIES 3
PrasadAthalye
Community Champion
Community Champion

Can you convert variable to string ?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
johnjohn123
Super User
Super User

@PrasadAthalye  why i need to do so?

 

Here is how I was able to set null value to Int variable... What is the response from procedure ? Is it null or empty string?

 

PrasadAthalye_0-1633038500612.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Helpful resources

Top Solution Authors
Users online (3,872)