cancel
Showing results for 
Search instead for 
Did you mean: 

Enable null function to clear a previous value from a person or group field

 When using the Update Item action for a SharePoint List, it is not currently possible to clear a value that has been previously set in a Person or Group type field (Claims). Attempting to do this currently causes the Flow to fail, with a "Badgateway" 402 error, arising from a "user does not exist" 400 error.

 

Please enable the dynamic content expression to allow use of the Null() function to clear previous content from ANY field type, including person or group claims fields.

Status: New
Comments
Level: Powered On

Just going to second this since it is inconvenient in the extreme. I like the suggestion of using null() to generally clear all field types for consistency. I think developing another SharePoint action other than Update Item should not be needed for this.

 

@ONYXJas You can use the REST API to do this in Flow using a POST request and setting the field to -1, if you need a work around badly.

Level: Powered On

Yeah, this problem really put a damper in my development this week. 

WHY?!?!?!?


Level: Powered On

As mentioned by the two commentors above, this is a serious shortcoming for something that should be inherent in the system. It's a shame such a simple piece of functionality has been so slow to be implemented. You are basically making some of the most powerful functionality (Person field as a column) useless. Please spend less time adding new triggers and more time perfecting base functionality.