cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smathanagopalan
Frequent Visitor

NULL a person field using flow

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.

 

smathanagopalan_1-1617242173536.png

 

 

 

8 REPLIES 8
ViditGholam
Continued Contributor
Continued Contributor

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
Community Support
Community Support

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

@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_0-1617284191092.png

 

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

 

What am i missing?

 

smathanagopalan_1-1617284619738.png

 

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

smathanagopalan
Frequent Visitor

Looking for some insights please

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

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

 

smathanagopalan_0-1617545369021.png

 

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,353)