Update a User Lookup Column to Null

[Azaria]

Hello, 

I am trying to get a flow to update one SharePoint Online list item column to null depending on certain conditions.

The null expression seems to work for certain data types, but Power Automate does not seem to be able to update a user lookup field to null - I keep getting the error "The specified user could not be found..." 

Is there a solution to setting a user lookup to blank if it already has existing data in the field? I have other user lookups in this list so I would only want the specific column to be reset to blank.

I would appreciate any suggestions!

Thank you,

Alex

[NM-ET]

There is a way (a very annoying way) using a Send an HTTP request to SharePoint action.

https://powerusers.microsoft.com/t5/Building-Flows/Clear-people-picker-box-in-SharePoint-list-error/...

[v-bacao-msft · Accepted solution]

Hi @Azaria ,

If the person field does not support multiple selection, you can refer to this thread:

Solved: Send an HTTP Requet to SharePoint 400 Bad Request ... - Power Platform Community

If the person field supports multiple selections, you can refer to this thread:

Solved: Setting multi-user field to blank - Power Platform Community

Best Regards,