currency value

(0) Share

Report

Posted on by Sharuk

202

Hi All,

I'm having an input text value as shown below

now the requirement is like can we able to format the entered number into proper currency format while entering the number value in the text field. if the user is trying to 10000 the value should be automatically update as 10,000 similarly if user is trying to enter some million value it should be updated as 1,000,000 on the onchange property itself. is it kind of possible ? any suggestions or help here ?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

OnChange of the textbox:
Set(
FormattedNum,
Text(
Value(TextInput1.Text),
"[$-en-US]#,###,###"
)
);
Reset(TextInput1);

Default of the textbox:
FormattedNum

Was this reply helpful? Yes No
Sharuk 202 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @zmansuri,
thanks, it worked but I've observed some delay while updating, can we minimize much more time here ?

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

It's on OnChange, So when you enter the number and press tab it will reflect then only.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sharuk,

Have you solved your problem?

Do you want the format currency to display in real time within the TextInput?

As @zmansuri mentioned, this OnChange setting will render for a while which is by design.

As an alternative solution, to solve the delay issue, I think you could add a Timer and set its Visible property as false for the UI look.

1). Here is something change you should set the properties of the Timer

OnTimerStart:

Set(CurrencyF,Text(Value(TextInput18.Text),"[$-en-US]#,###,###"))

Duration property: 1

Repeat property: true

AutoStart property: true

AutoPause property: true

2). Here is something change you should set the properties of the Text Input

Default property: CurrencyF

DelayOutput property: false

Hope it could help you at some degree.

Was this reply helpful? Yes No