How to format a field input with thousands and decimals separator

(1) Share

Report

Posted on by WebPortal

2,295

Hello,

I have the field as per image below and I need the user to type a number that get automatically formatted with thousands and decimals separator.

Anotação 2020-04-18 133609.png

How to do this?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

eka24 20,923 on at

Like (1)

Report

Use:
If it a textbox:
      Text(Value(TextInput3.Text),"[$-fr-FR]#.###,00","fr-FR")

If it a HintText/Placeholder (See Attached)
1. Set a variable OnStart of the App or OnVisible of the Screen
(If you use OnVisible, after the formula, navigate to ther screen for it to take effect)
       Set(MyFormat,Text(Value("1000"),"[$-fr-FR]$#.###,00","fr-FR"))

2.In the Hintext of the TextBox, put:
      "Enter"&" "&MyFormat
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

hint2.JPG

Hint1.JPG

Was this reply helpful? Yes No
WebPortal 2,295 on at

Like (1)

Report

Thanks @eka24

But WHERE do I write: "Text(Value(TextInput3.Text),"[$-fr-FR]#.###,00","fr-FR")"

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (1)

Report

Dont use the part as you are not using it for the textbox. Ignore it
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
NziokiB 83 on at

Like (1)

Report

@eka24 @WebPortal This is an old post; however, a posting this to the future learners.

A much simpler way would be to put your desired number format in the DEFAULT property of your text input control i.e., Text(ThisItem.FieldName,"#,##0.00"). In my case, I have my field name as an item in a collection in ON APP START. Text(ThisItem.'Pump Nozzle Reading',"#,##0.00").

Was this reply helpful? Yes No