Cascading dropdown with 4 levels deep

[robdegekste]

Hi all,

I just made an nice app with three levels deep cascading dropdown. 

https://www.youtube.com/watch?v=Qzpjq008cBY&t=861s&ab_channel=RezaDorrani i used this as an example.

This works fine! I would like to add an 4 field, is that possible?

When i try to use the filter or distict option i get an error for the fouth column.

Have anyone experienced with 4 levels of cascading? 

[BCBuizer]

Hi @robdegekste,

Can you please share the formula that is not working and the error message you get?

[robdegekste]

Sure! Here are my formule

Column 1 : 

Distinct(Sort(Filter(SoftwareList;true).Title;Title;Ascending);Title)

Column 2   :

Distinct(
    Filter(
        SoftwareList;
        Title = DrpName.Selected.Result
    );
    Name
)

Column 3:

Filter(
    SoftwareList;
    Manager = DrpSoftwareName.Selected.Result
)

Column 4: this one is not working...

Filter(
    SoftwareList;
    Code = DrpSoftware.Selected.Result
)

[BCBuizer]

Hi @robdegekste ,

Please try:

Filter(
    SoftwareList;
    Code = DrpSoftware.Selected.Value
)

The reason this may work is because in the first two dropdowns you have used the Distinct function which returns a column called Result. The third does not, so a different column needs to be selected, where Value is the default for dropdowns.

If this doesn't work, please share the error message your receive.

[robdegekste]

Normally after 

DrpSoftware.Selected

I can only select Result or sometimes Value.

After the dot (.) i see now the internal names of the SharePoint list. Results or Value doens't work.

[BCBuizer · Accepted solution]

Hi @robdegekste ,

Could it be you are using a combobox instead of a dropdown (as per the video)? In that case, select the name of the column you wish to filter for, for instance .Code .

[robdegekste]

Normally i use three single dropdown box for the cascading. Now with 4 levels deep i use 2 dropdown box and two combo box, and i works fine! Thnx for your help!