When editing list item that has lookup field, Is it possible to filter the lookup field based on a value in the secondary list?

[Xv]

I have a list that has a column of type Lookup. I would like to limit the values that appear in the lookup dropdown when editing the list item. Is it possible to apply a filter to the dropdown based on other columns in the secondary list?

I hope this makes sense.

[RandyHayes · Accepted solution]

@Xv 

Yes, you can use a Filter in the formula for your Items of the Dropdown.

In General:

   Filter(yourOtherList, someColumn = whateverYouWantForCriteria)

If it is based on a value in the current list, then just utilize that in your filter.

Ex.

   Filter(yourList, ProductCategory = ThisItem.Category)

I hope this is helpful for you.