Want to create cascading dropdown in SharePoint. I have created 2 list department and employee and matched item using lookup. Department has 6 items and employees has 70 items.

So, how to create dropdown list for these two columns?


1 Answer 1


You can use SPServices to achieve this:


  relationshipWebURL: "",
  relationshipList: "",
  relationshipListParentColumn: "",
  relationshipListChildColumn: "",
  relationshipListSortColumn: "",
  parentColumn: "",
  childColumn: "",
  CAMLQuery: "",
  CAMLQueryOptions: "<QueryOptions>   <IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns></QueryOptions>",
  listName: $().SPServices.SPListNameFromUrl(), 
  promptText: "",
  simpleChild: false,           // Added in v0.6.2
  selectSingleOption: false,        // Added in v0.6.2
  matchOnId: false,         // Added in v0.7.1
  completefunc: null,
  debug: false
  • This is the easiest way of all the ways! I've tried several other solutions and spservices is the easiest. Here is the demo: sympraxisconsulting.com/Demos/Demo Pages/CascadingDropdowns.aspx
    – bgmCoder
    Commented Dec 2, 2015 at 3:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.