Unanswered

Form Information in the BODY of email

(0) Share

Report

Posted on by CU15082249-0

Good morning,

I'm having issue in trying to send value information of the form in my email.
What I would like to do is when I send an email, in the "Body" of the email I want to have the "First Name" and "Last Name" of the person who submitted the form.

Example:

Office365Outlook.SendEmailV2(

"new@outlook.com",

"New Heat Customer Has Just Been Added",

'First Name_DataCard1' & " " & 'Last Name_DataCard1' & " Has Just Completed The New Customer Form For Heat Group."

)

I have added 'First Name_DataCard1' .Update to both First Name and Last Name:

But now when I fill the form out:

And send an email, this is what I received:

Did I not write the formula correctly? Not sure why "UPDATE" isn't working.

Help would be greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

madlad 2,637 Moderator on at

Like (0)

Report
Hi!

Apologies, I missed in your earlier post that you submitted the form before sending the email - this is likely clearing the .Update value before the email sends.

This should reference the values just submitted by the form:

Form1.LastSubmit.FirstName & " " & Form1.LastSubmit.LastName & " Has Just Completed The New Customer Form For Heat Group."

(You may have to change the exact column references in those to match)

Let me know how it goes!

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @NewberneData

When you call SubmitForm, the contents of the data cards will clear which explains why the first and last names are not showing. You can resolve this by referencing the LastSubmit property of the form.

Office365Outlook.SendEmailV2( "new@outlook.com", "New Heat Customer Has Just Been Added", Form1.LastSubmit.Firstname & " " & Form1.LastSubmit.Lastname & " Has Just Completed The New Customer Form For Heat Group." )

Was this reply helpful? Yes No
CU15082249-0 on at

Like (0)

Report

Thanks guys that worked perfectly!
Appreciate your time for this.
Last question if I wanted to put BOLD around the first and last name. All I need to do is put the <b> in front and </b> behind Form1.LastSubmit.Firstname?
Example:
<b>Form1.lastSubmit.Firstname</b>

Was this reply helpful? Yes No