cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sandervk
Advocate I
Advocate I

sharepoint update item with blank value

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

25 REPLIES 25

Hi Again @Bob_Taylor ,

 

If you are referring to send an http request then it would probably be 

'Support_x005f_Resource'
 
The trick to finding this one is to run the flow without any actions then look at the results of that run and at the http request step look at the body section scroll through until you find the field.
 
http1.PNG
http2.PNG

@dee2005,

Thank you for this. I never thought to run a GET HTTP Request to see the field names. This was very helpful. Got it working. 

Can confirm, this worked well for me for changing values in a bunch of dropdown columns. Simply using a "null" expression directly in the "update item" box doesn't work, but setting a variable to "null" and referencing the variable in the "update item" dialog definitely worked.

thedarkforge
Regular Visitor

https://youtu.be/BrjobdJqvEQ this video by Deepak Shrivastava shows multiple ways to clear. I have tested and verified that these methods work as of today 3/10/2022 

Can you tell me how to keep null in people column?

 

whats is stringId?  this method not works for me. Can you help?

 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,390)