Announcements
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?
Hi @robdegekste,
Can you please share the formula that is not working and the error message you get?
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 )
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.
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.
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 .
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!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 534
WarrenBelz 416 Most Valuable Professional
Valantis 306
