Change data value to null

[Anonymous]

Our organization just enabled Salesforce state/country picklists. This is causing a problem when a lead comes into Marketo with a state other than null where the country is not United States or Canada (or a handful of others). The lead (or updates) won't sync to Salesforce because they don't have a valid state, which is null in this case. I have a smart campaign to catch these, but when I set the flow to Change Data Value, Attribute is State, and new value is left blank, it doesn't fire when it should. Is there a way to express the null value so that this will work?

[Tim_Langlois1 · Accepted solution]

HI Mary,

I'm not quite following exactly what you're trying to do, but you may just need to type "NULL" into the Change Data Value flow step instead of leaving it blank..

To prevent this issue altogether, I'd suggest hiding the State field in a Marketo form unless the Country selected is United States or Canada. You can do that via the visibility rules in your form.

Tim

[Mel_Dadoly]

Hey Tim,

You are correct, using NULL in the flow step will take care of it. Leaving the flow step blank or using null won't work as needed.