Answered

Why won't my text box format the value as currency?

(0) Share

Report

Posted on by futr_vision

831 Moderator

I'm a little baffled here. I have an edit form being populated by a gallery selection. On one of the text input field I am using this code in the OnChange property.

Text(
 Value(TXT_BudgetReview.Text),
 "[$-en-US]$#,##0.00"
);

In the preview it appears to understand what to do with the value populated in the text field but the text field just no formatting.

What's happening here?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

futr_vision 831 Moderator on at

Like (0)

Report
Copy link

Link copied!

Thanks. I'll need to revisit this. It's ultimately a cosmetic issue. Thanks for the help.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Copy link

Link copied!

Hi @futr_vision,

If you check our official doc about the Timer, you should have known that the Duration property of the Timer will trigger the Timer in a customized duration.

And yes, in a customized duration, Timer will auto-start and generate this varaible.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report
Copy link

Link copied!

Thanks. The timer overrides the built in timer for the OnChange property? Just want to make sure before I apply this to every control.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Copy link

Link copied!

Hi @futr_vision,

That's the limit of the OnChange property, it is by design.

You could consider using a Timer, set the following properties:

Then set the OnTimeStart property as the Set() function, apply the If() function to the Default property of the TextInput.

Remember to set the Timer Visible as false to make the UI friendly.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report
Copy link

Link copied!
Ok. I see. I need to drop that code on the OnSelect of the gallery item and change it the 'target' tp ThisItem.columnname . Then put varCurrency as the default for the text input. Here is my problem. When I update the record and submit that text input continues to show varCurrency until I reset varCurrency with the same gallery selection.

This seems to work. I set Default of the text input to the expression below. There is a slight delay in the refresh that makes it seems wonky. Is there a better way?
If(Not(IsBlank(varCurrency)), Parent.Default, varCurrency)

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

when you select a gallery item just apply the same logic Qi gave for manual input to the OnSelect of the gallery item so that varCurrency is generated

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report
Copy link

Link copied!

I implemented this solution but now have this issue:

When I select a gallery item the field is now blank instead of being populated by the gallery record. I suspect this is because I replaced Parent.Default with varCurrency.

It does format the text correctly when I enter a new value however. That is working. I just need it to format the text being pulled in from the gallery selection and format and text entered.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report
Copy link

Link copied!

It's a Text Input so no Text property

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Copy link

Link copied!
Hi @futr_vision,

Your format formula is correct, however, OnChange property expects a behaviour formula, Text() is not a behaviour formula.

And, only when the input from the TextInput of the Budget data card changes, the OnChange property will be fired.

Set the OnChange property as:

Set(varCurrency,Text( Value(TXT_BudgetReview.Text), "[$-en-US]$#,##0.00" ) )

Set the Default property of the TextInput control corresponding to Budget data card as:

varCurrency

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

what code do you have in the Text property.

Was this reply helpful? Yes No