You might be familiar with using lookups to associate values from one table to another. This works well to pull in a list of all associated values into your row, but what if you want to pull them in individually?
To do this, you'll want to filter your select list column. Let's see an example of how this might look in action:
You can see that, once a value is selected in the Hot or Cold? column, the drink options available in the Drink select-list column are limited to those associated with the "Hot" or "Cold" value in the row.
Here's a closer look at the formula:
Within Selectable Items in the column formatting tool, you can start by typing = to open the formula builder, then inputting a lookup or filter formula to draw in the values you're looking for. In this case, the Drinks table is referenced, filtered to compare the Hot or Cold? value in both tables, then the drink name itself is pulled out as the selectable option.
Since Drink is the display column of Drinks, I can also leave off the last part of the formula (ending at the close parenthesis) to create the lookup "chips" in the select list column.
Here's how that looks: