Skip to main content
Nintex Community Menu Bar
Solved

How to Update SPO List Item Number Column with Empty (null)

  • August 18, 2021
  • 3 replies
  • 590 views

Forum|alt.badge.img+4

In my workflow, I am updating some columns in a SharePoint Online List Item. I want to clear the value in a Number field.

 

When I add the field in the Update configurator and don't enter anything in that field, I get a warning when I try to publish. "Error: The workflow contains unconfigured actions. Please configure all actions and try publishing again."

 

To fix the error, I enter a number in the field. And then I delete that number. I am able to publish, but when the workflow runs, the value in that field does not get cleared.

 

Furthermore, when I edit the workflow and configure the Update step, I discover that the field I wanted to update with blank (null, nothing) was removed from the configuration.

 

How do I clear the contents of a SPO List Item Number field in the Update items step?

Best answer by Michele

"How to I set a sharepoint online date column to be empty using update items action?"

3 replies

Forum|alt.badge.img+14
  • Nintex Employee
  • August 19, 2021

@Michele There is no way I am aware of to clear the number column using the update item, integer/decimal variables can't be blank so it will always have a value of 0 when used.


Forum|alt.badge.img+4
  • Author
  • Scholar
  • Answer
  • August 20, 2021
"How to I set a sharepoint online date column to be empty using update items action?"

Forum|alt.badge.img+4
  • Author
  • Scholar
  • August 20, 2021

Update: After working more with the number field in the SPO list itself, it appears that once a number has been entered into that field, it's virtually impossible to return it to the empty state. I edited the data directly in the SharePoint list and I could not clear out the field. I resorted to setting it to zero. 

 

So, I would say now that @leighburke 's answer may be better.