Can't change SharePoint List column to blank.

[anthonys123]

NEVER MIND. Looks like formula level error management did work. It just took some time to kick in. 

Not sure how to delete a post here.  

I have a SharePoint Asset List for employee assets. When the employee leaves and the asset becomes available, I need to change the FULL NAME field to blank. Removing the name with the Power App doesn't take hold and the user's name remains. 

This FULL NAME field is a Lookup from another list of employees. The Asset list does allow for blank fields in all columns. I have a number of items in the list with blanks in the FULL NAME column. I came across this post which suggested enabling Formula-level error management. This didn't help my problem. I'm certain that I've been able to 'blank-out' the FULL NAME column before. 

[Pstork1]

Are you changing it by setting the field to blank and submitting the form?  Or using some form of Patch?  Can you show us the formula being used.  Since its a lookup column I don't think you can just set it to Blank().  You need to use some record format.

[v-qiaqi-msft · Accepted solution]

Hi @anthonys123,

Thanks for your sharing. I will help you close this case.

Regards,

Qi