Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Dropdown selecting value from last edited item

I have a SharePoint list where I've edied the default form. I added a dropdown field to replace a text field. The dropdown gets its values with Distinct(TABLE, COLUMN), where the COLUMN has the first row as blank, so that the dropdown's default value is blank.


When I edit an item in my SharePoint list, the edit mode of the form has the dropdown correctly grabbing the COLUMN value in that item.


The issue is that after editing an item in the list, if I try to add a new entry in the SharePoint list, the dropdown will retain the last value it had from the last item edited.


Is there a Dropdown or Card property I can edit to have the dropdown reset to the first value of the column setup in its Items field?


I'm just starting to use PowerApps, and I may be describing things unclearly. I've found similar issues mentioned in passing in two other threads, but with no solution provided.

Community Support
Community Support

Re: Dropdown selecting value from last edited item

Hi @MateiC,

Could you please share a bit more about your scenario?

Do you custom a form for your SP list using PowerApps?

Further, do you add the Dropdown control within your Edit form or outside the Edit form in your app?

I have made a test on my side (customize a form for your SP list), and don't have the issue that you mentioned. 


If you add the Dropdown box outside the Edit form (SharePointForm1) in your app, I think the Reset() function could achieve your needs. Please add the following formula within the OnNew property of the SharePointIntegration control:

Reset(Dropdown1) /* <-- Add this formula. Dropdown1 represents the Dropdown control you added within your Edit form */

If you add the Dropdown box within (inside) the Edit form (SharePointForm1) in your app, please take a try to set the DefaultMode property fo the SharePointForm1 (Edit form control in your app) to following:


then check if the issue is solved.

If the issue still exists, please consider take a try to remove/delete the custom form for your SP list, then re-create a new one, 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.
Advocate I
Advocate I

Re: Dropdown selecting value from last edited item

Yes, I customized the form in a SharePoint list, and I added the dropdown within a DataCard of the SharePointForm.


The DefaultMode property of the form is already set to FormMode.New. I've also tried adding the Reset formula to the OnNew property of the integration control, to see what happens, with no changes. Deleting and recreating the custom form gives the same form behaviour.

Helpful resources

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,679)