Power Fx function
RemoveIf — Power Fx function reference
Delete records matching a condition.
Syntax
powerfx
RemoveIf( DataSource, Condition1 [, Condition2, ... ] )
Examples
powerfx
RemoveIf(Tasks, Status = "Archived")
→ Matches deleted
powerfx
RemoveIf(Tasks, Status = "Archived", DueDate < DateAdd(Today(), -90, TimeUnit.Days))
powerfx
RemoveIf(colCart, Item = ThisItem.Item)
Common mistakes & gotchas
- A non-delegable condition on a large tabular source only evaluates (and removes from) the first retrieved page, silently leaving the rest untouched.
- There is no dry-run — test the equivalent Filter() first to confirm exactly which rows will be deleted before switching to RemoveIf.
Related Power Fx functions
From Creating & changing records