Answered

Do not allow null or blank in a numeric field while in edit or new form

(0) Share

Report

Posted on by AnnetteM

I am using a SharePoint list as a data source. The list has many columns that are numeric fields, tracking expenses in different areas. The default values of these numeric columns is 0. In my Power App, I do not want a user to delete the default value of 0 (or any amount) and make it null or blank. In other words, the field should contain an amount such as 59.62, or 0 if someone deletes an amount -- but never null or blank. How can I assure this occurs when the form is submitted?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

BhargavPatel 660 Moderator on at

Like (0)

Report
Copy link

Link copied!
@AnnetteM on the database side, make the field required. That will throw an error when user tries to save the Form without any value in the field. This will also add asterisk in the DataCard to let user know it is a required field.

Alternatively, on the app side, you can unlock the DataCard,

and then, change the Update property of the DataCard to:

Coalesce(Value(DataCardValue.Text),0)

So, when the form is submitted, it will enter 0 in the field if nothing was entered.

Was this reply helpful? Yes No
BCBuizer 22,510 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @AnnetteM ,

Assuming you are using a form, you can add some verification to the OnSelect property of the button that is used to submit the form, for instance:

If( IsBlank(DataCardValue1.Text) || Value(DataCardValue1.Text) <= 0, Notify("Blank or null values are not allowed"), SubmitForm(Form1) )

The above will give a notification to the user if the DataCardValue1 text input control where they need to enter the number is blank or equal or smaller than 0. Else the form is submitted.

Was this reply helpful? Yes No