Unanswered

Sending an email alert on submit

(0) Share

Report

Posted on by mikesmeltz

I have a Power Apps form that i want to trigger an email alert when the user submits data. The email will contain information from the submitted form, such as name, incident #, etc. Below is the formula i am using:

Office365Outlook.SendEmailV2("Mike.Smeltz@BlickCenter.Org", "MUI Submitted", "The following MUI has been submitted for:" & (DataCardValue1) & "Incident #:" & DataCardValue29)

This formula is on the new form of my app. The email comes through but without any information from the DCV's 1 and 29. DCV 1 is the name field, and DCV29 is the incident # assigned by the SQL database.

Here is the email msg i get: The following MUI has been submitted for:Incident #:

The DCVs are what's missing from the message.

Also on the form i have an edit form, which is where the app takes the user once the new form has been submitted. This edit form contains all the info that was submitted and allows the user to make any corrections before closing the app.

If i put the email formula on the submit icon on the edit form, it gives me data from the DCV's but they are the ones from the previously submitted entry, which could have been days or weeks ago; not the current one that was just submitted by the user.

Any thoughts?

Thank you very much.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Jitendra_jangid 128 on at

Like (0)

Report

Hi,

Would you please try with <FormControlName>.LastSubmit.<fieldName>. I think it will give you the values that you are looking for.

Was this reply helpful? Yes No
mikesmeltz 82 on at

Like (0)

Report

Hi,
DataCardValue1.LastSubmit.FullName gives an error messages:

On LastSubmit - Name isn't valid. This identifier isn't recognized.
On FullName - Invalid use of "."

Was this reply helpful? Yes No
mikesmeltz 82 on at

Like (0)

Report

Disregard my last post. I put in the wrong formControlName. It now works. thank you very much !!

Was this reply helpful? Yes No
mikesmeltz 82 on at

Like (0)

Report

I have run into the following situation when trying to get a data submitted. When I do the date field (frm_MUINew.LastSubmit.IncidDate), the date chosen from the date picker does not show up in the email message. All my other fields that I chose do. Any thoughts?

Thank you.

Was this reply helpful? Yes No
Jitendra_jangid 128 on at

Like (0)

Report

Interesting, Could you check IncidDate has saved successfully in your DataSource?

Was this reply helpful? Yes No
mikesmeltz 82 on at

Like (0)

Report

Yes. It is a SQL database for the datasource, and the date format is 2020-12-04 (for December 4, 2020).

Was this reply helpful? Yes No