cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pn1995
Level: Powered On

Drop List List

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

 

5 REPLIES 5
Super User
Super User

Re: Drop List List

@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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Community Support Team
Community Support Team

Re: Drop List List

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

 

2.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:

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: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.
pn1995
Level: Powered On

Re: Drop List List

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
Level: Powered On

Re: Drop List List

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

 

Capture2.PNGCapture.PNG

 

Any ideas?

egallis
Level 10

Re: Drop List List

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

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 55 members 4,885 guests
Please welcome our newest community members: