Answered

SendEmailV2 sends via email different records than the ones submitted

(0) Share

Report

Posted on by sona_b

Hello, I have an issue with my Power App and I hope someone would be able to advise.. I have a Sharepoint list connected to the App and it is basically adding/adjusting records in the FTE database, all working correctly. I need to add a functionality that would send an email with the record added/adjusted on the submit. I tried to add in the OnSuccess property of the form the following:

Office365Outlook.SendEmailV2("my@email.com","Notification - Change in Training",
"Name: "& EmpName1.Text&
"<br> Username: "&Username1.Text&
"<br> Training Assigned: <br>"&Concat(TrainingAssigned1.SelectedItems, Value & " <br>"))

And I indeed receive an email notification on submit, but everytime with values from a different record (last accessed or first from the list), not the one submitted! I checked the Sharepoint list and everything is fine there, just the email contains random data.. any idea how to fix this please?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

WarrenBelz 153,075 Most Valuable Professional on at

Like (1)

Report
Hi @sona_b ,

You need to either send the mail before you submit the form or refer to the field values you have just submitted as below

Office365Outlook.SendEmailV2( "my@email.com","Notification - Change in Training", "Name: "& Self.LastSubmit.EmpNameField & " Username: " & Self.LastSubmitUserNameField & " Training Assigned: " & Concat(Self.LastSubmit.TrainingAssignedField, Value," " )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
sona_b 10 on at

Like (0)

Report

You are right, thank you so much!!! 🙂

Was this reply helpful? Yes No
sona_b 10 on at

Like (0)

Report
Can I ask in addition please - at first I thought just adding the SendEmailV2 before the Submit command as you suggested, I just realized that sometimes user can click on the Submit button with incomplete form which will not be submitted, but the incomplete email will be sent out.. so I wanted to use your code with Self.LastSubmit references, but it does not work for me on the comboboxes, it underlines the TrainingAssignedField, is the syntax correct please?
" Training Assigned: " & Concat(Self.LastSubmit.TrainingAssignedField, Value," ")

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,075 Most Valuable Professional on at

Like (1)

Report

Hi @sona_b ,

Just add the submit after the mail. You will have to use Form.Valid before this if you want to check the form is complete.

Was this reply helpful? Yes No
sona_b 10 on at

Like (0)

Report

Thanks a lot, it worked with Form.Valid 🙂

Was this reply helpful? Yes No