Forum Discussion
Cascading Drop Down Lists in SharePoint
Wonder if you can help me with this
I am trying to make this cascade look up work for me on Sharepoint Lists.
I have a main list called registration.
I also have 3 lists called Employee, Courses and Categories.
Course List has columns: Course, category, Course ID, Date, etc
Categories List has one columns, category
Employees Field has Fields : Department, Employee ID, Employee Name etc
From the Registration List, when I Select a category, In the drop down I only want to select a course, on the courseID field
When I Select a Department, from the Employee List, I only want to see Employees in that department in the Employee ID field
When I Select a course, I only want to choose dates for that course
I have seen the codes above, but I am having a hard time making it to work.
Any help will be greatly appreciated.
I would recommend using PowerApps to create a custom form, here is an example https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Cascading-dropdowns-for-single-line-of-text/ba-p/22927 from DaR0GaE1