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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,599)