PowerApps update data table columns

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:

  • Title
  • Price
  • Colour
  • Review
  • Ram

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.

PowerApps update datatable columns
PowerApps update datatable 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”.

powerapps update data table
powerapps update data table

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.

how to update data table in powerapps
powerapps update data table

Title column I have added the rule of discount. After discount whats, the price. So Price column -> Text -> “ThisItem.Price-ThisItem.Price*30/100”

powerapps update data table column
powerapps update data table

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”.

powerapps add column to data table
powerapps update data table

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”.

powerapps add column to data table
powerapps update data table

You may like following PowerApps tutorials:

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.

>