Keep values in the data cards even after submitting the Form

[vish_p]

Hi all,

I am using a form to receive data from users and pushing into my SPList,niw user requirement is that ,they have to make multiple entries for slighlty modified entries ,so i would like to show the last submitted data to the user in a newform and then let them modify whatever they want and then submit as a new record

i tried using edit form and kept my form "Item" as Form1.Lastsubmit but that doesn't submit the record as new instead it updates the exisitng record ,so please let me know how to retain the last submitted values in all fields in order to enable user to submit another new record based on the last submitted data

[v-xida-msft]

HI @vish_p ,

Do you want to retain the Data card values within your Edit form after you submit an item?

Based on the issue that you mentioned, I think this issue may be related to the DefaultMode property of your Edit form. Please check if you have set the DefaultMode property of your Edit form to FormMode.New.

In default, the DefaultMode property of your Edit form set to FormMode.Edit, If you do not set your Edit form to New Form (FormMode.New), the Edit form would be used to update a record rather than create a new record. 

On your side, please take a try with the following workaround:

Set the OnSuccess property of your Edit form to following:

Set(CurrentSubmittedRecord, Form1.LastSubmit);
NewForm(Form1)        /* <-- Add this formula to set your Edit form to New Form */

Set the Item property of your Edit form to following:

CurrentSubmittedRecord

The user @raddy has faced same issue with you, please check my response within the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/New-form-without-resetting-the-fields/m-p/146...

Please take a try with above solution, then check if the issue is solved.

Best regards,

[vish_p]

Thanks for the response @v-xida-msft !!

I tried the same but it is not working as expected

My form starts as new form and after user successfully submits the form,as you have suggested i have dont the following in Onsuccess property :

Set(CurrentSubmittedRecord, Form1.LastSubmit);
NewForm(Form1) 

Everything works fine ,but when the form shows as newform,all fields are reset.

I have set the Item of my form as

CurrentSubmittedRecord

this data shows fine if i replace newform with editform in onsuccess propery ,but i dont want to update the data instead i want the user to submit that as a new record..

pls help

[v-xida-msft]

Hi @vish_p ,

Within your Edit form (which are in New mode), you could consider set the Default value for the corresponding Data cards from the CurrentSubmittedRecord variable. 

Please take a try with the solution I provided wihtin the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/New-form-without-resetting-the-fields/m-p/146...

I assume that there is field called Address in your Edit form, please take a try to set the Default property of the Text Input box within the Address Data card to following:

CurrentSubmittedRecord.Address

please consider use the following formula to set Default value for the other Data cards in your Edit form:

CurrentSubmittedRecord.ColumnName

Best regards,

[vish_p]

@v-xida-msft 

I tried changing the default values as you have suggested ,but the issue now is that whenever user tries to apply for a new record ,this newform is being shown with the default values that it pulls from last submitted record ,so the user is not able to submit a new record,instead the newform comes always with these default values.

My only requirement is such that user should be able to submit a new record as well as should be able to add a new record on the basis of last submitted record.

[v-xida-msft · Accepted solution]

Hi @vish_p ,

Within the Edit form (which is in New Mode), you could determine which fields should use the values from last submitted form. The end users could also update/change these Default values within the Edit form (New Form).

In addition, you could consider set Default value for these fields in your Edit form based on some conditions. E.G. Set the Default property of the Text Input box within the Address Data card to following:

If(
   Column1 = "A",    /* <-- Type your judgement condition here */
   CurrentSubmittedRecord.ColumnName
)

Best regards,

[vish_p]

Thanks @v-xida-msft ,finally i have used if condition inside defalt of my form to acheive what i wanted

[Anonymous]

Hi can you please explain more on the judgement condition. thanks