Answered

Retain some form data after submitting.

(0) Share

Report

Posted on by StuartSmith

225

I have a form to record visitor details and after submitting the form I want most fields to clear, but the "Host" and "Visiting Site" fields to retain their values as this info will always be the same for the session and dont want to have to keep retyping the "Host" and "Visiting Site" details.

The only time the "Host" and "Visiting Site" fields should be cleared is when the "Restart" button is selected. How can i clear most fields, but keep "Host" & "Visiting Site" populated when the form is submitted?

Thanks in advance,

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@StuartSmith
When the form is submitted successfully all its data gets stored in the LASTSUBMIT property of the form. We can make some changes to the Default properties of the Cards for Host and Visiting Site to capture this information.
Put this code in the Default property of the Card for Host.

If( IsBlank(Form1.LastSubmit.'Host'), Blank(), Form1.LastSubmit.'Host' )

Also put this code in the Default property of the Card for Visiting Site.

If( IsBlank(Form1.LastSubmit.'Visiting Site'), Blank(), Form1.LastSubmit.'Visiting Site' )

---
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
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @StuartSmith

If you want to pass the same value for all the records, you can set the configuration as:
a) Please add the appropriate datacards and the Visible property as false.
b) In the Update property of these datacards, pass the value that you want to be constant. This could also be a variable that can be set based on the control or Value.
Note: The update property should be passed in the correct format.

If this doesn't help, please share more details about the scenario.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (0)

Report
Copy link

Link copied!

I tried your solution on the "Host" field and the form field remain empty after clicking the submit button (see attached). Could it be because the "Host" field is a "Name Lookup" value?

The code I used on the "Card" default value was "If(IsBlank(Visitor_Registration_Form.LastSubmit.'Host'),Blank(),Visitor_Registration_Form.LastSubmit.'Host')"

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (2)

Report
Copy link

Link copied!
@StuartSmith
I will suggest a different approach now based on some tests I ran:

Put this code in the OnVisible property of your screen
Set(currentID,Blank()); Set(currentVisitingSite,Blank());

Put this code in OnSelect property of your Submit Form button
SubmitForm(Visitor_Registration_Form); Set(currentHost,Visitor_Registration_Form.LastSubmit.Host); Set(currentVisitingSite,Visitor_Registration_Form.LastSubmit.'Visiting Site'); NewForm(Visitor_Registration_Form);

Use this code in the Default property of the Card for Host
currentHost

Use this code in the Default property of the Card for Visiting Site
currentVisitingSite

Note: the prior solution not working was due to the LastSubmit data clearing when we put the form back into New mode.

---
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
StuartSmith 225 on at

Like (1)

Report
Copy link

Link copied!

Thanks for taking the time to supply an alternative solution. I done as you suggested and the code was accepted (no red crosses), but upon pressing the "Submit" button, the details are not submitting it to the sharepoint list and the gallery on the form, they just stay showing on the form.

Any ideas?

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (0)

Report
Copy link

Link copied!

Another option, would be to disable the "Host" and "VisitingSite" combo boxes if 1 record has already been submitted and then pre-populate the "Host" and "VisitingSite" values of any additional rows with the "Host" & "VisitingSite" values found in the first row? Don't know if that would be easier? Hope that makes sense.

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (0)

Report
Copy link

Link copied!

So ultimately, what I want to achieve is that no matter how many rows are added for the current session, the "Host" and "VisitingSite" details will always be the same as row 1.

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

Like (0)

Report
Copy link

Link copied!
@StuartSmith
"Thanks for taking the time to supply an alternative solution. I done as you suggested and the code was accepted (no red crosses), but upon pressing the "Submit" button, the details are not submitting it to the sharepoint list and the gallery on the form, they just stay showing on the form. Any ideas?"

I want to know why the form is not submitting. Please create a label with this code in it. Does any error appear in this label after you click submit?
Form1.Error

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (0)

Report
Copy link

Link copied!
Hi, I managed to get the "Host" one working, i simply removed/re-entered your code. But oddly the"Visiting Site" combo box doesnt display the current value? see attached.

The code I am using is...
Set(CurrentVisitingSite,Visitor_Registration_Form.LastSubmit.Visiting_x0020_Site); or
Set(CurrentVisitingSite,Visitor_Registration_Form.LastSubmit.VisitingSite); (this is how the sharepoint list column is named)

I also removed the line
NewForm(Visitor_Registration_Form);
as this was preventing the form data from showing in the gallery.

I have also been trying to set the "DisplayMode" of the host field to "view", using the code

"If(IsBlank(CurrentHost), DataCardValue14_1.DisplayMode.View, DataCardValue14_1.DisplayMode.Edit);"

But also cant get that to work.
Thanks in advance,

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (0)

Report
Copy link

Link copied!

I have also been trying to follow your example and display the CurrentVisitngSite value in a lablel, but current trying to figure out the code.

Was this reply helpful? Yes No