In a workflow, I want to clear out a list column that is keeping track of future approvers, so it may include multiple people when the workflow starts. When the last approval starts, there should be no more approvers and I want to set that column to an empty value.
I've tried using the People/Group workflow variable that I do not initiate and stays blank. That works fine when my People/Group list column is set to not allow multiple values. For some reason, when I make the field allow multiple values, this no longer works, and it leaves the last result in there. I cannot find a way to clear it out through the workflow.
The field is set to allow blank values and I can delete the last entry by directly modifying the list item and leave it blank, but I can't seem to figure out a way to do it through a workflow.
I've use both Set Field Item and Update List Item. I've also tried it with a blank text variable and one where I just had a ";" in it trying random things. Using the blank text variables errored the workflow. The blank People/Group variable did not error the workflow, but did not make the item blank either.
I've tested this out with a workflow where the only action is the Update List Item or Set Field Item depending on which I was testing as well, so I know something else is not writing back to it.
I'm kind of out of approached to try. Does anyone know why it might exhibit this behavior and a way to get the field back to blank?
Solved! Go to Solution.
Through a lot of trial and error, I have found that if you set the field to a Value of 1, the workflow will continue and it will put "_spofrm_70_6564" in the field. Not ideal, but at least indicates that there shouldn't be anyone in the field. If anyone can figure out how to make it empty, let me know.
You can use Set field in current item and configure the control by selecting the people picker column and set the value to ' (single quote). Please refer the below screen shot for your quick reference. Let me know once you are able to fix this.