Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Format values from Collection Table displayed in Data Table

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?Formatting PowerApp Data Table content.jpg


Continued Contributor
Continued Contributor

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

Continued Contributor
Continued Contributor

Thank you for the prompt reply.

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

Format Error Message.jpg


Continued Contributor
Continued Contributor

Hey, I'm assuming that the number stored in your collection is not a number then, it could be a string. Try this:


Or it could be the two 0's you put on the end instead of using ##?





Let me know how you get on.




Continued Contributor
Continued Contributor

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.



Format Error Message2.jpg




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:


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.


Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,833)