Filtering Cascading comboboxes

[Anonymous]

Hi All,

I have a Form with 3 comboboxes (LookUp fields).
The first combobox has a datasource of a company list.

The second combobox has the numbered values, example:
1. Marketing
2. Accounting
3. PR
The items of this combobox are filtered by the company selected.

The third combobox has a lookup to another list, the values are the following:
1.1 Variable marketing costs
1.2 Fixed marketing costs
1.3 Branding
2.1 Item
2.2 Item

The data source of the third combobox has also a Company value, therefore, I would like to filter items based on the company and additionally, if in the value of the first combobox "1. Marketing" is selected, I would like to filter only the following items:
1.1 Variable marketing costs
1.2 Fixed marketing costs
1.3 Branding

In the data source of the third list, I have created an additional column "Related", which has the number value of the main task (example, "1.1 Variable marketing costs" item has the value of 1 in the column "Related").
I was trying to get the number value from the second combobox with split function and then trying to filter the third combobox based on the splitted value and "Related" value but cannot make it work.

Any suggestions on how could I implement the filter function in the third combobox?

Any help is much appreciated!

[NandiniBhagya20 · Accepted solution]

Hi,

You can get the number from 2nd level combobox using split - First(Split("1.Marketing",".")).Result

Then you can filter your 3rd combobox using StartsWith function 

Filter(Choices(SPList.ColumnName), StartsWith(Value, First(Split("1.Marketing",".")).Result))