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.
Use a Select functon in the suggested field to build the list e.g.
Select(TableName[Product Type],[Description]=“KV”)
Great thank you @1minManager
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |