In previous articles we discussed how you can filter a SharePoint data source. Lets take this a step further and show how you can get one SharePoint drop-down menu to filter another one (aka cascading drop-downs).
To filter one drop down based on another drop down you need to set the filter query on your SharePoint Datasource to reference the response of the previous drop down.
Advanced Filter Query
For the example, the code used to filter the second drop down menu based on the first is described below.
show = item.Make === data.model.Make
The code may be a little confusing at first glance, however lets deconstruct it.
To help in determining the right side of the expression you can use the code view on the preview screen as show below.
Additionally you can use the Sample Item to help determine the left side of the formula. In this case