Power Fx function
DropColumns — Power Fx function reference
Remove columns.
Syntax
powerfx
DropColumns( Table, Column1 [, Column2, ... ] )
Examples
powerfx
DropColumns(Staff, "Email", "Phone")
→ Trimmed table
powerfx
DropColumns(Staff, "SSN", "HomeAddress")
powerfx
ClearCollect(colExport, DropColumns(Orders, "InternalNotes"))
Common mistakes & gotchas
- DropColumns errors if a named column doesn't exist on the table — unlike a selective ShowColumns, there is no silent ignore, so it is brittle against schema changes.
- Commonly used before exporting or displaying data to strip sensitive or irrelevant columns without needing to enumerate every column you do want to keep.
Related Power Fx functions
From Table shaping