Showing results for 
Search instead for 
Did you mean: 

Allow us to update a numeric field to null/blank value

If you have assigned a value to a numeric field (in Sharepoint for example) you cannot delete this value or update it to null/blank

Status: Planned
New Member

very serious problem, as the user does not receive a message and therefore the data status becomes inconsistent - user must think value has changed, but it didnt. I can not understand why Microsoft is not fixing this simple to solve problem - very disappointing. Next time thinking twice if we should use PowerApps.



New Member

We have a serious issue with not being able to set a SP People Picker field back to empty. I can't write a new Power Automate just to clear 2 fields in my list. This is just ridiculous.

Frequent Visitor

Need this sooner. Can't patch SP lists if one field is blank

Regular Visitor

Just ran into this, not being able to set numeric value to null.  Was rather irritating and confusing.  Really needs to be fixed.  I say fixed as I consider this a bug, not a lack of a feature.  My 2 cents.

Helper I

From the initial suggestion to "planned" 4 years have passed.

This is an exceptionally long time not to address this issue. 
Please Microsoft fix changing data back to null. 

Close is only in horseshoes and hand grenades. 

Helper I

came across this one today - time to change all my data to Single Line text .. and do number casting

Regular Visitor

Hi everyone,

Any update on this? I really need to set a number SP column as null or void because 0 could be a value itself, so I need to set some columns to blank. 

I have tried patching Value(Blank()) but it patches a 0 on the SP list item and that is not an option.

Please Microsoft, we need a solution to this issue as soon as possible, even after 4 years of having this post opened.