Unanswered

Keeping Data Card Values After Submitting Form

(1) Share

Report

Posted on by wagner_nathan

I have an edit form that I am using to write entries to a share point list. I have two buttons that I want to use to be able to submit the form. The "Next Part" button will submit the entry and reset the form to default values. This works without any issues. My problem is that I want the "Next" button to submit the entry and retain the last submitted values in the fields outlined in red. The picture that shows this is attached. This will help to minimize the amount of data the user has to re-enter each time. My Edit Form is made up of all data cards. No standard text boxes or any other standard entry fields. Can anyone help me figure out how to do this?

Categories:

Building Power Apps

Data Card Values.png

I have the same question (0)

All responses (8)

Answers (0)

eka24 20,923 on at

Like (2)

Report

You can set a variable in the OnSucess of the EditForm:
Set(varLastSubmit,EditForm.LastSubmit)

Then in the field you want to autopopulate, put:
varLastSubmit.ColumnName
Example: varLastSubmit.TicketID
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (2)

Report
@wagner_nathan

Put this code in the OnSuccess property of your Edit Form.

Set(lastRecord, Form1.LastSubmit)

Then put this code in the Default property for the Part Number Card

If(Form1.Mode=FormMode.New, lastRecord.'Part Number')

Repeat as needed for the rest of the Cards in your form...

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
wagner_nathan 27 on at

Like (0)

Report
@mdevaney

I tried your suggestion and it still resets the value to default after I click the next button. This is the code I have for the OnSelect value of the "Next" button. Do I need to change this?
SubmitForm(EditForm1); NewForm(EditForm1)

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@wagner_nathan

Your code looks good... as does mine 😎 That probably means it was just entered in the incorrect property.

Can you please share a screenshot of where its being entered?

Was this reply helpful? Yes No
wagner_nathan 27 on at

Like (0)

Report

@mdevaney

See the attached screen shots. Sorry, I had to blur out some info...

Data Card - Defau...

EditForm - OnSucc...

Was this reply helpful? Yes No
gennarodp 294 on at

Like (0)

Report

i have your same problem.

Ho do you have resolve it ?

Was this reply helpful? Yes No
jordanaste 10 on at

Like (0)

Report

I also have the same issue, any idea how to solve?

Was this reply helpful? Yes No
kmaack 39 on at

Like (0)

Report

Has anyone been able to get this to work? I'm trying to do the same thing, but it still resets the form after it is submitted.

Was this reply helpful? Yes No