SharePoint Update does not update field with Null.

[Dave Balsillie]

The SharePoint update component does not update with null, if the field already has a value. This can be incorrect, if a value has been updated on a record and needs to be cleared.

Steps to reproduce:

a) Create a list in SharePoint

b) Populate with some values (i.e.)

       Key    Description    NullableField

       A        Record A       KeepThis

       B        Record B       ClearThis

c) Now, using the update component, try to clear the NullableField passing a "null" (not a space). The record does not update.

TIP: Turn on version history and you'll see a new version created. but no update was performed.

[Ivan Peev]

Hi Dave,

This behavior is by design. If you want to reset field , pass empty string as input.

[Dave Balsillie]

I'd like to bump this topic.

Found an additional use case. If the target SharePoint field is a date time field, passing and empty string ("") results in an exception. Can't figure out how to clear the date time field. The field can be cleared (tested using the SharePoint dialogue.)

Really, why would passing a null result in a "no update"? The component should see the null and translate to an empty string (or other valid values to update SharePoint).