Unanswered

Resetting drop downs to last submission text

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

When I click on the "SubmitForm" button, I would like my 3 drop downs to stay at their most recent submitted text (unless new form is selected which I want all fields to blank out -reset) and currently they don't blank out. My first Item is "" and I would like my drop downs to reset to the first Item. Currently all fields are being reverted to the previous submission prior to the most recent one and I have to select within Gallery to select to edit the most recent submission. What can I do to fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

OnSuccess of the form, create a Variable:
Set(VarLastItems,FormName.LastSubmit)

Then on the Default of the dropdown1 put:
VarLastItems.Column1

Then on the Default of the dropdown2 put:
VarLastItems.Column2

Do same for the rest.
You can give a screenshot if you have issues
------------

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 The fields are filled within the drop-down in screenshot dd1 and and ss1 is the success screen after the form has been submitted. The user is allowed to click back to go back to the form screen which hows in dd2. Using your code has blanked out the dropdowns. I would like the dropdowns to be populated alongside all the other fields from the most recent submission, not blank them out. How do I do this? Thanks

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried the formula I gave because you didn't say anything about it
------------

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 Yes I did

Default: for Department drop down
ThisItem.'Department ' And VarLastItems.'Department '

OnSucess:
Refresh('Standards Selection Form Data Collection') And Set(VarLastItems,Form2.LastSubmit)

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Use
Default: for Department drop down:
VarLastItems.Department

I hope you have a column named "Department"
------------

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 Yes I do, and keeping only VarLastItems.'Department ' allowed for drop down selections to stay as is. So thank you.

The form still reverts to the second previous submission not the most recent submission. So I still have to go my the most recent submission in the gallery to populate the fields. Also, an ongoing issue is if I want to create a new form, the drop down do not reset to being blank. I currently have "" as the first item within Items. How can I have the fields reset to being blank if I chose NewForm (currently an icon)?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 I'm unsure what happened, the drop downs will not change as I change from submission to submission within the Gallery. They stay on the last submissions drop down values. Please assist

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you explain 'As I change from submission to submission within the Gallery" are you submitting from a Gallery or a form

Also can you show a screenshot of the On success formula on your form
------------

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eka24, I have a gallery on the left hand side and as I click from one submission to the next the drop downs should change along with the selected submission (form) but they currently stay at the last submitted drop down values. So I guess I'm submitting from a form and looking up forms through the gallery to edit. Ex 1 and ex 2 should how Department stays the same for the both submissions.

OnSuccess:
Refresh('Standards Selection Form Data Collection') And Set(VarLastItems,Form2.LastSubmit)

Default for dropdown:
VarLastItems.Module

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

I think your request keeps changing. Based on the your attached, you want whatever is selected in the Gallery to appear on the default of the dropdown.
In that case, on the icon > in the Gallery, set a variable OnSelect property of the icon:
Set(SelectedGal,ThisItem.Department)

Then on the Default of the Dropdown put:
SelectedGal

------------

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