Need help clearing a String variable in an Update Record in the Flow designer.

[WarrenB]

I've got a weird issue.

A final step in a flow I am building is to check for records in sys_user where the "On Leave" flag is false, but some other fields are not empty.  My first attempt was this.  Works great for the Leave effective date and Leave not to exceed fields, but the On Leave Comments field does not get cleared.

I then tried some simple inline scripts to clear the comments of which nothing worked

return ;

return '';

Finally, I created a flow variable and did not assign a value.  According to the documentation, that would keep it at the default value isnull.  That didn't work!

Any ideas?  This (I would think) shouldn't be too hard!

[OlaN]

Hi,

Do you have a Data policy in place that would prevent clearing that field?

[WarrenB]

No.  Nothing like that.  It's just a simple string field.

[WarrenB]

I suspect that this may be a bug.  I've opened a case with ServiceNow.  I'll post what they find.

[OlaN · Accepted solution]

I'm curious, have you tried to update the records one at a time in a for-each loop instead?

[WarrenB]

Your a genius!  Great thought.  Just tested and it works.

I am going to leave the case open with snow, the update records really should work, but at least now I don't have to wait around for a fix to that.

Thanks for the help.