Hi, probably you have to study and save data in a different way to manage better the query and the search inside the table.
Anyway I think you have 2 ways .
1- make a query and save data like dictionary so you can use the dictionary’s block to make you search. Here a GUIDE to see how dictionary works about search.
2- More expensive . You have to work with variable and list and with some cicles manage the data .
Ex. Call the column A and B , save them in two variables, then manage A with a temp variable and with a for each item if item is not in list you add it to a temp list, so you will have a new list without copy to show inside spinner.
When you select the first spinner , you need a new for each item in list A where if item= select spinner you have to add the index of the item in a temp list. Now you have a list with all the index you have to take in list B , with a for each inside this temp list you have get the right items in list B (select list item list B index item (from for each )
Is more easy to code than to explain ![]()