{"id":3963,"date":"2019-06-17T09:00:00","date_gmt":"2019-06-17T16:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/improved-data-table-control-with-column-formulas\/"},"modified":"2025-06-11T08:03:30","modified_gmt":"2025-06-11T15:03:30","slug":"improved-data-table-control-with-column-formulas","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/improved-data-table-control-with-column-formulas\/","title":{"rendered":"Improved data table control with column formulas"},"content":{"rendered":"
We are happy to announce a significant update to the Data Table control coming this week.\u00a0 This includes an updated field selection, Text property allowing formatting and calculated values, and better column behavior.<\/p>\n
The new data table control is being released as an experimental option which inserts the new control type instead of the previous type when turned on.\u00a0 Turning on the option will not affect existing data table controls and turning off the option will not remove the new data table controls.\u00a0 This allows trying the new control with an existing app that contains the previous data table.<\/p>\n
Find \u201cEnable improved data table control selection and Value property \u201d under the Experimental section and turn the setting On.<\/p>\n

\n
<\/p>\n
When the new data table control is inserted, you will see (Experimental) after the control type name at the top of the property pane.\u00a0 Any data table controls added when the flag is off will be the previous controls without the indicator.<\/p>\n
<\/p>\n
The new data table control now has the updated field selection experience like the form control.\u00a0 It shows the fields in the control and uses a call out to add existing fields.\u00a0 For Common Data Service entities, the add field call out also allows creating new entity fields as outlined in Add new fields while creating your canvas app<\/a>.<\/p>\n The column controls under the data table are named using the field’s display name.\u00a0 This now aligns with the form data card naming and makes for easier reading.<\/p>\n The previous control’s Text<\/strong> column property was renamed to Header Text<\/strong> to better match the various header properties on the data table control.\u00a0 This also allows to use a familiar property name Text to manage the column data display.<\/p>\n With the ability to write formulas for the Text<\/strong> property, the data table can support formatting and calculated values for each cell.\u00a0 The fields added into the control use the\u00a0ThisItem<\/strong> variable in the Text property which has the fields from the record shown in a single row.\u00a0 By changing the default formula, data can be easily formatted.<\/p>\n In the previous example, I changed the ‘Modified On’ field which is a Date Time type from the default LongDateTime<\/strong> format to a ShortDate<\/strong> format.<\/p>\n Calculated fields can be created by editing an existing column and using other fields from the ThisItem<\/strong> variable.<\/p>\n In the previous example, I concatenate the ‘Address 1: City’ and ‘Address 1: State’ fields by editing the Text<\/strong> property to the following.<\/p>\n When the header text for a column needs to change like when an existing field is made into a calculated field, the Header Text<\/strong> property can be edited like the following.<\/p>\n
<\/p>\nConfiguring column controls<\/h2>\n
<\/p>\n
<\/p>\n'Modified On_Column1'.Text = Text(ThisItem.'Modified On',DateTimeFormat.ShortDate)<\/strong><\/pre>\n
<\/p>\n'Address 1: City_Column1'.Text = ThisItem.address1_city & \", \" & ThisItem.'Address 1: State\/Province'<\/strong><\/pre>\n
<\/p>\n