This PowerApps tutorial explains, how to update data table columns in PowerApps.
We will see in the below example, how to update the Price column and title columns of a PowerApps data table.
PowerApps update data table columns
I have a SharePoint Products list of columns:
I have created a PowerApps blank template. Then I have added a DataTable Control from Insert -> Data Table. Connect the Data Table control to Products List.
After giving the connection you will get all the SharePoint list columns in the data table. In the right-side panel of PowaerApps desktop, you will get Properties -> Fields.
From the Fields option, you can select what are the fields you want to display in the PowerApps Data Table.
Now we will see with one example of how to update the data table fields in PowerApps.
Suppose one discount will come off 30% of all the product prices. And we want to display the Price value after discount in the data table.
Data Table all the columns are in view mode you can not update the columns.
So we need to enable a Data Table feature PowerApps Provides. Go to File tab-> App settings->Advanced settings->Enable the “Enable improved data table control selection and Value property”.
We can not refresh the DataTable. After enabling the feature when we will add the data table again we will get the below screenshot. In the right side top, we will get “Data Tabel(Experimental)”. On the left side under the “Data Table_1”, we can see all the column name.
Title column I have added the rule of discount. After discount whats, the price. So Price column -> Text -> “ThisItem.Price-ThisItem.Price*30/100”
We can concatenate some columns and represent them in a single column. Here I have concatenated Title, color and review columns and represent the output in the title column. So in Title -> Text-> “ThisItem.Title&”/”&ThisItem.Colour&”/”&ThisItem.Review”.
We can change the title column heading also. So in the Header Text-> Title/Colour/Review. So the header name of title columns will be changed to “Title/Colour/Review”.
You may like following PowerApps tutorials:
- PowerApps Functions Tutorial
- Export PowerApps from one Tenant to another Tenant
- Working with PowerApps Collection
- How to create tabs in PowerApps in SharePoint Online List Form
- PowerApps navigate between screens
- PowerApps: Create a navigation menu using the Gallery Control
- PowerApps Employee Engagement Survey Example
- PowerApps Media Control
- PowerApps submit form to SharePoint Online list
- Display SharePoint Online List Columns in multiple screens in Microsoft PowerApps
- Microsoft PowerApps: Create Login Screen
- PowerApps Replace Function with examples
In this article, we learned how to update the PowerApps Data Table fields. We also saw how to change the header text of the data table column in PowerApps desktop.
I am Bijay a Microsoft MVP (8 times – My MVP Profile) in SharePoint and have more than 15 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com