Power Fx function
IsEmpty — Power Fx function reference
Test a table for zero rows.
Syntax
powerfx
IsEmpty( Table )
Examples
powerfx
IsEmpty(colCart)
→ true / false
powerfx
If(IsEmpty(colCart), "Your cart is empty", CountRows(colCart) & " items")
powerfx
IsEmpty(Filter(Tasks, Assignee = User().Email, Status = "Open"))
Common mistakes & gotchas
- IsEmpty tests a table for zero rows — passing a scalar value is a type error; use IsBlank for a single value instead.
- Against a large non-delegable source, IsEmpty(Filter(...)) only reflects whether the retrieved page had rows, the same caveat as CountRows.
Related Power Fx functions
From Conditional logic