As far as we know, Power Apps have a variety of input controls with distinctive properties. One of the most useful controls among them is the Power Apps Data table.
This Power Apps tutorial will assist you in knowing what is a data table in Power Apps and how to use it with various examples.
We will also talk about some additional Power Apps Data table-related topics, such as:
- Add items manually in a Power Apps Data table
- Bind SharePoint list items in a Power Apps Data table
- How to add a custom column in the Power Apps data table
- Connect Power Apps Data table control to another control
- Availability and Nonavailabilty in Power Apps Data table
- Power Apps data table limit
Power Apps Data Table
One control that can be used to show a lot of data in a tabular form is the Power Apps Data Table. The data table contains a header for each field that the control displays.
Similarly to the Power Apps Gallery Control, the Data table control contains the selected property that directs to the selected row. The data table control can be linked to other controls as well.
Below are some of the important properties of the Power Apps Data table control:
| Property | Description |
|---|---|
| Items | Defines the source of data that appears in the Data table control. |
| Selected | Specifies the selected row in the Data table control. |
| FieldDisplayName | Defines the property of a column inside a data table that defines the display name for the selected column. |
| IsHyperlink | Specifies the property of a column inside a data table that defines whether the selected column should be in hyperlink format or not. |
| Text | Specifies the property of a column inside a data table that defines whether the selected column should be in hyperlink format. |
NOTE:
The most significant and well-known problem with Power Apps Data control is that no data shows up if you use the FirstN function in the Items property.
Add Items Manually in Power Apps Data Table
- To add items manually in a Power Apps Data table control, insert a Data table [+ Insert -> Search Data table -> Select Data table (preview) under the Layout section] to the screen.
- Select the data table and set its Items property as:
Items = ["Anna Karenina", "Beloved", "The Color Purple", "Things Fall Apart"]You must ensure your items should be enclosed with a bracket ([]) and an inverted comma (“”).
- To add the value to the data table, go to the Properties pane -> 0 selected from the Fields section -> + Add field -> Select Value -> Click Add, as shown below.
- Now, the Power Apps data table will appear with the items below.
- If you want to rename the table header text, then select the data table -> go to the Properties pane -> Header Text -> Rename the header [Best Top Novels].
This way, we can insert items manually in the Power Apps Data table control.
Add SharePoint List Items in Power Apps Data Table
Next, we will see how to insert items from the SharePoint list into a Power Apps Data table control.
- I have a SharePoint list named TSInfo Attachments. These are the columns below:
| Column | Data type |
|---|---|
| ID | Number |
| Title | Single line of text |
| Is Received | Yes/no |
| Attachment Types | Choice [Microsoft Document, PPT, PDF, Excel] |
| Attachment Costs | Currency |
| Attachment Created Date | Date and time |