Hi all, hoping someone can help correct my error here. I have created an email action, this isn’t using a workflow email as I don’t want this triggered on any type of data change, my App is read-only for users.
I have created the following expression for the Email Subject & Email Body:
Subject
CONCATENATE("New Shift Enquiry: ", “[Shift ID]”)
Body
CONCATENATE(“Hi Dallas”, “, I am interested in the following shift”, " [Shift ID]")
This is seems to be correct to my knowledge is populated in the email, however, the Shift ID data is not pulling through to the email. See below:
This was working for a brief while. I haven’t changed anything to my knowledge but now the data just isn’t captured.
Does anyone have any suggestions as to what I may have got wrong here
?
Solved! Go to Solution.
CONCATENATE(”Hi Dallas, I am interested in the following shift : ", [SHIFT ID])
CONCATENATE(”New Shift Enquiry: ", [Shift ID])
Please try
"New Shift Enquiry: "<< [Shift ID]>>
in the subject and
<< CONCATENATE(“Hi Dallas”, “, I am interested in the following shift: ”, [Shift ID])>>
Or else if name is also variable , please try in teh body
<< CONCATENATE(“Hi ”, [Name] , “, I am interested in the following shift: ”, [Shift ID])>>
in the body template
Thanks @Suvrutt_Gurjar I tried this but got the following error…
Although the change to the subject seemed to be ok but when I saved the changes, the App give me an error.
Thank you. I requested above for the Email subject.
This should be action to email instead of workflow to send email, where we simply use the appsheet expresion rather than template expression. So no need << >>
Oh yes, Sorry.
I thought @Gregory_McIntyre is using the Email and subject in workflow.
Yes, i do the same confusion all the time. haha.
Missed the words “isn’t” in the description below
@Suvrutt_Gurjar - sorry that caused confusion
@tsuji_koichi - thanks for the advice, so the expression should read:
Subject
CONCATENATE(New Shift Enquiry: , [Shift ID])
Body
CONCATENATE(Hi Dallas, , I am interested in the following shift, [Shift ID])
NB. This is working perfectly now, thank you
Hey Gregory,
It was my bad to miss the “isn’t” . You had correctly mentioned it. So I should be and I am sorry.
@tsuji_koichi : thank you for pointing out the confusion well in time.
Hi @Suvrutt_Gurjar & @tsuji_koichi - Thanks for your recent help on this.
having removed the double quotes, I’ve now noticed that the punctuation and spaces between words has gone which makes the email read little funny, screen shots attached.
I have included below the expression below, have I implemented this incorrectly?
Subject Expression:
CONCATENATE(New Shift Enquiry: , [Shift ID])
Email Body Expression:
CONCATENATE(Hi Dallas, I am interested in the following shift, [Shift ID])
Your guidance would be greatly appreciated!
Thanks - Greg
CONCATENATE(”Hi Dallas, I am interested in the following shift : ", [SHIFT ID])
CONCATENATE(”New Shift Enquiry: ", [Shift ID])
Hi @tsuji_koichi - Thats brilliant and worked perfectly! Thank you so much!
The screenshot shared by you shows some major error against actions and not against Workflows now. It sounds that you have some error there in actions.
Romove double quotes
Subject
CONCATENATE("New Shift Enquiry: ", [Shift ID])Body
CONCATENATE(“Hi Dallas”, “, I am interested in the following shift”, [Shift ID])
Then it should work.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |