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

Itay_Golan
Participant III

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.

0 6 333
6 REPLIES 6

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

Itay_Golan
Participant III

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

Itay_Golan
Participant III

#ERROR!

Let me test this…

Itay_Golan
Participant III

OK now I manage to succeed!

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

Okay good. I probably misunderstood you column structure slightly.

Top Labels in this Space