Hi All Expert here,
I was searching very long if there is any other efficient way to show the gallery based on the combo boxes selected.
For example, there are 5 combo boxes, user doesn't have to select all the five combo boxes to get the result in the gallery.
They can select items in 1 or 2 or 3 of the combo boxes, then the gallery will show the result which fulfilled the selected items.
I have tried many ways to write the script but it still doesn't work.
Except IF ELSE/SWITCH, is there any alternative way? which search/filter easier/faster way for many input fields?
Thanks in advanced!
First of all, thanks for your response.
Here are the examples, I need to search Mobile Phones based on Model, Brand, Color, Memory Size and Store.
Sometimes, I wish to see Store A have what models there, then I just need to select Store A and leave other combo box empty.
Or I can search based on the color(Blue) and the memory size(258GB), then I will see the models which are Blue and 258GB in the Gallery.
I tried to write in these ways:
- Filter(Table, if(..., ...),if(..., ...),if(..., ...),if(..., ...),if(..., ...))
- Filter(Table, ... && ... && ... && ... && ...)
All above,the gallery only shown result after all 5 combo boxes are selected.
If I use OR||, the results will be something like outer join, right?
Is it only can use Nested IF inside another Nested IF (maybe more levels)?
Thanks for your suggestion, I have tried but the result only shown after all of the combo boxes selected.
I tried to change && to ||. The result is correct if only one combo box is selected. However, the results are the combination of multiple selection if multiple combo boxes are selected(inner join), it doesn't show like full outer join.
Very sorry that I wrote wrongly in my last reply.
Please read the correction in Magenta below.
I tried to change && to ||. The result is correct if only one combo box is selected. However, the results are the combination of multiple selection if multiple combo boxes are selected(full outer join), it doesn't show like inner join.
Full outer join is as mentioned by you in the last reply.
May I know about inner join?
Thank you so much!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand