Table function

Applies to: Canvas apps Desktop flows Model-driven apps Power Platform CLI

Creates a temporary table.

Description

The Table function creates a table from an argument list of records.

The table's columns will be the union of all the properties from all the argument records. A blank value is added to any column for which a record doesn't include a value.

A table is a value in Power Apps, just like a string or a number. You can specify a table as an argument for a function, and functions can return a table as a result. Table doesn't create a permanent table. Instead it returns a temporary table made of its arguments. You can specify this temporary table as an argument for another function, visualize it in a gallery, or embed it in another table. See working with tables for more details.

You can also create a single-column table with the [ value1, value2, ... ] syntax.

Syntax

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

  • Record(s) - Required. The records to add to the table.

Table( Untyped )

  • Untyped - Required. Untyped object that represents a table or array. Acceptable values are dependent on the untyped provider. For JSON, the untyped object is expected to be a JSON array. Note that regardless of the content type of the Untyped array, the resulting table will be a single-column table of Untyped objects.

Examples

  • Set the Items property of a listbox to this formula:
    Table({Color:"red"}, {Color:"green"}, {Color:"blue"})

    The listbox shows each color as an option.

  • Add a text gallery, and set its Items property to this function:
    Table({Item:"Violin123", Location:"France", Owner:"Fabrikam"}, {Item:"Violin456", Location:"Chile"})

    The gallery shows two records, both of which contain the name and location of an item. Only one record contains the name of the owner.