Arcade function in Email Template not working the same as Send Email step
Hi all,
I am trying to use Arcade expressions in Email Templates for 'TO' and 'CC', but the Arcade expressions are not returning any values, although the same expressions work as expected when used in Send Email step.
This is what I have for 'TO' line - "jobExtendedProperty($job, 'survey123', 'email')"
This is what I have for 'CC' line - "if(jobExtendedProperty($job, 'survey123', 'category_1')=='Map Request (GIS Unit)'){return 'margo.huang@domain.com'} else if (jobExtendedProperty($job, 'survey123', 'category_1')=='ERV Issue (GIS Unit)'){return 'margo.huang@domain.com'}"
When I do 'preview email', both lines return desired email addresses. However, after I submit a test Survey123 form, no email is sent to me.
I tried putting my email address under 'CC' line as static value while keeping the arcade function in the 'TO' line(which is supposed to return my email address).
This is the email I got after Survey123 submission. Nothing is in the 'TO' line.
Does anyone have any ideas on what is causing this? Any help is appreciated!
Thanks!
Margo
