Set integer to null using Flow Designer

[Max McFa]

Hello Community,

I'm attempting to use the Update Multiple Records action to blank/null an integer field on the User table. I've attempted multiple methods, however none of them seem to work. Can anyone suggest a method that works for integers?

I've attempted the following:

Use the scripted function to:

return '':

return"";

return 'NULL';

return "NULL";

I've also attempted to set a flow variable to blank and assign the value using that.

Thanks for your help!

[Shubham Singh]

Hi @Max McFa 

Try return null;

Do not use apostrophe (') while returning null. It will convert it to String if you use ' or ''.

Thanks!

Mark it as helpful if it works 🙂

[Max McFa]

Thanks for the suggestion, Shubham. However, that did not resolve the issue. Perhaps ServiceNow is treating null as no update? I'm able to set it to other values.

[SanjivMeher]

It looks like you may need to do a Lookup records as suggested in below thread and then update each item. 

https://www.servicenow.com/community/developer-forum/flow-designer-update-multiple-record-not-work-w...