Answered

Reset Edit Form but maintain last submitted changes

(0) Share

Report

Posted on by anilrambhajan

Hi,

I have an Edit form with a save and reset button. When the user makes a change and clicks save, data is updated on the sharepoint List. However should the user click reset "ResetForm(FormEditRequest)", the last submitted changes are not reflected. The form resets to what was there when the form initially loaded, that is prior to the save action.

Can someone assist?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Ashwin7104 671 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @anilrambhajan - Use Refresh(DataSource) before ResetForm command.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,877 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @anilrambhajan,

Click Form and Select OnSuccess Operation and Store the values like Set(lastSubmit,FormName.LastSubmit)
Reset Button --> OnSelect --> Set(lastSubmit,Blank());

if you want to Reset Whole Form

Click Form and OnSuccess event --> ResetForm(FormName);

Please Mark as Answer if its helpful
https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
anilrambhajan 90 on at

Like
a
(0)

Report
Copy link

Link copied!

This still looses the saved value

Was this reply helpful? Yes No
anilrambhajan 90 on at

Like
a
(0)

Report
Copy link

Link copied!

This works but If I type something and do not click save, when I click reset, the typed values remain.

I want on the reset to retrieve the latest values stored in the SharePoint list

Was this reply helpful? Yes No
Ashwin7104 671 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @anilrambhajan - I attempted to reproduce the problem in my test form but was unable to do so.

// On Submit button - OnSelect SubmitForm(Form1);
// On Success of Form1 ResetForm(self);
// On Reset Button - OnSelect ResetForm(Form1)

I can submit the form and reset it to get the last saved value by following the steps above. Before clicking the Reset Button, I hope you double-checked the data saved in the SP list.

Was this reply helpful? Yes No
anilrambhajan 90 on at

Like
a
(0)

Report
Copy link

Link copied!

Still no luck. Am I missing another setting that needs to be turned on? This is via "Edit Mode" of a Form control

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @anilrambhajan ,

I assume you are navigating to this edit form from a main screen with a gallery. OnSelect of the Gallery you will see Select(Parent) and in Item of the Edit form it may be Gallery.Selected

To solve your issue, you could try:

1\ OnSelect of the Gallery:

Set(varID, ThisItem.ID)

2\ OnSelect of the save button:

SubmitForm(FormEditRequest)

3\ OnSuccess of the FormEditRequest form:

Set(varID, FormEditRequest.LastSubmit.ID); ResetForm(FormEditRequest)

4\ Item of the FormEditRequest form:

LookUp(SPlist, ID = varID)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
anilrambhajan 90 on at

Like
a
(0)

Report
Copy link

Link copied!

This works. Thank you very much

Was this reply helpful? Yes No