Answered

Format text for currency

(1) Share

Report

Posted on by iskguy

402

I am formatting a value to display as currency (USD) using Text(ThisItem.SubmittedAmount,"$#,###.##"). However, if a value is a whole number, like 80, it shows as $80. without the 00. How can I format the regex to show that 00, or is it a matter of the underlying sharepoint column property.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

anandm08 1,936 Super User 2024 Season 2 on at

Like (2)

Report
Copy link

Link copied!
hi @iskguy ,
try this code:
Text(ThisItem.SubmittedAmount, "$#,###.00")

Was this reply helpful? Yes No
iskguy 402 on at

Like (1)

Report
Copy link

Link copied!

I did and get the same

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!
@iskguy ,
If the previous approach didn't work, you can ensure the number always shows two decimal places by using a more explicit formatting approach

Text(ThisItem.SubmittedAmount, "$#,###.00")

If this still doesn't work as expected, you can use an If statement to handle cases where the value is a whole number and append .00 manually. Here's how you can do it:

If( RoundDown(ThisItem.SubmittedAmount, 0) = ThisItem.SubmittedAmount, "$" & Text(ThisItem.SubmittedAmount, "#,###") & ".00", Text(ThisItem.SubmittedAmount, "$#,###.00") )

Was this reply helpful? Yes No
Verified answer

rzuber 545 Moderator on at

Like (1)

Report
Copy link

Link copied!

[EDIT]
Deleted because the next answer is the most likely fix for this issue where the user's value is a text value instead of a number value.

Was this reply helpful? Yes No
Verified answer

rzuber 545 Moderator on at

Like (1)

Report
Copy link

Link copied!
Or:

Text(Value(ThisItem.SubmittedAmount), "$#,###.00")

I suspect this is your issue because when you use Text() on numbers that are encased in text, you do not get the proper format. You need to convert the text to a number value to get the proper format.

Was this reply helpful? Yes No
iskguy 402 on at

Like (1)

Report
Copy link

Link copied!

Thanks! This one seems to work actually!

Was this reply helpful? Yes No
rzuber 545 Moderator on at

Like (1)

Report
Copy link

Link copied!

@iskguy Did you accept the correct solution? I deleted that one because I tested it, and got the same result you kept getting, so I posted the second response.. Did the first one actually work, or was it actually the second one? I'm now confused.❔🙂

Was this reply helpful? Yes No
iskguy 402 on at

Like (2)

Report
Copy link

Link copied!

This one worked:
Text(Value(ThisItem.SubmittedAmount), "#,###.00")

Was this reply helpful? Yes No
rzuber 545 Moderator on at

Like (1)

Report
Copy link

Link copied!

@iskguy OK great! I was hoping that was the case. No longer confused. I hope all your future issues are this easy to solve.

Was this reply helpful? Yes No