cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BHerz
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

 

7 REPLIES 7
bean
Continued Contributor
Continued Contributor

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

bean
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

 

bean
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:

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
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.

 

Bruce

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:
https://powerapps.microsoft.com/en-us/tutorials/control-data-table/

 

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

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

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)