List.IsEmpty is a Power Query M function that checks if a list is empty. The function returns true if the list is empty, and false if it contains values.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
List.IsEmpty( list as list ) as logicalDescription
Returns true if the list, list, contains no values (length 0). If the list contains values (length > 0), returns false.
Examples
Find if the list {} is empty.
// Output: true
List.IsEmpty( {} )Find if the list {1, 2} is empty.
// Output: false
List.IsEmpty( {1, 2} )Related functions
Other functions related to List.IsEmpty are:
