Continuing to discuss the issue, see this example
This is my data set in sheet1
I go to another sheet (sheet2) and create the same columns with additional search column
In the first row and first column of the data enter this formula
=filter(Sheet1!A2:B7,Sheet1!A2:A7=C2)
This means that Google sheet will regenerate the list in sheet2 that matches the text entered in the search column.
In Thunkable you can place a Text Input
and update that row/column in Google sheet to get the filtered value which is mapped to the DVL (Data Viewer List) in your Thunkable screen.