If the column is not a required one, meaning there is no red tag beside the field, then you could just leave the field blank when creating the flow.
Thanks you for you reply.
I thought that was the case. However if you leave them blank when updating a record. they will not be updated at all. That why I was wondering how to remove existing value. I can ofcourse enter a <space> however that I can later on not check wheter this field is empty. I tested this with the Item Update shown below. The empty ones will not be emptied when running this. Only the one at the bottom will get updated.
I have the same question: I am trying to build a Flow that sends an email with options, and if Option "Delete" is chosen, one field is supposed to be emptied. But I can't make it work, so for now I must settle with "update with <space>" but that is not what want to do. Looking forward to a solution 🙂
This is a really old post, but I am trying to do this as well. I do not believe leaving a field blank in an Update Item will remove the contents. No value simply passes over the field and does not update it. Anyone else have this experience?
I've experienced this as well. Leaving it blank simply leaves the data that is in the list and doesn't wipe it. I want to wipe a numerical column from whatever data it contains back to blank each day. Currently I use "0" but my users find it hard to view hte list and would prefer it to be emptied if possible. Is this possible?
To clear the current value from a field when using SharePoint Update item, select the dynamic content option, click on the Expression tab and select the Null function, then click OK. This clears the current value and sets the field to null.
Have you had an opportunity to apply @ONYXJas‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!
Thank you for being an active member of the Flow Community!
Flow Community Manager
Nice one, @KutubK. I'll definetely stash this one in my bag of tricks. I dont know how some of y'all come up with these solutions. If its anything like me, its a very time consuming and cumbersome trial and error process.
I've been looking for hours for a solution to this. I should not have to set up an HTTP Post action just to clear a user/group field. This is an incredibly frustrating limitation, and would like to see some type of update or acknowledgement from MS for this shortcoming. Can you provide any updates on this? We need the ability to clear person fields with the update item action. EVERY OTHER field type you can user null, or -1 for choice fields. I would take either for person fields.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications