Filter Lookup field

[Radoslavov]

Hi all, I have a problem figuring out the formula for filtering a combo box.

I have an SPO list called equipment, inside I have equipment that are referring to one another as some equipment can be used as an optional briefcase, mouse, headsets, etc.

The user will select equipment from one dropbox, and one the other one to show if there is an option equipment that can be selected, as the lookup field on SPO is multi-select one.

So basically the lookup is referring to itself.

I've tried using this formula but it's not working:

Filter(Equipment, 'Optional equipment' = dpd_It_equipment.Selected.Title)

Bundle dropdown -  dpd_equipment_type

Optional dropdown - dpd_optional_equipment

Any ideas on how can I filter the option only to show optional equipment available for the selected Bundle?

Regards,

Kiril

[victorcp]

Hi,

As it is a multiple choice column you have to use 'in', like this:

Filter(Equipment, dpd_It_equipment.Selected.Title in 'Optional equipment'.Value)

unfortunately it is not delegable and there is no workaround that I know to avoid that, but if you have less than 2000 items it will not be a problem.

I hope it helps 🙂

[Radoslavov]

Hi @victorcp thank you for assisting with this, unfortunately, nothing is happening after i used the formula, the dropdown is not showing anything.

I don't have more than 50 items on that list, and there will be no more than 100 in the future either.

[victorcp]

Oh, sorry I didn't understand what you needed.
There was only one thing missing on your formula:

Filter(Equipment, 'Optional equipment'.Value = dpd_It_equipment.Selected.Title)

[Radoslavov]

I think we are getting close, but now I'm getting another error: Incompatible types for comparison. These types can't be compared, Table,Text

I tried, changing the = to in, but I'm getting a different error: for the .Value: Invalid argument type.Cannot use table value in this context 

[victorcp · Accepted solution]

There is a easy way of doing this, try this:

dpd_It_equipment.Selected.'Optional equipment'

This time it should work

[Radoslavov]

**bleep**..... it's so simple! 😀

Thank you so much for the help!