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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for