Answered

send email with field values

(0) Share

Report

Posted on by ianallen13V2

Hello,

Wanted to see if anyone had any ideas on how to create a submit button, that would send an email from Power Apps that also included the values from drop downs, input fields in a form, to a specific email address I specify? I know that I can use a SharePoint site to send the values and then use Power Automate to do it after the fact, but I want it to just send the values, to Joe.Smith@Email.com & Joe.Smith2@Email.com with the values in the body of the email.

Has anyone done something like that? Example of the fields from my form below.

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (2)

LaurensM 12,516 Moderator on at

Like (0)

Report
Hi @ianallen13V2, you can use the 'FormName.LastSubmit' property to get the most recently created values.
The submit button could have the following structure in the OnSelect property:

//Submit your form SubmitForm(FormName); //Fetch the record info UpdateContext({varLastSubmit: FormName.LastSubmit}); //Send out email Office365Outlook.SendEmailV2("Joe.Smith@Email.com; Joe.Smith2@Email.com", "Subject", "Field 1 " & varLastSubmit.ID & "Field 2...")
You will need to add the Office 365 Outlook connector to your app data sources to use the SendEmailV2.

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
ianallen13 282 on at

Like (0)

Report

Thank you so much for the reply - unfortunately this answer may be a bit above me, but when I try to incorporate it, I have errors all over.

Might need a bit more clarification. Thank you in advance!

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report

Hi @ianallen13, what specific error messages are you receiving and is 'Fin Aid Systems' the name of your Form?
Normally you should not receive any errors with SubmitForm & .LastSubmit if you are referencing a Form control.

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report

It looks like there is an issue with the form name. Is 'Fin Aid Systems' the name of the form or of your data source?

Was this reply helpful? Yes No
ianallen13 282 on at

Like (0)

Report

Hi - yes - 'fin aid systems' is the name of the form I'm using.

Was this reply helpful? Yes No
ianallen13 282 on at

Like (0)

Report

Hi yes - Fin Aid Systems is the name of the form.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report

@ianallen13 when you hover over the red line, what specific error do you receive?

Was this reply helpful? Yes No
ianallen13V2 on at

Like (0)

Report

The first error states: "The function states an editable form as its input"

The second error states: "Incompatible view. We can't evaluate your formula because the context variable types are incompatible with the types of values in other places in your app."

The third error states: "Name isn't valid. 'varLastSubmit' isn't recognized"

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report

@ianallen13V2 are you using an Edit form or a Display form?
You will need an Edit Form to use SubmitForm().

Would it be possible to share a screenshot of this form control in your Tree View panel (left).

Was this reply helpful? Yes No
ianallen13 282 on at

Like (0)

Report

Thanks for the screen shot. I was not using this. I just looked into this now, but it says that I need to connect to data. I didn't want to connect to anything as far as a Sharepoint list or anything, is that even still an option?

Sounds like I can't just have fields and have an email send the values of those fields without doing like a SharePoint list or something?

Was this reply helpful? Yes No