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?
Inside this Article
How to filter your Select List column
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. Please note, the Hot or Cold? column in the order table must be set up as a select list column as shown below:
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, and 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:
Need More Support?