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
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.
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,
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
Also I tried the code you mentioned but I get a error...
Any ideas?
Hi @pn1995,
Is this what you want to achieve:
Emmanuel
User | Count |
---|---|
188 | |
125 | |
91 | |
47 | |
42 |
User | Count |
---|---|
271 | |
161 | |
134 | |
84 | |
78 |