Format values from Collection Table displayed in Data Table

[BHerz]

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?

[bean]

Try Text(TheNumber,"[$-en-US]$###,###.##")

[bean]

Source: https://powerusers.microsoft.com/t5/PowerApps-Forum/Currency-and-decimal-format/td-p/14809

[BHerz]

Thank you for the prompt reply.

When attempting to format the content of the Data Table value I receive the following Error Message.

[bean]

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

[bean]

If that doesn't work, I'm afraid I'll be stiff out of answers sorry.

[BHerz]

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

[v-yamao-msft]

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