ShowColumns — Power Fx function reference

Syntax

ShowColumns( Table, Column1 [, Column2, ... ] )

Examples

ShowColumns(Staff, "Name", "Department")

ShowColumns(Staff, "Name", "Email", "Department")

ClearCollect(colLite, ShowColumns(Filter(Orders, Status = "Open"), "OrderNumber", "Amount"))

Common mistakes & gotchas

• Pair with Filter to cut down delegated payload size.
• ShowColumns keeps only the named columns and drops everything else — filter rows first, then shape columns, to minimize the payload pulled from a remote source.
• Like DropColumns, naming a column that does not exist causes an error rather than being silently skipped.

Related Power Fx functions

From Table shaping

Used in these tutorials