List.IsEmpty
Whether a list has no items at all.
Group: List. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
List.IsEmpty(list as list) as logical| Parameter | Type | Description |
|---|---|---|
list | list | The list to test. |
Returns
logical. true for {}, false otherwise.
Remarks
- A list that holds only nulls is not empty:
{null}has one item.
Examples
No open orders
List.IsEmpty({})trueA null is still an item
List.IsEmpty({null})false