Power Apps Data table Control [How to Use With Examples]

Have you ever worked with a Power Apps Data table Control? If Not, then follow this complete tutorial to learn everything in detail.

In this Microsoft Power Apps tutorial, I will explain how to use the Power Apps Data table control with various properties.

Moreover, you will learn how to add a Data table in Power Apps and many more like:

  • Display Data table Items Manually in Power Apps
  • How to display SharePoint list items in Power Apps Data table
  • Power Apps Data table limitation
  • Power Apps Data table availabilities and non-availabilities

Power Apps Data table Control

Power Apps Data table control is an interface that displays a dataset in a tabular format with column headers representing the fields shown.

As an app maker, you have complete autonomy over the fields’ selection and order displayed. Like the Gallery control, the Data table control maintains a selected property that refers to the highlighted row. Consequently, you can link the Data table control to the other controls.

Data table in Power Apps

Power Apps Data Table Control Properties

This section will explain the Power Apps data table control properties:

PropertiesDescription
AccessibleLabelThis property is assigned to a screen reader label.
Border ColorA user can specify the color for a border.
Border StyleThis property specifies the type of border that the control should have [“Solid,” “Dashed,” “Dotted,” “None”].
ColorThe default color for the text in all data rows is what, exactly.
FillThis property displays the background color of the control.
HeadingColorSpecify the text color for the column headings.
HeadingFillSpecify the background color for the column headings.
ItemsWe can specify the data source to represent the items in a data table.
NoDataTextThe message the user receives when no records are displayed in the Data table control.
SelectedColorSpecify the text color in the selected row.
SelectedFillSpecify the background color in the selected row.
SizeThe default font size for all data rows.
VisibleHere, we can specify whether the data table control can be visible.

These are the Power Apps data table control properties.

How to add Data table in Power Apps

I will show you how to add the Power Apps Data table here.

  • Sign in to your Power Apps with your valid Microsoft 365 credentials.
  • Create a Blank canvas app -> On the Power Apps screen, insert a Data table control [Click on +Insert -> Expand Layout -> Select Data table Control]
Add Power Apps Data table
  • The data table control will appear like the screenshot below:
How to add Data table in Power Apps
  • By default, the Data table control name will be “DataTable1“.
How to add Power Apps Data table

This is how to add a Data table in Power Apps

Display Data table Items Manually in Power Apps

This section will show you how to manually display the Power Apps Data table items.

For Example, I created a blank canvas app and added a Data table control. Later, I displayed the data table items manually in Power Apps, as shown below:

Display Power Apps Data table Items Manually

Follow the below steps to achieve this:

  • On the Power Apps screen, insert a Data table control -> Set its Items property to:
["Proximity Sensor","PhotoElectric Sensor", "Passive infrared sensor", "Level sensor"]
Display Data table Items Manually in Power Apps
  • Select the Data table properties pane, and click on the Edit fields -> Click on the Add field -> Select Value -> Click on an Add button as shown below:
How to display Data table Items Manually in Power Apps
  • Once the app is ready, SavePublish, and Preview the app. The Power Apps Data table control items will be added manually.
How to display Power Apps Data table Items Manually

This is how we can manually display the Power Apps Data table items.

Display SharePoint list items in Power Apps Data table

Here, let me show you how to display the Data table items using the SharePoint list.

For Example, I have a SharePoint list [Power Platform Training] that has various columns like:

Column NameData type
User IDTitle
User NameSingle line of text
CourseChoice [“Power Apps,” “Power Automate,” “Power Bi,” “Power Virtual Agent]
Course Handled ByPerson or group
How to display SharePoint list items in Power Apps Data table

I have created a Blank Canvas app from a SharePoint list, then added a Data table control and connected it to the above SharePoint list as shown below:

Power Apps Data table using SharePoint list

Follow the below steps to achieve this:

  • Create a Blank canvas app -> Connect the Data source to a SharePoint list as shown below:
Display SharePoint list items in Power Apps Data table
  • On the Power Apps screen, insert a Data table control -> Set its Items property to:
'Power Platform Training'

Where,

  1. Power Platform Training = SharePoint list name
Display SharePoint list items in Data table using Power Apps
  • Once the app is ready, SavePublish, and Preview the app. The Power Apps Data table control will now be connected to the SharePoint list.
How to display SharePoint list items in Data table using Power Apps

I achieved this by displaying the SharePoint list items in the Power Apps Data table.

Power Apps Data table Control Limitation

Here, I will explain the limitations of the Power Apps Data table control.

  1. One of the critical and well-known issues with the Power Apps Data control is that applying the FirstN function in the Items property may result in no data being displayed.
  2. When utilizing any PowerApps control, a specific data containment limit must be observed.
  3. For example, the PowerApps Data table control has a limit of 500 records that can be added at a given time.
  4. If your data source is greater than this limit, it may result in delegation warning issues within PowerApps.
  5. However, you can resolve this by modifying the limit of non-delegable functions used on data sources from 500 to a maximum of 2000 records within PowerApps.
  6. To achieve this, navigate to Settings (from the left navigation) -> General -> Data row Limit, and change the limit to 2000. It’s important to note that these limits prevent device overloading with limited local storage.

These are the Power Apps limitations of a Data table control.

Power Apps Data Table Availability and Non-Availability

This section will explain the availability and non-availability of the data table in Power Apps.

AvailabilityNon-Availability
Ensure that the data is present in the Data table.Enabling the selection of multiple rows cannot be done.
The Data table control is read-only.You cannot add a data table control within a form control.
The Data table control always has a single row selected.Adjusting the height of all rows can’t be done.
The Data table control should be linked to a connected or local data source.You cant display images in a data table control.
You can modify the column widths of the Data table control while running the app, but remember that your changes are not saved.Incorporate fields from related tables.
By default, a set of fields will appear in the Data table control when linked to a connector that supports this feature, such as the Microsoft Dataverse. You can show or hide these fields and others as required.You cannot utilize the built-in functionality to filter and sort data by column heading.
Customize the column width and heading text as per your needs.Cannot add a data table control in a gallery control.
You can show hyperlinks within the Data table control.Cannot modify data within the data table control.
Copying and pasting a Data table control is also possible.Enable the selection of multiple rows cannot be done.

Conclusion

Power Apps Data table control displays the items using any data source. In this Power Apps tutorial, I have explained the Power Apps Data table and its key properties.

Moreover, you have learned how to add a data table in Power Apps and display SharePoint list items in the Power Apps Data table.

Lastly, I have covered Data table limitations in Power Apps and Power Apps Data Table Availability and Non-Availability.