IsNull
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.
Description
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.
Use
- Input field:
- Select an argument. (Any)
- Output field name:
- Enter an output field name.
