Power Query
published
Search
K
Comment on page

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