Valid if list does not show full list

[aminsaleh]

Hi there, Instead of using enum list, I am trying to use a valid if to read the data from the database file directly. problem is that the text column does not show the full list of items.

>> For example see here in the (Database table) (main category) column. There are several values.

In the main category column I added this formula inside the Valid If formula

Database[Main Category]

Problem now in the app main category only reads one item, I want to show the full list and I select one then.

[AleksiAlkio · Accepted solution]

One reason could be that you have created a dependent dropdow. Try to write it like..

SELECT(Database[Main Category],TRUE)

[aminsaleh]

@AleksiAlkio  Thanks very much indeed

[AleksiAlkio]

You're welcome!