Valid if list does not show full list

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.

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

SELECT(Database[Main Category],TRUE)

2 Likes

@AleksiAlkio Thanks very much indeed

You’re welcome!