Power Apps

Simple question about decimals

(0) Share

Report

Posted on by Power_rookie

Hello everyone.

I am testing a very simple Power App. I need to fill some numbers and then send them to a SQL table. It sounds easy.

I am testing the On-Premise Data Gateway and everything seems to work fine, I can reach my sql test table :-)

Simple question, I need users to use dot as decimal separator, not comma. But if I configure the form field as Format = TextFormat.Number, Power Apps only allows me to input numbers (ok), and comma.

After that, if I send that info to my sql table, everything is ok, but I would like users to use dots, not comma, like the use in the rest of their applications.

I've tryed to change my Format Options in Advanced Settins of my Power Apps, but still can't use dot as decimal separator.

Any advice would be welcome.

Thanks.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hey

what kind of input control do you use? try a textinput control with Text (to be found on the right side of the screen in the pane) and not number.

cheers
Suggested answer

Power_rookie 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello mmbr1606

do you mean to use Format = TextFormat.Text ? So, if I allow text, Iwould have to control that they can only write numbers and dots, not letters.

Can we do that on this in that textinput?

Sorry for this basic question.

Thanks.
Power_rookie 10 on at

Like
a
(0)

Report
Copy link

Link copied!

...maybe the way to go is to enable Text format, and then, allow only numbers and dot, with only 2 decimals in the OnChange Property. Isn't it?

:-)