Unanswered

Default Field UK/GB Currency Formatting - Help?

(0) Share

Report

Posted on by CorgiMad

Hello, I'm after some assistance with the formatting of the 'Default' field.

The data pulled into the form is from a SharePoint which has various currency columns. Any of the formulated currency columns I've managed to get the currency within Power Apps to show a UK currency. However, the columns which are manually filled in are shown within Power Apps as just digits.

From reading through other posts, I've used the following formula;

Text(Parent.Default,"[$-en-US]$#,###.00")

How do I make the formula work with a UK currency? I've tried the following amendments, but none seem to show the currency symbol of £ or if I do change the $ symbol to a £ symbol. All text within field is removed.

Text(Parent.Default,"[£-en-GB]£#,###.00")

Text(Parent.Default,"[$-en-US]£#,###.00")

Many thanks in advance!

Categories:

Building Power Apps

UK Currency Forma...

I have the same question (0)

All responses (12)

Answers (0)

iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report
Text(Parent.Default,"[$-en-GB]£#,###.00")

Was this reply helpful? Yes No
CorgiMad 87 on at

Like (0)

Report

Thanks for the response. That's one of the examples I've tried but failed.

Was this reply helpful? Yes No
timl 36,393 Super User 2025 Season 2 on at

Like (1)

Report
Hi @CorgiMad

If you specify pass the 3rd language argument to Text like so, does that make a difference?

Text(Parent.Default, "£#,###.00", "en-GB" )

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report
Sorry I've just realised you meant manually typing it in, then you shouldn't be referencing parent but instead the object itself.

Change the OnChange value of your textInput to the following to have it set the text as a variable (gets around the issue of a circular reference):

Set(gblTextValue, Value(Self.Text))

Then, make the Default of your textInput the following (to reference that variable):

Text(gblTextValue,"£#,###.00", "en-GB")

Was this reply helpful? Yes No
CorgiMad 87 on at

Like (0)

Report

Neither @iAm_ManCat and @timl of these suggestions seem to work. When I input either of these, it removes the text from within that field completely.

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Yes, because you've just created the formula and the variable hasn't been set - press the play button and type a value into the field, then click anywhere else to have the OnChange trigger:

Was this reply helpful? Yes No
CorgiMad 87 on at

Like (0)

Report

I've re inputted the formulas within 'OnChange' and 'Default' fields. Pressed play, typed a value and it keeps in the same text to what I've just typed. It hasn't done what you've shown in your recording 🤔

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

did you click outside of the text to another control like I did in the recording?

OnChange for a textbox only changes once you leave the text container

Was this reply helpful? Yes No
CorgiMad 87 on at

Like (0)

Report

I did. It recognises any changes made to the field but doesn't change it to the format required.

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report
I had also assumed you were only typing numbers into the text input, but if you type other characters it won't effectively work as it can't convert them to a value, so I've updated that OnChange formula

Could you replace the OnChange with the following which will strip out any characters that aren't value-based:

Set( gblTextValue, Value( Concat( ForAll( Split( Self.Text, "" ), If( IsMatch( Result, "[0-9.]" ), Result ) ), Value ) ) )

I've attached the POC app showing that the text input that works, please check that your text input doesn't have any conflicting properties or settings.

Input Masking (1)...

Was this reply helpful? Yes No