View the original community article here
Last tested: Jan 21, 2019
Just like arithmetic operations on a list, a null will make the entire result null.
This content is subject to limited support.
What happens when a null is concatenated with a value? (Community)
