Hello everyone!
I need some help to resolve this filtering task.
I have this galley and I want it to a various dropdown and a inputtexte to filter it.
This is the case:
1) First I have a dropdown that determine in wich collum of the sharepoint list will look, dependind the resoult of the dropdown. We have 3 options, so If choose option PROTOCOL, go to the collum PROTOCOL in Sharepoint list to search, If choose NAME, to the NAME collum and if choose ID, is going to look in the ID COLLUM.
I'm using Search and Switch function, and it's kind like this:
Search(DATABASE;
Switch (drop_SearchFor = "PROTOCOL"; Filter([DATABASE];CR_PROTOCOL;
"NAME"; Filter([DATABASE];SL_NAME;
"ID"; Filter([DATABASE];SL_ID);
2) Going to add the empty and Is black:
IsBlank(drop_SearchFor.Select.Value) || IsEmpty (drop_SearchFor.Selected) || "CR_PROTOCOL" ;(Input_SearchFor.Text);;
3) The second space to filter is one inputtext, that is going to filter based in what the first combobox options. So, if someone type a number of the protoco, name or ID.
4) I have more 7 drodown's to add, but I stucked First if what I think in 1) and 2) is one possible way, and how to add the others comboboxes. I've saw some videos, but I think don't understand completly and I can move forward.
Can someone help me? 😞 Thanks a lot!
