Hi, I have an inventory app. For adding a ne...

[Itay_Golan]

Hi,

I have an inventory app. For adding a new item form:

ID[uniek]{text type} item name{text type} category{EnumList}

for example: ID- “XTY4421” Item name - “banana” Category - “fruits, yellow, happy” (I choose 3 categories)(3 values in one cell)

is it possible to use the Select function if only one of the categories is equals? In order to open a list that related to a category.

for example: I pick “yellow”, and the item list will “banana”. or if I pick “fruits” ill get “banana” also.

thanks in advance.

[Aleksi_Alkio]

You can use syntax as… SELECT(TableName[Item Name],IN([Category],[_THISROW].[Category]))

[Itay_Golan]

Thanks, but still not working. I don’t see the items that have several categories. only the item that has one category

[Itay_Golan]

#ERROR!

[Aleksi_Alkio]

Let me test this…

[Itay_Golan]

OK now I manage to succeed!

=SELECT(Stock[items],and(in([_THISROW].[catgory],[category]),[in stock]=Y))

[Aleksi_Alkio]

Okay good. I probably misunderstood you column structure slightly.