List filter

[MauriceWhelan]

Hi. I have a dependent dropdown in my form and I need to filter out a lot of options from the list.

Its the [Product Type] column and I only want to return products with “KV” in the description.

Am I right to use the suggested values field? If so could you advise on the right syntax. What I have used so far doesn’t seem to be working.

Thanks.

[1minManager]

Use a Select functon in the suggested field to build the list e.g.

Select(TableName[Product Type],[Description]=“KV”)

Simon@1minManager.com

[MauriceWhelan]

Great thank you @1minManager