How to save a text box with Blank along with validation

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi team,

I want to save a text box with validation.

however it is working fine, but on top of this, we want to save along with blank.

When I try to save with blank value, the second condition is triggering with "Upto One decimal value is allowed, please try again!"

The requirement is

"the textbox field should only allow positive values between 0 until 24.0 (one decimal) because we would like to capture how many hours they spent on this task. we assume no one is working more than 24 hours on any tasks
but the filed can be optional (blank) if they don`t want to capture any data"

any assistance, please how can I save with blank value.

If(
Value(txtEfforts_2.Text) > 24,
Notify(
"Maximum Efrort value should not Exceed 24, please try again!",
NotificationType.Error
) Or Value(txtEfforts_2.Text) / Value(
RoundDown(Value(txtEfforts_2.Text),1)
) <> 1,
Notify(
"Up to One decimal value is allowed, please try again!",
NotificationType.Error
) )

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous :

Use this method to verify, no error will be reported even if the value is empty

If(
Value(txtEfforts_2.Text) > 24,
Notify("Maximum Efrort value should not Exceed 24, please try again!",NotificationType.Error),
Value(txtEfforts_2.Text) / Value(RoundDown(Value(txtEfforts_2.Text),1)) <> 1 And !IsBlank(txtEfforts_2.Text),
Notify("Up to One decimal value is allowed, please try again!",NotificationType.Error)
)

Best Regards,

Bof

Was this reply helpful? Yes No