Drop List List

[pn1995]

Hi

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?

Thanks

[RandyHayes]

@pn1995 

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.

So...

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.

[v-xida-msft]

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:

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:

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

On your side, you should type following:

If(
    IsBlank(YourChoiceComboBox.Selected)
    {
        Value: YourChoiceComboBox.SearchText
    },
    YourChoiceComboBox.Selected
)

Please check the following GIF screenshot for more details:

Best regards,

[pn1995]

Thanks

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:

1

2

3

Other

When you type in say 5 and SAVE

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

1

2

3

5

Other

We want it to always be

1

2

3

Other

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

[pn1995]

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

Any ideas?

[R3dKap]

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)

Emmanuel