Unanswered

when trying to submit data to email it is copying data from the first item rather than filled in data

(0) Share

Report

Posted on by jdrm1

I have the below code and when it is submitted it is set to also email but for some reason the email data is not the data that just got saved but is from a previous form. How do I make it use the data they just put in.

SubmitForm(EditForm1);

If(FormTypeDropdown.Selected.Value = "Form",Office365Outlook.SendEmailV2("email@address.com",
"Form","Name:" & " " & DataCardValue9.Text & " "
& "Job :" & " " & DataCardValue10.Text & " "
& "Date1:" & " " & DataCardValue48.Text & " "
& "Date2:" & " " & DataCardValue47.Text & " "
& "Work:" & " " & DataCardValue15.Selected.Value & " "

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

slima1 69 on at

Like
a
(0)

Report
Copy link

Link copied!
See if this helps

SubmitForm(EditForm1); If(EditForm1.Valid, // Check if the form submission is valid Office365Outlook.SendEmailV2("email@address.com", "Form", "Name: " & DataCardValue9.Text & " " & "Job: " & DataCardValue10.Text & " " & "Date1: " & DataCardValue48.Text & " " & "Date2: " & DataCardValue47.Text & " " & "Work: " & DataCardValue15.Selected.Value & " " ); ResetForm(EditForm1); // Optionally reset the form after successful submission );
jdrm1 54 on at

Like
a
(0)

Report
Copy link

Link copied!

it needs to check the drop down which is why i have it there
slima1 69 on at

Like
a
(0)

Report
Copy link

Link copied!

forgiveness
try
Patch(
YourDataSource, // Replace YourDataSource with the actual name of your data source
Defaults(YourDataSource),
{
Name: DataCardValue9.Text,
Job: DataCardValue10.Text,
Date1: DataCardValue48.Text,
Date2: DataCardValue47.Text,
Work: DataCardValue15.Selected.Value
}
);
If(FormTypeDropdown.Selected.Value = "Form",
Office365Outlook.SendEmailV2(
"email@address.com",
"Form",
"Name: " & DataCardValue9.Text & " " &
"Job: " & DataCardValue10.Text & " " &
"Date1: " & DataCardValue48.Text & " " &
"Date2: " & DataCardValue47.Text & " " &
"Work: " & DataCardValue15.Selected.Value & " "
)
);
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jdrm1

After a call to SubmitForm, the form will reset which is why you're not seeing the data that just got saved. The answer is to reference the LastSubmit property instead.

If you haven't done so, you'd want to add this formula to the OnSuccess property of the EditForm1 so that it sends the email only when the record is saved successfully.

If( FormTypeDropdown.Selected.Value = "Form", Office365Outlook.SendEmailV2( "email@address.com", "Form", "Name: " & EditForm1.LastSubmit.Name & " " & "Job: " & EditForm1.LastSubmit.Job & " " & "Date1: " & EditForm1.LastSubmit.Date1 & " " & "Date2: " & EditForm1.LastSubmit.Date2 & " " & "Work: " & EditForm1.LastSubmit.Work & " " ) );
jdrm1 54 on at

Like
a
(0)

Report
Copy link

Link copied!

that still gives the same result when using last submit
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@jdrm1

LastSubmit will definitely return the last record that was saved. The only thing I can suggest is to save the values prior to calling SubmitForm.

UpdateContext({locBody: "Name: " & DataCardValue9.Text & " " & "Job: " & DataCardValue10.Text & " " & "Date1: " & DataCardValue48.Text & " " & "Date2: " & DataCardValue47.Text & " " & "Work: " & DataCardValue15.Selected.Value & " "} ); SubmitForm(EditForm1); If( FormTypeDropdown.Selected.Value = "Form", Office365Outlook.SendEmailV2( "email@address.com", "Form", locBody ) );