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:

Screenshot 2021-01-28 at 8.07.22 pm

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
?

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.

1 Like

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.

1 Like

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 << >>

2 Likes

Oh yes, Sorry.

I thought @Gregory_McIntyre is using the Email and subject in workflow.

1 Like

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

3 Likes

Yes, i do the same confusion all the time. haha.

2 Likes

Missed the words “isn’t” in the description below :slight_smile:

2 Likes

@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

3 Likes

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.

3 Likes

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

1 Like

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

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

2 Likes

Hi @tsuji_koichi - Thats brilliant and worked perfectly! Thank you so much!

2 Likes