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

Drop List List


I have a form built on a SharePoint List


One of the items is a dropdown list with 3 options plus a "other" option.

We want the user to be given a choice to type in a answer if it not one of the 3 pre-defined options.

This work fine however...


If you add a type in a answer this gets added to the List and then the next time you open the form you last answer is a option in the dropdown list


We don't want this to happen we just want the drop down list to always have 3 options plus Other.


Any ideas how to do this?




Super User
Super User


There are a lot of different ways to go about that...

If you are using the column as a datasource for your dropdown list, then there is no way to exclude them specifically as there is no identifying aspect of any "added" values in the column.


You could:

A) Hard code a list of values for the DropDown list to always appear.

B) Create a seperate column with the DefaultDropDown items and use that to fill your dropdown and update back to the other column.

C) Create another column of "added" items and keep track of new ones there and filter your dropdown by the original column values not in the "added" list.


Those are some options to consider.

I hope that gives you some fuel for thought.

Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
Community Support
Community Support

Hi @pn1995 ,

How do you save the custom value (typed by user manually) from the Combo Box in your Edit form into your SP list?

Could you please share a screenshot about your app's configuration?


I have made a test on my side, and don't have the issue that you mentioned. Please take a try with the following workaround:1.JPG



The Status column is a Choice type column in my SP list. Within the Edit form, set the Update property of the Data card which contains the Status Combo Box to following:

    IsBlank(DataCardValue4.Selected),         /* <-- DataCardValue4 represents the Status ComboBox control in my Edit form */
        Value: DataCardValue4.SearchText

On your side, you should type following:

        Value: YourChoiceComboBox.SearchText

Please check the following GIF screenshot for more details:Test.gif


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.



This is updating a SharePoint List


But my probelm isn't that I can't update the list is a "Other" option, I can do that


The problem is that the pred-fined list is:






When you type in say 5 and SAVE


The next time you add a new entry, the pre-defined list is now








We want it to always be






Unless of cause someone opens up a item in the exsisting list that has already had a manul entry

Also I tried the code you mentioned but I get a error...




Any ideas?

Super User
Super User

Hi @pn1995,

Is this what you want to achieve:

  • in a SharePoint list MainList you have a lookup column scLookup connected to another list LookupList which has an scValue text column
  • this LookupList has 4 "pre-defined" items: let's say 1, 2, 3 and Other
  • when a user selects Other in combo box scLookup I guess you show up a text input field where he can enter a new custom value, say 5
  • when the form is saved you use the Patch function to add the new custom value 5 to the LookupList
  • later on, when the user creates a new item in MainList, he should only see 1, 2, 3 and Other (and not see the custome value 5)
  • but if the user edits the MainList item where he entered the custom value 5 he should see that value selected in the combox box and see only 1, 2, 3, 5 and Other (and not see other user's custom value)


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,735)