Cascading Drop Down Lists in SharePoint

Copper Contributor

Hi all,

 

is anyone know a better way (with no coding is better ...) to have cascading drop down lists in sharepoint online like this : http://www.markrackley.net/2014/05/20/cascading-drop-down-lists-in-sharepoint-office-365-using-rest/

 

merci !

 

 

25 Replies

There is a way of doing this using Infopath and Sharepoint Designer, see link below -

https://blogs.msdn.microsoft.com/bharatgupta/2013/03/07/create-cascading-dropdown-in-browser-enabled...

Thanks for answering

 

Forms editing with infopath are not supported for all licence in sharepoint online ... so I havre to find a solution without this tool ...

No coding implies to find a third party solution...by the way, the approach described in the blog post is correct...of course, you can find different "coding" flavours to get the same result
It's possible to do it with InfoPath only. This you tube video shows how (albeit on an older version of SharePoint, so you have to "translate" to the current version.) https://www.youtube.com/watch?v=-HnLhXVQf-M I worked through it and got cascading drop downs to work in SharePoint Online with InfoPath

i guess if you do not want to use infopath due to license problems which is kind of strange as you can use web viewer and only need to create the form with another account.

 

but then you could look at a possible solution with powerapps & Flow.

 

Kr,

 

Paul

By the way, in general I would avoid the use of InfoPath...

Juan Carlos,

what would you use instead?

Coding at the client side...

This is one of the most frustrating things for us in SharePoint Online, too.  All of the people who ask for forms want this, and they can't do it themselves, even as power users.  It needs client-side code, and then the IT department gets involved in creation and maintenance of every form.  We are also avoiding InfoPath, and waiting for a better solution from Microsoft.

Agree on that, the other way around could be to use third party products that already cover this gap

Hello,

 

A easy way is following this blog post : http://spjsblog.com/2013/08/20/convert-text-fields-to-cascading-dropdowns-unlimited-number-of-levels...

You can download it from here: http://spjsfiles.com/SharePoint%20JavaScripts/CascadingDropdowns_v3/v3.525/spjs_casc_v3.525.zip

 

No need to create multiple lists, only one list and it's easy.

 

Sample:

<script language="javascript" src="/SiteAssets/JS/SPJS/SPJS-Casc_min.js" type="text/javascript"></script>
<script type="text/javascript">


$(document).ready(function() {
spjs.casc.init({
lookupList:"ListToLookAT",
lookupListFields:["Title","Title1"],
thisListFields:["Title","Title1"],
dropDownDefaultvalue:"select",
hideEmptyDropdowns:true,
autoselectSingleOption:true,
clearInvalidSelection:true,
debug:false
});

});
</script>​​​

 

Thanks,

Catalin.

Especially with a small IT staff. No way for a small team to keep up with requests and then maintain them, too.

Fast forward to 2018, the issue still persists as far as I know.

Have you given the new List PowerApps a try?

Should be something like this:

 

https://powerusers.microsoft.com/t5/General-Discussion/CASCADING-DROPDOWN-WITH-3-COLUMNS/td-p/80483

 

I am trying to make this process work for me in Sharepoint.

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.

 

 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-... from @Daniel Christian