If you’re using Airtable, I prefer their API’s filterByFormula command described here: Airtable Web API - Using filterByFormula or sort parameters. There’s an example of using it with Thunkable here: The AirTable API (a more efficient way to integrate AirTable with Thunkable) - #22 by jared.
It gives you powerful control over what data you retrieve from Airtable based on multiple conditions.
But if you do need to do this with Thunkable blocks without accessing the API, you need to make sure that your row id values are valid. Row ids are long (hidden) character strings like “A$DN8762!M90KW%” or they can be integers representing the row number in a data source. But attaching a list of values as a row id is surely not going to work.
The summary you provided sounds like a complicated set of steps would be required. It’s certainly possible to do with Thunkable but it’s beyond what I can offer here on the forums. You might consider reaching out to Thunkable Support if you have a Pro or better license or hiring someone to help with this.