Will convert all of the values from this column in the table into a List type. I’m wondering if the LongText newlines get lost during that conversion. Is there any other way you can reference this value?
Maybe if you were to move into the context of that one row of the table with a single-iteration Start expression, then reference the column directly it would work.
<<START:FILTER( Settings , condition )>><<[custom greeting...]>><<END>>
Alternatively, make a new column in Settings table to substitute all newlines with some special character. Then in the template substitute it back.
SUBSTITUTE( [custom greeting…] , "
" , “*”)
<<SUBSTITUE(Any(Settings[new column]) , “*” , "
It’s also possible that I’m completely missing the real issue and have hugely overthought this.