cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Super User III
Super User III

@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.
Check out my PowerApps Videos too!
Highlighted
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

 

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

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

Highlighted

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

 

Capture2.PNGCapture.PNG

 

Any ideas?

Highlighted
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)

Emmanuel

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,009)