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?


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
| improve this answer | |
  • 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 Dec 2 '15 at 3:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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