Is it possible to have a filtered drop down l...

[Phil_Renda]

Is it possible to have a filtered drop down list that you can add to? I think the way you filter is with valid_if but that will not allow new records

[Aleksi_Alkio]

If you use “fixed” values in Enum field, you can set the option “AllowOtherValues” to true. Then the user can add new values.

[Phil_Renda]

I think this would not allow me to have a filtered drop down list based on another selection. Essentially I am trying to have something like the 2 columns- Country and Restaurant. If someone selects a Country, the list of Restaurants is filtered to what currently exists in the data…but the user can still add a new restaurant if they want. Is this possible?

[Aleksi_Alkio]

Gotcha… you should be able to do that with the ref field. You can use the dependent dropdown after you have selected the first field’s value.

[Phil_Renda]

So in this example, the restaurant field would be changed to Type=Ref? How do you create the dependent dropdown? I only know how to do this through valid_if

[Phil_Renda]

Dependent dropdown requires Valid_If which makes adding disabled

[Phil_Renda]

haven’t had time to get into this person’s extensive workaround from 2016 but may have to look into it plus.google.com - Add values to dependent dropdowns: I am trying to have a set of dependent dr… Add values to dependent dropdowns: I am trying to have a set of dependent dr… plus.google.com

[Aleksi_Alkio]

When you first choose the country, you can query the restaurants with the expression SELECT(TableName[Restaurant],[Country]=[_THISROW][Country]) Put this formula into the Valid_If field.

[Aleksi_Alkio]

Typo error… one dot was missing. SELECT(TableName[Restaurant],[Country]=[_THISROW].[Country])

[Phil_Renda]

Receiving the following error: “Column _THISROW is used in a SELECT expression. It is the wrong type. It should be a list of rows.”