I had a request to build a form where a manager could assign multiple training classes based on a job-specific need. With multiple cascading drop-down options I had to filter a list lookup.
The first task was to create a calculated column in my master SharePoint list. This combined the values from various columns to be my filter for the master training class list.
This is my calculated “Task Display” column.
=CONCATENATE(Section,”-“,[Suspense Grouping],”-“,Technology,”-“,[Sub-Technology])
In the form, I have a hidden calculated value field; “Combo”. This populates as the options are selected via the drop-down menus.
parseLookup(Section)+”-“+SuspenseRange+”-“+parseLookup(Tech)+”-“+parseLookup(sTech)
This filters the master training class list via the List Lookup control.
