Answered

Handling the number blanking issue

(0) Share

Report

Posted on by Andrew260z1

I've recently come across the number blanking issue (and don't want to have to go and make all my number columns back to text). What I have discussed is that if the number value field is changed and it is blank then can I default it to 0. So it becomes an issue when the user enters a number but then goes back edits it and "clears" it -> clicks save then the number will just remain.

Looking at using the OnChange for the text box to do something like this

If(IsBlank(txtStandbyDays),txtStandbyDays.Text=0)

But it doesn't work. I guess I could create a context value for each field but there are ALOT of fields and do it that way?

Or just put a disclaimer on each numeric field..

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Andrew260z1

Can you try to set the configuration as:

TextInput1 -> Default -> 0

TextInput1 -> OnChange -> If(IsBlank(TextInput1.Text),Reset(TextInput1))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@Andrew260z1，
Based on the issue that you mentioned, do you want to set the TextInput to "0" when you clear it?
Confirm that if you edit a TextInput and clear the number within means that you want to populate the TextInput with the "0" value.
Could you please share a bit more about your scenario,:
How you set the Default property of the TextInput?
Do you have this TextInput within an EditForm?
If it is in an EditForm, set the Update property of the data card corresponding to the TextInput control as below:

If(IsBlank(txtStandbyDays.Text),"0",txtStandbyDays.Text)

Set the Default property of the TextInput as below:

ThisItem.ColumnName

If it is a single TextInput, it depends on how you set the Default property of the TextInput. You can refer to @yashag2255 's solution.
You could set the Default property of the TextInput as below:

"0"

Set the OnChange property of the TextInput as below:

If(IsBlank(txtStandbyDays.Text),Reset(txtStandbyDays))

Best Regards,
Qi

Was this reply helpful? Yes No
Andrew260z1 83 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks the response. I ended up resetting to the current value on change so they can at least see the number was not cleared when they clicked off. I didn't want to default everything to 0 by default. And have put a message on the form as well. Hopefully that will sort it out

Was this reply helpful? Yes No