NULL a person field using flow

[smathanagopalan]

How do i null a single person filed in flow?

"Approved/Rejected by" and "Checked By" are the fields i would like to NULL. I am unable to when i use expression "NULL". Any help would be appreciated.

[ViditGholam]

Hi @smathanagopalan  I had a similar requirement so what I did was I used a compose and I set the value of that compose to Null and used the output of the compose in the fields I wanted to be null "Required fields" check if it works for you 

Hope this helps ! 

If this resolves your issue please mark this post as answered and hit me a thumps up.

Thanks and Regards,

 Vidit

[v-duann-msft]

Hi @smathanagopalan 

Thank you for posting.

According to your description, you would like to empty people field using ‘update file properties’ action but failed. If any misunderstanding, please kindly let me know.

I’m afraid you found one of known issues of flow. This is a by design problem. It will have ‘recipient invaild’ error pop up. Unfortunately, there is no any way to clear the value of person field using any function in flow.

Please try below steps:

- Initialize an empty string variable (e.g. 'VarClearChoice')

- Use 'update file properties' to clear the choice column by using this expression: 

variables('VarClearChoice')

Meanwhile, you can try use ‘send http request to sharepoint’:

https://powerusers.microsoft.com/t5/Building-Flows/sharepoint-update-item-with-blank-value/td-p/6395...

https://sharepains.com/2019/03/07/microsoft-flow-how-to-clear-fields-in-sharepoint-list-items/

Hope the content above may help you.

Best regards,

Anna

[smathanagopalan]

@ViditGholam  I did what you mentioned, but it did not "NULL" the person field. Flow ran fine without errors though. What am i missing?

[smathanagopalan]

hello @v-duann-msft  i tried what you said, but flow fails at updatefileproperties.

What am i missing?

[ViditGholam]

hi @smathanagopalan  try passing an empty string (expressions - >string(''))

[smathanagopalan]

Looking for some insights please

[ViditGholam]

Hi @smathanagopalan use the dynamic contents expression section type strings then [string('') ] basically you are passing an empty string to those values 

[smathanagopalan]

@ViditGholam Am i doing this right? Does not seem to work. See snapshot below. Can you provide me a screenshot as well?