cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Radoslavov
Skilled Sharer
Skilled Sharer

Filter Lookup field

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.

Radoslavov_0-1670492780041.png

Radoslavov_1-1670492824705.pngRadoslavov_2-1670492864280.png

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

Radoslavov_4-1670492935725.png

Radoslavov_5-1670493092951.png

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

 

Regards,

Kiril

1 ACCEPTED SOLUTION

Accepted Solutions
victorcp
Solution Sage
Solution Sage

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

dpd_It_equipment.Selected.'Optional equipment'

 

This time it should work

View solution in original post

6 REPLIES 6
victorcp
Solution Sage
Solution Sage

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 🙂

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

Radoslavov_3-1670496636476.png

Radoslavov_1-1670496483566.pngRadoslavov_2-1670496523404.png

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

victorcp
Solution Sage
Solution Sage

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)

 

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

Radoslavov_0-1670502014368.png

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 

Radoslavov_1-1670502123102.png

 

victorcp
Solution Sage
Solution Sage

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

dpd_It_equipment.Selected.'Optional equipment'

 

This time it should work

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

Radoslavov_0-1670502749069.png

Thank you so much for the help!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,397)