cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vish_p
Level 8

Keep values in the data cards even after submitting the Form

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Keep values in the data cards even after submitting the Form

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Community Support Team
Community Support Team

Re: Keep values in the data cards even after submitting the Form

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vish_p
Level 8

Re: Keep values in the data cards even after submitting the Form

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

Community Support Team
Community Support Team

Re: Keep values in the data cards even after submitting the Form

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vish_p
Level 8

Re: Keep values in the data cards even after submitting the Form

@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.

 

Community Support Team
Community Support Team

Re: Keep values in the data cards even after submitting the Form

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

vish_p
Level 8

Re: Keep values in the data cards even after submitting the Form

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 403 members 5,723 guests
Please welcome our newest community members: