Power Query
Search…
published
Powered By GitBook
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.
1
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"]}))
Copied!
false
Determine if the table ({}) is empty.
1
Table.IsEmpty(Table.FromRecords({}))
Copied!
true
Last modified 3yr ago