Formatting a number with a comma (#,###)

(0) Share

Report

Posted on by Kirsten2

383

I have tried the following:

Text(Gallery_R_EQ_ShoppingCart.Selected.Title,"#,#")

This is on the Default property of a field to show a selected gallery item field named Title.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

mmollet 3,187 on at

Like
a
(1)

Report
Copy link

Link copied!

Text(Gallery_R_EQ_ShoppingCart.Selected.Title,"0,0##")
or
Text(Value(Gallery_R_EQ_ShoppingCart.Selected.Title),"0,0##")

This will depend on the data type of your Title column. If it is number then use the first one and if it is text then use the second one. Also for the formatting I used, the 0's will show a 0 if there is no number in that place and the #'s will only show a number if there is a non-zero number in that position.

Ex1: 12.1252 -> 12.125
Ex2: .9836 -> 0.984
Ex3: 6 -> 6.0

Was this reply helpful? Yes No
Kirsten2 383 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you!

Was this reply helpful? Yes No
Kirsten2 383 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, I just noticed for numbers that are below 1,000 it puts commas too.

Example: 789
Becomes: 0,789

Is there a way to fix that?

Was this reply helpful? Yes No
Verified answer

Kirsten2 383 on at

Like
a
(0)

Report
Copy link

Link copied!

I got the solution:

Text(Value(Gallery_R_EQ_ShoppingCart.Selected.Title),"#,#")

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

Text(Value(TextInput4_1.Text), "##,##0.0#")

This will add commas to separate 3 digits and will always show a decimal of at least .0
Your Example should show up as 789.0 now and if you add another 9 to the end it should display 7,899.0. If you dont want the 0's then replace the 0's with #'s in the formula. A leading 0 placeholder is usually nice as it helps users see the decimal point and know the value is less than 1.

Was this reply helpful? Yes No