cancel
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
Comments
Level 10

Also, another bug is that it seems that PowerApps reads blank/null values in numeric fields of SP lists as zeros, please see the following screenshots:

 

From SharePoint

CaptureSPnull.JPG

 

And from a PowerApp gallery

 

CapturePAzero.JPG

Level: Powered On

This also seems to apply outside Sharepoint - for example if updating an SQL Table you should be able to set a numeric field to null (blank)

Flow Staff
Status changed to: Planned
 
Level 10

Hello @Audrie-MSFT

Is there any update on expected timing?  This is a show-stopper for me.

Thanks.

Anonymous
Not applicable

I have the same issue with person field. Is PowerApps team resolving it for all fieldtypes or do I need to create a separate idea for this one? 

Level 10

I suspect that once we can set one field type to null then we will be able to set all field types to null.  However, this may not be happening soon enough.

Level: Power Up

Hi @Meneghino, do you have a rough idea on when this will be available.

I have the same kind of issue where I need to set a Choice type value in a sharepoint list based on another column in another list that can be empty. If the latter is empty, the former should remain empty too but it fails because either when my expression return null or empty string ('').

 

Level 8

Same here, neither number field nor person field can be nullified. Please fix it / make it work. Thanks!

Level 10

Unfortunately I have no idea when this will be available, but the more we can vote up this idea, the sooner hopefully it will be resolved.

Level: Powered On

This is basic stuff and much needed. Pls make it happen.