The IsEmpty()
function checks whether a value is empty.
Syntax
IsEmpty(value)
Returns
A boolean value that indicates if a value is empty.
Note: The HasValue() function checks the opposite of this function.
Parameters
value
– any value
If the value is a list, then the IsEmpty
function checks if the list has 0 rows.
Examples
IsEmpty("The world's greatest") /* false */
IsEmpty("") /* true */
IsEmpty(UnknownText) /* true */
IsEmpty(3) /* false */
IsEmpty(0) /* false */
IsEmpty(UnknownNumber) /* true */
IsEmpty([List]) /* false is the list has rows and true if the list has 0 rows */
IsEmpty([Name] of [Products]) /* false is the list has rows and true if the list has 0 rows */