Table.IsEmpty

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

Table.IsDistinct

Table.Join

Last modified 4yr ago