Comment on page
Table.IsEmpty
Indicates whether the table contains any rows.
function (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.Table.Information
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
Last modified 5yr ago