Yes:
- Here’s how to make a dynamic dropdown: Dynamic Select Menu
- Here’s how to filter a query using a text field: Filtering Database Query with a Text Input - for the dropdown filter the concept is the same, you just probably need to use “euqal” filter if you want to show a specific record (not contains as with the text field)