Unanswered

sharepoint update item with blank value

(0) Share

Report

Posted on by Sandervk

When using Sharepoin Update Item actions, does anyone know how to remove the current value meaning the new value should be blank or empty?

Categories:

Building flows

I have the same question (0)

All responses (31)

Answers (0)

v-monli-msft on at

Like (0)

Report

Re: sharepoint update item with blank value

Hi @Sandervk,

If the column is not a required one, meaning there is no red tag beside the field, then you could just leave the field blank when creating the flow.

Regards,

Mona

Was this reply helpful? Yes No
Sandervk 22 on at

Like (2)

Report

Re: sharepoint update item with blank value

Hi @v-monli-msft,

Thanks you for you reply.

I thought that was the case. However if you leave them blank when updating a record. they will not be updated at all. That why I was wondering how to remove existing value. I can ofcourse enter a <space> however that I can later on not check wheter this field is empty. I tested this with the Item Update shown below. The empty ones will not be emptied when running this. Only the one at the bottom will get updated.

Was this reply helpful? Yes No
MM-05080756-0 431 on at

Like (0)

Report

Re: sharepoint update item with blank value

I have the same question: I am trying to build a Flow that sends an email with options, and if Option "Delete" is chosen, one field is supposed to be emptied. But I can't make it work, so for now I must settle with "update with <space>" but that is not what want to do. Looking forward to a solution 🙂

Was this reply helpful? Yes No
nikelly on at

Like (0)

Report

Re: sharepoint update item with blank value

Instead of checking for empty spaces, you could always check for spaces that equal " " since it's replacing the deleted item with a blank space.

Was this reply helpful? Yes No
martinav 3,340 on at

Like (4)

Report

Re: sharepoint update item with blank value

This is a really old post, but I am trying to do this as well. I do not believe leaving a field blank in an Update Item will remove the contents. No value simply passes over the field and does not update it. Anyone else have this experience?

Was this reply helpful? Yes No
Stroos 14 on at

Like (1)

Report

Re: sharepoint update item with blank value

I've experienced this as well. Leaving it blank simply leaves the data that is in the list and doesn't wipe it. I want to wipe a numerical column from whatever data it contains back to blank each day. Currently I use "0" but my users find it hard to view hte list and would prefer it to be emptied if possible. Is this possible?

Was this reply helpful? Yes No
martinav 3,340 on at

Like (4)

Report

Re: sharepoint update item with blank value

I have tried the expression null(), and that did not work for Sharepoint people fields. I did not try it for numerical.

Was this reply helpful? Yes No
Stroos 14 on at

Like (1)

Report

Re: sharepoint update item with blank value

Sweet!! Null worked for numerical field. Thanks for hte heads up martinav.

Was this reply helpful? Yes No
ONYXJas 22 on at

Like (4)

Report

Re: sharepoint update item with blank value

To clear the current value from a field when using SharePoint Update item, select the dynamic content option, click on the Expression tab and select the Null function, then click OK. This clears the current value and sets the field to null.

Was this reply helpful? Yes No
ONYXJas 22 on at

Like (1)

Report

Re: sharepoint update item with blank value

Maybe that's changed, I've successfully used Null to clear people fields

Was this reply helpful? Yes No