Table.IsEmpty
This function checks if there are any rows in the table. It will return true if the table is empty and false if there are rows present.
This function checks if there are any rows in the table. It will return true if the table is empty and false if there are rows present.
Check if the table contains any data.
Usage:
Power Query M
Table.IsEmpty(
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"]
})
)
Output:
false
Check if the table ({}) is empty.
Usage:
Power Query M
Table.IsEmpty(Table.FromRecords({}))
Output:
true