Table.IsEmpty
Table.IsEmpty(table as table) as logical
Indicates whether the table
contains any rows. Returns true
if there are no rows (i.e. the table is empty), false
otherwise.
Determine if the table is empty.
Usage
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
Determine if the table ({})
is empty.
Usage
Table.IsEmpty(Table.FromRecords({}))
Output
true