The IsNull formula function returns a Boolean value.

An IsNull (Filter) function works similarly but instead of returning a Boolean value, allows records which are true to pass on within the Flow.


Checks if the argument's value is null. If the argument's value is null, a true Boolean value is returned. If the argument's value is not null, a false Boolean value is returned. A new column is created for the results.

This function can be of use when pulling in data (e.g., SQL data) where instead of a blank string, the value is null.

Similar functions include IsEmpty and IsBlank.


  • Input field:
    • Select an argument. (Any) 
  • Output field name:
    • Enter an output field name.