Answered

Display Manually Entered Text as Currency

(0) Share

Report

Posted on by Phineas

5,331 Moderator

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)

Sort by

AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

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