Here’s a demo of how to do this:
https://x.thunkable.com/copy/c05336660d538ffec6e818808a64ed92
(See the screen with your username.)
You should never have a join block connected as a row id. Row IDs are either integers or they are long text strings like “H@#7d9E0&n3kL2!m”. You either use a whole number or you look up the ID itself using the list of values block:
