Answered

Number text format dont allow decimals or negatives

(2) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a data card field that I have set to Format: TextFormat.Number

However, when testing this it works perfect for preventing users inputting strings but if they enter negative(-12) or decimal (2.4)

it still work.

For this field I need the input to be whole number only. How may I check and then round the decimals or trim the - symbol?

I can make warning signs and don't let them press submit. But I would really prefer to limit what can be typed in.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Anonymous
You have to make 'warning signs' as you mentioned. There's no way to prevent typing a valid number.

You can restrict input values by using another control type like a pre-defined dropdown of numbers or a Slider control.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@mdevaney

to check for negative and show error I can type
If(Value(TextInput1.Text) < 0)

Would you know how I can check for the decimal?
I dont know how I can check if "." exist in the textinput

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Anonymous
I think you can check for a decimal like this

Mod(your_number_here, 1)<>0

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@mdevaney

Thanks for reply, I use the IsMatch function and look for decimal as a regex pattern it work.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous
Yes, that works too.

Was this reply helpful? Yes No
sahrastolz 30 on at

Like (0)

Report
Copy link

Link copied!

Set the "On Change" property of the input to

If(
Value(Self.Text) < 0,
Set(
varcorrected,
"0"
),
Set(
varcorrected,
Text(
Round(
Value(Self.Text),
0
),
"0"
)
);
Reset(Self)
)

Set the default value of the input to
varcorrected.

Was this reply helpful? Yes No