I have a Collection which contsins a table
The content of the Collection is diplayed in a PowerApp Data Table Control
The format of the data does not display any formatting such as $ or , normally available in other controls using the Text( XXX,"$##,#") Formatting.
See Screen shots below
How do I format the content of a DataTable?
Try Text(TheNumber,"[$-en-US]$###,###.##")
Thank you for the prompt reply.
When attempting to format the content of the Data Table value I receive the following Error Message.
Hey, I'm assuming that the number stored in your collection is not a number then, it could be a string. Try this:
Text(Number(TotRSAvailable),"[$-en-US]$###,###.##")
Or it could be the two 0's you put on the end instead of using ##?
Text(TotRSAvailable,"[$-en-US]$###,###.##")
Let me know how you get on.
Sean
If that doesn't work, I'm afraid I'll be stiff out of answers sorry.
Thanks for the help.
I still have not been able to format the data.
I have used the format you suggested many times with normal Text boxes. \But, since this is a data table control there may be different formatting syntax.
FYI here is the most recent error message.
Bruce
Hi BHerz,
As you are using Data table control, I am afraid it might be not possible to format the data in Data table control.
Please check the two parts “Now available” and “Not yet available” in this doc for a reference:
https://powerapps.microsoft.com/en-us/tutorials/control-data-table/
Best regards,
Mabel Mao
User | Count |
---|---|
257 | |
110 | |
97 | |
52 | |
39 |