Updated the SPList with the new column and value to support current series. Whenever modified we can refresh the data source explicitly

Now we need to map the list to show items base on the dropdown selection (i.e. Show list based on selected product)

There are couple of ways to do it let see How? & why?

Go to the formula bar and enter the 1formula

We used “Filter” function to filter the items in the list for the better

based. Because we know the exact condition to filter out the rows from the rows. Confusing…? Okay, let’s drill down with the SQL Query example; to do the same set of filtering we would use the below query