Submit Form, On Sucesss of Form Sending emails from previous Submitted Form

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I have a button that submits my form, then on sucess it sends an email, however it is sending the details of the previously submitted form.

Can anyone help with this?

OnSuccess -

Set(gblRecordID, Self.LastSubmit.ID);

Office365Outlook.SendEmailV2(Self.LastSubmit.'Lead_three',"Please review - 2024-" & Self.LastSubmit.ID & " - " & Self.LastSubmit.Segment_two.Value,

"Hi " & Self.LastSubmit.'Lead_three' & "," &

" A request was created for your review:

Ticket Number: &nbsp"&DataCardValue54.Text&" 
Type of Request: &nbsp"&DataCardValue15.Selected.Value&" 
Request Details: &nbsp"&DataCardValue26.Text&" 

Thanks.

", {Cc:Self.LastSubmit.Requestor_Email_two})

where am i going wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

bump

Was this reply helpful? Yes No
WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @wonka1234 ,

Where are the control values coming from ? You might try this using the values you have just submitted.

Set( gblRecord, Self.LastSubmit ); Office365Outlook.SendEmailV2( gblRecord.'Lead_three', "Please review - 2024-" & gblRecord.ID & " - " & gblRecord.Segment_two.Value, "Hi " & gblRecord.'Lead_three' & "," & " A request was created for your review: Ticket Number:  " & gblRecord.TicketNumberField & " Type of Request:  " & gblRecord.RequestTypeField & " Request Details:  " & gblRecord.DetailsField & " Thanks.", {Cc:gblRecord.Requestor_Email_two} )

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
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz values are coming from EditForm1.
I see the record created in the sharepoint list.
When you set(gblRecordID, Self.LastSubmit) - it is causing an error.
I have to use Self.LastSubmit.ID

Was this reply helpful? Yes No
WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@wonka1234 ,

What I posted was gblRecord, not gblRecordID.

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Sorry thought you were making a change to what i had!

ill try out what you had - but why cant I use this instead -

EditForm1.LastSubmit.Field.

Wont this work? Whats the difference ?

Was this reply helpful? Yes No
WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@wonka1234 ,

What I posted is a different approach saving the entire record instead of just the ID. It then allows easy referencing of every field you have just posted.

Was this reply helpful? Yes No