The Table function creates a table from a list of records or tables provided as arguments directly within the app.
The resulting table includes all columns from the provided records or tables, with any missing values in a column replaced by blank values. If a record does not contain a value for a particular column, a blank is automatically inserted.
It’s important to note that the Table function does not create a permanent table. Instead, it returns a temporary table constructed from its arguments.
This is particularly useful when working with small, static datasets that don’t require a connection to external data sources
Syntax:
Table(Record1, Record2, ...)
Record1, Record2, …: These are the individual records that you want to include in your table. Each record is specified using curly braces {} and contains a set of field names and their corresponding values.
Use of Table function in a Gallery
The Table function can be used as a data source for Galleries.
Suppose you want to create a list of employees with their ID, Name, and Salary, and display this information in a gallery.
Let’s add a Vertical Gallery control to your screen as shown below.
Now, Set the Items property of the gallery to the Table function.
Table(
 {
   ID: 1,
   Name: "Rajesh Kumar",
   Salary: 25000
 },
 {
    ID: 2,
   Name: "Ajay Chauhan",
   Salary: 30000
 },
 {
   ID: 3,
   Name: "Sumit Viyas",
   Salary: 45000
 }
)
This Table function creates a temporary table with three rows and each record in the table is defined by records such as {ID: 1, Name: “Rajesh Kumar”, Salary: 25000}, and the gallery control is bound to display this data.
Recommended for you..
- Gallery control : Design a gallery in Power Apps
- Add Alternate background color to rows
- Sort Items in gallery Power Apps
