Unanswered

Display Manually Entered Text as Currency

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I have TextInput1, in which I would like the manually entered content to appear as US currency.

The field is a number format is Power Apps and currency in SharePoint list.

I am attempting the following formula, but with no success.

Is this possible? What am I missing?
Text(Value(Self.Text),"[$-en-US]$###,###")

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report

Hi @Phineas,

You are trying to show the number value entered in the TextInput control as Text with the format of US currency?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @Phineas ,

Please try:

1\Set it's OnChange property to:

If(IsMatch(Self.Text,"\d*"),Set(TemValue,Text(Value(Self.Text),"[$-en-US]$###,###"));Reset(Self))

2\Set it's Default property to:

TemValue

Best Regards,

Bof

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

Yes

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

I've got the following working, kind of.

Two issues -
1. The is a gallery, so there may be default data. How do I add 'ThisItem.Currency' to the formula so that it
incorporates any data being pulled into the gallery field?

2. The test amount should show as $123,456.00. How do I get the commas and decimals to reflect -
$000,000.00 (hundreds of thousands with two space decimal point for cents?

Current formula -
If(IsMatch(Self.Text,"\d*"),Set(TemValue,Text(Value(Self.Text),"[$-en-US]$###,###"));Reset(Self))

Was this reply helpful? Yes No