How do you use a filter with App inventor 2 and google spreadsheet?

[TIMAI2]

Examples and guides for open and restricted google sheets are available in posts 2 & 3 above, using the gviz query language.

To find matching items in a list, see here (you want Item 6, search for an item):
https://imagnity.com/tutorials/app-inventor/list-blocks-on-app-inventor/

Also...

Revival - Italo's Custom Listview Filter Bar - with Clock

With all links to Italo's guide on the above lost from appyBuilder and Thunkable, I thought I would put up a remix of the original blocks, with an aia project example. This uses a clock timer instead of a textbox extension. The only change I have made is to add an extra conditional check: does the last textbox content equal the current textbox content (if so, do nothing), to cut down on unnecessary processing. This also ensures that listview selections above the last one can be made. Clock timer…