Table — Power Fx function reference

Syntax

Table( Record1 [, Record2, ... ] )

Examples

Table({n: 1}, {n: 2})

Table({Label: "Q1", Value: 100}, {Label: "Q2", Value: 150})

ClearCollect(colStatusOptions, Table({Status: "Open"}, {Status: "In Progress"}, {Status: "Closed"}))

Common mistakes & gotchas

• Records passed to Table should share a compatible shape — a later record missing a column relative to the first gets that column filled with blank rather than erroring.
• Handy for building a small static lookup or options table inline (like a dropdown's Items) without a real data source or collection.

Related Power Fx functions

From Table shaping

Used in these tutorials