Add the possibility to change the alignment of DataTable column contents, also further formatting options would be helpful.
I would also like the ability to wrap text for multiline columns. I want to be able to see all of my data without hovering over each cell to read the entire item.
Inability to right-align numbers and dates make this control virtually unusable for so many purposes. Clients just don't take well to seeing them left-aligned.
This is the most of basic formatting functionality. When will it be available. Unbelievable that it is not possible.
Agreed - lacking basic alignment on headers and columns is really dumb. So easy to implement from MS!
Also agree that there should be alignment options for column headers and contents. Trying to implement a PowerApp, this absence makes numbers or currency columns in particular look messy as is.
Agree with @OCV8 that the inability to right-align numeric fields is a huge hole with this component. I don't know why this does not have 100s or 1000s of up-votes.
Had to vote for this as well. It seems like such a no-brainer. Until the ability to format columns in a data table control is added it's useless for most of the use cases I have for it. I can't include anything with a description or notes because text doesn't wrap and columns can't be formatted individually. Even putting a formula into a column's "Text" control that displays currency doesn't allow me to format it; despite the formula appearing to be fine.
This solution may be too late for you guys....
I wanted to right align my number columns and I searched online only to find out that there isn't a solution out there. However, I came up with a way to right align a data table column. It it is not elegant but it worked. You can use the text property to format your values. Here is the formula that I used:
Right(Substitute("xxxxxxxxxxxxxx", "x", Char(127)) & Text(ThisItem.YourColumnName, "#,###,0.00"), 14)
In this case, I wanted a numeric column to be right aligned within 14 characters. So I packed a non printable character in front of the numbers up to a length of 14. A space didn't work because only one is displayed. I checked the ASCII table for another character that would be repeated but not shown and came up with ASCII code 127 (DEL).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.