cancel
Showing results for 
Search instead for 
Did you mean: 

Format Data Table Columns

This may have been suggested before.  It would be great if it was possible to format the way data displays in a data table.  For example round numbers from a SharePoint list display with a decimal point and a host of trailing zeros.  Also, date format appears fixed to US style.

 

Apologies if this is merely exposes my inability to work with PowerApps.

Status: Completed

Marking this request as completed with the experimental release announced in https://powerapps.microsoft.com/en-us/blog/improved-data-table-control-with-column-formulas/.  Please reach out with feedback on this improved control behavior.

Comments
PowerApps Staff
Status changed to: Under Review
 
Level: Powered On

I agree this should be implemented, but you can use the steps described in this blog by @CarlosFigueira as a workaround.

Level: Power Up

The workaround would not help in scenarios where RTL support is required, for example.

Level: Powered On

This is a basic requirement that should be implemented. 

Level: Powered On

Can we also add alignment (left/right), formating (e.g. #,##0_);[Red](#,##0);-) and subtotal/total?

Thanks.

PowerApps Staff
Status changed to: Completed

Marking this request as completed with the experimental release announced in https://powerapps.microsoft.com/en-us/blog/improved-data-table-control-with-column-formulas/.  Please reach out with feedback on this improved control behavior.

Level: Power Up

@aorth Feedback for this Data table Control experimental functionality. I have noticed that using 'LookUp' function doesnt work as required. It doesn't return the required value for each records individually but rather duplicate one record returned value for every records in the data table. Would be nice for this functionality to work for Lookup referenced fields.

 

Referring to the new functionality below:

https://powerapps.microsoft.com/en-us/blog/improved-data-table-control-with-column-formulas/