How to reference previous value of a datacard

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I have an email that sends out onselect. But i want to reference the value before it is submitted.

I have something like this on my onselect.

SubmitForm(EditForm1_1);

Office365Outlook.SendEmailV2(Dropdown2.Selected.Value,"A Ticket has been Assigned to you. Ticket: "&DataCardValue54.Text,"
Previous Lead: &nbsp"&HOW TO REFERENCE PREVIOUSLY SUBMITTED VALUE HEREt&" 
 Lead: &nbsp"&DataCardValue24_1.Text&" 
");

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Datanerd 103 on at

Like (0)

Report
Copy link

Link copied!

Hi @wonka1234 ,

To reference the just-submitted item, use the LastSubmit () function.

Formname.LastSubmit.YourFieldValue

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@wonka1234 What do you have in the Item property of the Form?

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

Like (0)

Report
Copy link

Link copied!

@CNT ITem property is - LookUp('Intake',ID = gblRecordID)

@Datanerd is there a way to reference the previous submitted item? Because I want to show the Old and the New (the new will be created on the submit of the form on select of the button)

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@wonka1234 Do this before the SubmitForm,

UpdateContext({varLead, LookUp('Intake',ID = gblRecordID).LeadColumn})

Then,

use the variable varLead in the Email.

Please remember to give a 👍 and accept my solution as it will help others in the future.

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

Like (0)

Report
Copy link

Link copied!

@CNT getting error - invalid number of arguments, 2 instead of 1

UpdateContext({varLead, LookUp('Intake',ID = gblRecordID).Lead_three});

Lead_three is the sp list settings column name.

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@wonka1234 Try this,

UpdateContext({varLead: LookUp('Intake',ID = gblRecordID).Lead_three});

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No