Filter Stock List for Enum

Jaros
New Member

I have a list in a table called Stock items.

The stock items are categorised into packaging, raw and selling items.

I have another table which is used to do a mock recall on a selling product.

Rather than create a new table with only selling items I want to filter the dropdown Ref column in the recall table.

I tried a SELECT expression

SELECT(
Ref Raw and Selling Stock Items[Stock Item],
[Selling/Raw] = โ€œSellingโ€,
TRUE
)

In the Valid_if section and this appeared to work but I have little triangles with exclamations next to my results in my dropdown.

What could be causing that?

0 4 109
4 REPLIES 4
Top Labels in this Space