Power Query
Search…
published
Table
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
Copy link
On this page
Table.IsEmpty
Description
Category
Examples