Lookup tables - country abbreviation

Using the county lookup tables, if it doesnt find a value it errors and stops the automation. I noticed this happens often with countries like United Kingdom, England, Britain. Could be any of them but they dont all exist in the table. Or something like The Netherlands which doesnt have a match

Can it instead of failing, pass back the original value and “no match” or something?

Choose this option to not halt the automation, then use a conditional to handle any error condition as desired:

duh, forgot that was in there.

on a null match, what will it return? just empty?

This message is returned when the country is not found:

All actions emit an “Action error message” field you can use in a conditional to check for any errors, e.g. via length is greater than zero, or for specific error messages

1 Like