Display Manually Entered Text as Currency

Like (0) Share

Report

Posted on 26 Mar 2024 02:32:34 by Phineas

5,106 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:

General Questions

All responses (4)

Answers (1)

Phineas 5,106 Super User 2025 Season 2 on 26 Mar 2024 at 15:17:48

Like (0)

Report

Re: Display Manually Entered Text as Currency

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))
Phineas 5,106 Super User 2025 Season 2 on 26 Mar 2024 at 04:31:34

Like (0)

Report

Re: Display Manually Entered Text as Currency

Yes
Verified answer

v-bofeng-msft on 26 Mar 2024 at 02:39:53

Like (0)

Report
Re: Display Manually Entered Text as Currency

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
AARON_C 2,233 Most Valuable Professional on 26 Mar 2024 at 02:36:20

Like (0)

Report

Re: Display Manually Entered Text as Currency

Hi @Phineas,

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