Email Action isn't populating the data in the email

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:

3X_2_7_27d4306f2b8a0598621228bdab275d959362a348.png

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 Solved
0 14 386
1 ACCEPTED SOLUTION

CONCATENATE(”Hi Dallas, I am interested in the following shift : ", [SHIFT ID])

CONCATENATE(”New Shift Enquiry: ", [Shift ID])

View solution in original post

14 REPLIES 14

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.

Hi @Suvrutt_Gurjar

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.

@Suvrutt_Gurjar

Top Labels in this Space