Multiple Filters on List Lookup
Currently when you add a list lookup to a form, it only allows you to choose one filter when you don't want to display all list items. Sometimes this is not enough to return the correct results, and multiple filters are required. Something like what is available in InfoPath (see attached image if you are not familiar with the feature) would be great.
Here is a use case example. I have a list that contains vehicle types (truck, SUV, sedan, etc.), manufacturer name (Ford, GM, Honda, etc.) and model (F150, Yukon, Odyssey, etc.). In order to effectively filter the the choices for model, I would first choose the manufacturer. In another lookup I would select the vehicle types offered by the manufacturer (filtered by the selected manufacturer in my prior lookup). Finally, a third lookup would be used to choose the model, filtered on BOTH the manufacturer and vehicle type from the prior two lookups.
David cross
shared this idea
Thanks for your suggestion. I will update the ticket if we have anything to share on this idea.
Cheers,
Euan
-
Anonymous
commented
There is actually a workaround for this in the short term that I have used recently.
On your list(s) have essentially a search string column, which combines two fields eg "Truck Ford", which I use a workflow to ensure that field is always correct if the fields change.In your form then use a variable to combine the two form control values into the same format and filter by that variables on the search string column, returning anything with "Truck Ford" in that column.
Not the best solution but it worked in my scenario until we can filter by multiple fields.