[Status] (Enum) is not parsing in my email template.

[weareborg]

Hi folks,

I have a simple email template which I am trying to get to work. I want to pull data from my table and insert it into the email. I thought this would be very simple.

The subject line is fine, as in the substitutes work. eg:

CONCATENATE("Plain Text etc ",[Dynamic Text Field], " on ",[Natural Date], " for ",[Duration]," nights") results in;  Plain Text Dynamic Result on June 16th, 2023 for 2 nights

However, in the body of the email, I'm trying the same thing and it's not working at all.

For example:

Hi.
Requesting [Dynamic Information 1] re [Duration].

When I test these, they don't pull in the dynamic information. They show the text as is.

If I add the << >> the expression doesn't work at all. Big red X saying

"unable to be parsed: The given key was not present in the dictionary.."

I'm almost sure all of my fields are correct.

For example, [Duration] is an Enum and I have made another virtual column where it displays this Enum as text. Called it [Duration as Text]. That didn't work either?

Also, it doesn't allow for comma's in the body as it messes up the formula or something..

I'm sure its something really simple...

Driving me nuts..

Any advice appreciated.