Update SharePoint List with a blank value

Question

Trying to write to a SharePoint List but fields that are Null() or "" are ignored.

So how can we update a list with blank values?

As a workaround text fields can be written as a space, but this doesn't work for date fields.

Tool: SharePoint List Output, Office 365

Designer: 2020.3.5

jeneir · Answer

To clarify, if a column in SharePoint is text format and I want to blank out a specific value, then I have to replace it with " ".

If the column is DateTime and the value for the row is no longer needed (the row's status changes over time) I want to remove the DateTime value, so it will be blank in SharePoint.

Replacing Datetime with a text field is not optimal since there's a lot of useful functionality built in for SharePoint Lists.

As a workaround I'm using a boolean column which tells if each row in the DateTime column is valid or not.

danilang · Answer

Hi @jeneir

What do your mean by fields that are Null() or "" are ignored.  Is the entire row skipped if any field is empty or is it just the empty field that end up empty in SharePoint?  Can you provide screen shots to show what is happening

Dan

mceleavey · Answer

Hi @jeneir ,

You can output a null() value providing the field is there. Are you trying to output an entirely null row?

You can also set the date value to be a single line of text, and if you're using Alteryx to update and add rows this should be fine as you can govern the format in Alteryx.

M.