Cascading Drop Down Lists in SharePoint

%3CLINGO-SUB%20id%3D%22lingo-sub-9948%22%20slang%3D%22en-US%22%3ECascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-9948%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20anyone%20know%26nbsp%3Ba%20better%20way%20(with%20no%20coding%20is%20better%20...)%20to%20have%20cascading%20drop%20down%20lists%20in%20sharepoint%20online%20like%26nbsp%3Bthis%20%3A%26nbsp%3B%3CA%20href%3D%22http%3A%2F%2Fwww.markrackley.net%2F2014%2F05%2F20%2Fcascading-drop-down-lists-in-sharepoint-office-365-using-rest%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.markrackley.net%2F2014%2F05%2F20%2Fcascading-drop-down-lists-in-sharepoint-office-365-using-rest%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emerci%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-9948%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-335084%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-335084%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20a%20very%20old%20post%20so%20probably%20the%20OP%20has%20moved%20on%20to%20something%20else%2C%20but%20cascading%20dropdowns%20from%20SharePoint%20lists%20is%20very%20easy%20to%20do%20these%20days%20with%20PowerApps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-335020%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-335020%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20are%20a%20couple%20of%20suggestions%20on%20the%20SharePoint%20Uservoice%20site%20for%20cascading%20lookup%20lists.%20Unfortunately%20one%20of%20them%20has%2060%20votes%20and%20Microsoft%20don't%20generally%20look%20at%20ideas%20under%20100%20votes.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F329214-sites-and-collaboration%2Fsuggestions%2F7140453-i-hope-cascaded-lookup-column-and-chart-webpart-in%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F329214-sites-and-collaboration%2Fsuggestions%2F7140453-i-hope-cascaded-lookup-column-and-chart-webpart-in%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279244%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279244%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3382%22%20target%3D%22_blank%22%3E%40Damien%20NICOLAS%3C%2FA%3E%26nbsp%3B%20This%20is%20an%20older%20thread%2C%20but%20have%20you%20seen%20SPEasyForms%20yet%3F%20It's%20an%20open-source%20SharePoint%20solution%20that%20loads%20%3CSPAN%3EjQuery%20constructs%20to%20SharePoint%20forms%20in%20a%20WYSYWIG%20GUI.%20No%20coding%20required!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECascading%20drop-down%20list%20fields%20is%20just%20one%20option.%20You%20can%20also%20add%20form%20tabs%2C%20multiple%20columns%2C%20field%20level%20permissions%2C%20conditional%20hidden%2Fread-only%2Fedit%20field%20options%2C%20auto-fill%20from%20other%20lists%2C%20and%20more.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fchannel%2FUC5NPldqncglvAQY5gswtxGw%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EOverview%20and%20quick%20tutorials%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fspeasyforms.intellipointsol.com%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EDownload%20the%20WSP%20solution%20file%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-260448%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-260448%22%20slang%3D%22en-US%22%3E%3CP%3Ethat%20video%20is%20using%20sharepoint%202010...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175980%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175980%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20recommend%20using%20PowerApps%20to%20create%20a%20custom%20form%2C%26nbsp%3B%20here%20is%20an%20example%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community-Blog%2FCascading-dropdowns-for-single-line-of-text%2Fba-p%2F22927%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community-Blog%2FCascading-dropdowns-for-single-line-of-text%2Fba-p%2F22927%26nbsp%3B%3C%2FA%3E%20from%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7804%22%20target%3D%22_blank%22%3E%40Daniel%20Christian%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175953%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175953%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BWonder%20if%20you%20can%20help%20me%20with%20this%3C%2FP%3E%0A%3CP%3EI%20am%20trying%20to%20make%20this%26nbsp%3Bcascade%20look%20up%20work%20for%20me%20on%20Sharepoint%20Lists.%3C%2FP%3E%0A%3CP%3EI%20have%20a%20main%26nbsp%3B%20list%20called%26nbsp%3B%20registration.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20also%20have%203%20lists%20called%20Employee%2C%20Courses%20and%20Categories.%3C%2FP%3E%0A%3CP%3ECourse%20List%20has%20columns%3A%20Course%2C%20category%2C%20Course%20ID%2C%20Date%2C%20etc%3C%2FP%3E%0A%3CP%3ECategories%20List%20has%20one%20columns%2C%20category%3C%2FP%3E%0A%3CP%3EEmployees%20Field%20has%20Fields%20%3A%20Department%2C%20Employee%20ID%2C%20Employee%20Name%20etc%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20the%20Registration%20List%2C%20when%20I%26nbsp%3BSelect%20a%20category%2C%20In%20the%20drop%20down%20I%20only%20want%20to%26nbsp%3Bselect%20a%20course%2C%20on%20the%20courseID%20field%3C%2FP%3E%0A%3CP%3EWhen%20I%26nbsp%3BSelect%26nbsp%3B%26nbsp%3Ba%26nbsp%3B%20%26nbsp%3BDepartment%2C%26nbsp%3B%20from%20the%20Employee%20List%2C%20I%20only%20want%20to%20see%20Employees%20in%20that%20department%20in%20the%20Employee%20ID%20field%3C%2FP%3E%0A%3CP%3EWhen%20I%26nbsp%3BSelect%26nbsp%3Ba%20course%2C%20I%20only%20want%20to%26nbsp%3Bchoose%20dates%20for%20that%20course%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20seen%20the%20codes%20above%2C%20but%20I%20am%20having%20a%20hard%20time%20making%20it%20to%20work.%3C%2FP%3E%0A%3CP%3EAny%20help%20will%20be%20greatly%20appreciated.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175951%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175951%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20make%20this%20process%20work%20for%20me%20in%20Sharepoint.%3C%2FP%3E%0A%3CP%3EI%20have%20a%20main%26nbsp%3B%20list%20called%26nbsp%3B%20registration.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20also%20have%203%20lists%20called%20Employee%2C%20Courses%20and%20Categories.%3C%2FP%3E%0A%3CP%3ECourse%20List%20has%20columns%3A%20Course%2C%20category%2C%20Course%20ID%2C%20Date%2C%20etc%3C%2FP%3E%0A%3CP%3ECategories%20List%20has%20one%20columns%2C%20category%3C%2FP%3E%0A%3CP%3EEmployees%20Field%20has%20Fields%20%3A%20Department%2C%20Employee%20ID%2C%20Employee%20Name%20etc%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20the%20Registration%20List%2C%20when%20I%26nbsp%3BSelect%20a%20category%2C%20In%20the%20drop%20down%20I%20only%20want%20to%26nbsp%3Bselect%20a%20course%2C%20on%20the%20courseID%20field%3C%2FP%3E%0A%3CP%3EWhen%20I%26nbsp%3BSelect%26nbsp%3B%26nbsp%3Ba%26nbsp%3B%20%26nbsp%3BDepartment%2C%26nbsp%3B%20from%20the%20Employee%20List%2C%20I%20only%20want%20to%20see%20Employees%20in%20that%20department%20in%20the%20Employee%20ID%20field%3C%2FP%3E%0A%3CP%3EWhen%20I%26nbsp%3BSelect%26nbsp%3Ba%20course%2C%20I%20only%20want%20to%26nbsp%3Bchoose%20dates%20for%20that%20course%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20seen%20the%20codes%20above%2C%20but%20I%20am%20having%20a%20hard%20time%20making%20it%20to%20work.%3C%2FP%3E%0A%3CP%3EAny%20help%20will%20be%20greatly%20appreciated.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-174448%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-174448%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20given%20the%20new%20List%20PowerApps%20a%20try%3F%3C%2FP%3E%0A%3CP%3EShould%20be%20something%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FGeneral-Discussion%2FCASCADING-DROPDOWN-WITH-3-COLUMNS%2Ftd-p%2F80483%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FGeneral-Discussion%2FCASCADING-DROPDOWN-WITH-3-COLUMNS%2Ftd-p%2F80483%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-174203%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-174203%22%20slang%3D%22en-US%22%3EFast%20forward%20to%202018%2C%20the%20issue%20still%20persists%20as%20far%20as%20I%20know.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-12119%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-12119%22%20slang%3D%22en-US%22%3E%3CP%3EEspecially%20with%20a%20small%20IT%20staff.%20No%20way%20for%20a%20small%20team%20to%20keep%20up%20with%20requests%20and%20then%20maintain%20them%2C%20too.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-12115%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-12115%22%20slang%3D%22en-US%22%3E%3CP%3ESomeone%26nbsp%3Buse%20this%20app%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.kwizcom.com%2Fsharepoint-apps%2Fkwizcom-apps-foundation%2Foverview%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.kwizcom.com%2Fsharepoint-apps%2Fkwizcom-apps-foundation%2Foverview%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-12084%22%20slang%3D%22en-US%22%3ERE%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-12084%22%20slang%3D%22en-US%22%3EYou%20could%20always%20try%20this%20one%20-%26gt%3B%20%3CA%20href%3D%22http%3A%2F%2Fspservices.codeplex.com%2Fwikipage%3Ftitle%3D%2524%2528%2529.SPServices.SPCascadeDropdowns%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fspservices.codeplex.com%2Fwikipage%3Ftitle%3D%2524%2528%2529.SPServices.SPCascadeDropdowns%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-11464%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-11464%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20easy%20way%20is%26nbsp%3Bfollowing%20this%20blog%20post%26nbsp%3B%3A%20%3CA%20href%3D%22http%3A%2F%2Fspjsblog.com%2F2013%2F08%2F20%2Fconvert-text-fields-to-cascading-dropdowns-unlimited-number-of-levels%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fspjsblog.com%2F2013%2F08%2F20%2Fconvert-text-fields-to-cascading-dropdowns-unlimited-number-of-levels%2F%3C%2FA%3E%3C%2FP%3E%3CP%3EYou%20can%20download%20it%20from%20here%3A%20%3CA%20href%3D%22http%3A%2F%2Fspjsfiles.com%2FSharePoint%2520JavaScripts%2FCascadingDropdowns_v3%2Fv3.525%2Fspjs_casc_v3.525.zip%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fspjsfiles.com%2FSharePoint%2520JavaScripts%2FCascadingDropdowns_v3%2Fv3.525%2Fspjs_casc_v3.525.zip%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20need%20to%20create%20multiple%20lists%2C%20only%20one%20list%20and%20it's%20easy.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESample%3A%3C%2FP%3E%3CP%3E%3CSCRIPT%20language%3D%22%26quot%3Bjavascript%26quot%3B%22%20src%3D%22%26quot%3B%2FSiteAssets%2FJS%2FSPJS%2FSPJS-Casc_min.js%26quot%3B%22%20type%3D%22%26quot%3Btext%2Fjavascript%26quot%3B%22%3E%3C%2FSCRIPT%3E%3CBR%20%2F%3E%3CSCRIPT%20type%3D%22%26quot%3Btext%2Fjavascript%26quot%3B%22%3E%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3B%2FP%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3B%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BP%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3B%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3B%24(document).ready(function()%20%7B%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3Bspjs.casc.init(%7B%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3BlookupList%3A%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3BListToLookAT%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3B%2C%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3BlookupListFields%3A%5B%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3BTitle%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3B%2C%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3BTitle1%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3B%5D%2C%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3BthisListFields%3A%5B%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3BTitle%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3B%2C%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3BTitle1%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3B%5D%2C%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3BdropDownDefaultvalue%3A%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3Bselect%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bquot%3B%2C%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3BhideEmptyDropdowns%3Atrue%2C%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3BautoselectSingleOption%3Atrue%2C%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3BclearInvalidSelection%3Atrue%2C%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3Bdebug%3Afalse%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3B%7D)%3B%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3B%2FP%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3B%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BP%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3B%7D)%3B%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Blt%3BBR%20%2F%26amp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bamp%3Bgt%3B%3C%2FSCRIPT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ECatalin.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-11429%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-11429%22%20slang%3D%22en-US%22%3EAgree%20on%20that%2C%20the%20other%20way%20around%20could%20be%20to%20use%20third%20party%20products%20that%20already%20cover%20this%20gap%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-11417%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-11417%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20one%20of%20the%20most%20frustrating%20things%20for%20us%20in%20SharePoint%20Online%2C%20too.%26nbsp%3B%20All%20of%20the%20people%20who%20ask%20for%20forms%20want%20this%2C%20and%20they%20can't%20do%20it%20themselves%2C%20even%20as%20power%20users.%26nbsp%3B%20It%26nbsp%3Bneeds%20client-side%20code%2C%20and%20then%20the%20IT%20department%20gets%20involved%20in%20creation%20and%20maintenance%20of%20every%20form.%26nbsp%3B%20We%20are%20also%20avoiding%20InfoPath%2C%20and%20waiting%20for%20a%20better%20solution%20from%20Microsoft.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-10917%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-10917%22%20slang%3D%22en-US%22%3ECoding%20at%20the%20client%20side...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-10865%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-10865%22%20slang%3D%22en-US%22%3E%3CP%3EJuan%20Carlos%2C%3C%2FP%3E%3CP%3Ewhat%20would%20you%20use%20instead%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-10810%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-10810%22%20slang%3D%22en-US%22%3EBy%20the%20way%2C%20in%20general%20I%20would%20avoid%20the%20use%20of%20InfoPath...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-10632%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-10632%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20guess%20if%20you%20do%20not%20want%20to%20use%20infopath%20due%20to%20license%20problems%20which%20is%20kind%20of%20strange%20as%20you%20can%20use%20web%20viewer%20and%20only%20need%20to%20create%20the%20form%20with%20another%20account.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20then%20you%20could%20look%20at%20a%20possible%20solution%20with%20powerapps%20%26amp%3B%20Flow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKr%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-9997%22%20slang%3D%22en-US%22%3ERE%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-9997%22%20slang%3D%22en-US%22%3EIt's%20possible%20to%20do%20it%20with%20InfoPath%20only.%20This%20you%20tube%20video%20shows%20how%20(albeit%20on%20an%20older%20version%20of%20SharePoint%2C%20so%20you%20have%20to%20%22translate%22%20to%20the%20current%20version.)%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D-HnLhXVQf-M%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D-HnLhXVQf-M%3C%2FA%3E%20I%20worked%20through%20it%20and%20got%20cascading%20drop%20downs%20to%20work%20in%20SharePoint%20Online%20with%20InfoPath%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-9976%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-9976%22%20slang%3D%22en-US%22%3ENo%20coding%20implies%20to%20find%20a%20third%20party%20solution...by%20the%20way%2C%20the%20approach%20described%20in%20the%20blog%20post%20is%20correct...of%20course%2C%20you%20can%20find%20different%20%22coding%22%20flavours%20to%20get%20the%20same%20result%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-9975%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-9975%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20answering%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EForms%20editing%20with%20infopath%20are%20not%20supported%20for%20all%20licence%20in%20sharepoint%20online%20...%20so%20I%20havre%20to%20find%20a%20solution%20without%20this%20tool%20...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-9971%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-9971%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20a%20way%20of%20doing%20this%20using%20Infopath%20and%20Sharepoint%20Designer%2C%20see%20link%20below%20-%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fbharatgupta%2F2013%2F03%2F07%2Fcreate-cascading-dropdown-in-browser-enabled-infopath-form-using-infopath-2010%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fbharatgupta%2F2013%2F03%2F07%2Fcreate-cascading-dropdown-in-browser-enabled-infopath-form-using-infopath-2010%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2120034%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3382%22%20target%3D%22_blank%22%3E%40Damien%20NICOLAS%3C%2FA%3E%26nbsp%3B%2C%20I%20have%20a%20solution%20I%20have%20just%20applied%20to%20my%20SharePoint%20Online%20List%2C%20and%20I'm%20not%20a%20global%20admin%20and%20I'm%20not%20using%20complex%20code%20or%203rd%20party%20apps%20-%20I'm%20just%20using%20multiple%20fields.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESetup%3A%3C%2FP%3E%3CP%3E1.%20Create%20Level%201%20category%20list%20in%20a%20choice%20field%20-%20cat1.list%3C%2FP%3E%3CP%3E2.%20Create%20Level%202%20category%20lists%20in%20a%20choice%20field%20-%20cat2.lista%2C%20cat2.listb%20(essentially%20you%20are%20creating%20a%20field%20for%20each%20option%20in%20the%20Level%201%20list)%3C%2FP%3E%3CP%3E3.%20Create%20a%20resolver%20field.%20It%20is%20a%20calculated%20filed.%20This%20is%20where%20we%20actually%20resolve%20the%20selected%20category.%20The%20calculation%20would%20be%3A%26nbsp%3B%3DIF(%5Bcat1.list%5D%3D%22List%20A%22%2Ccat2.lista%2CIF(%5Bcat1.list%5D%3D%22List%20B%22%2Ccat2.listb%2C%5Bcat1.list%5D))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20for%20only%20two%20lists%20and%20essentially%20the%20resolver%20will%20return%20either%20the%20value%20selected%20in%20the%202nd%20list%2C%20or%20just%20the%20value%20in%20the%20first%20list%20if%20nothing%20is%20selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20the%20next%20part%20if%20fixing%20the%20form%20so%20it's%20not%20just%20filled%20with%20level%202%20category%20choice%20fields%20-%20this%20is%20not%20a%20problem%20in%20SharePoint%20Online%20using%20the%20Edit%20Columns%20feature%20of%20a%20List%20Form.%20You%20simply%20add%20a%20Conditional%20formula%20on%20the%20field%20so%20that%20it%20is%20true%20when%20the%20category%20is%20called.%20The%20formula%20would%20look%20like%20this%20for%20cat2.lista%3A%26nbsp%3B%3Dif(%5B%24cat1.list%5D%3D%3D'List%20A'%2C'true'%2C%20'false').%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20also%20have%20some%20PowerApps%2C%20you%20can%20essentially%20use%20the%20same%20trick%20using%20the%20visible%20filter%20-%20essentially%20you%20are%20limiting%20the%20visibility%20of%20the%202nd%20Category%20options%20to%20the%20one%20that%20matches%20the%20selected%20Category%201%20option.%20In%20reality%2C%20all%20options%20are%20there%2C%20but%20just%20not%20visible%20-%20the%20resolver%20sorts%20out%20any%20discrepancy%20if%20multiple%20have%20been%20selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wouldn't%20recommend%20this%20if%20you%20have%20a%20long%20list%20in%20your%20Category%201%20list%2C%20as%20you're%20going%20to%20have%20some%20long%20formulas%20and%20lost%20of%20choice%20fields%20to%20sort%20out.%20However%2C%20I'm%20using%204%20top-level%20choices%20and%20I%20could%20probably%20keep%20going%20until%20about%2010%20before%20it%20became%20a%20real%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%2C%3C%2FP%3E%3CP%3EDavid%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2589349%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20Drop%20Down%20Lists%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2589349%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F961980%22%20target%3D%22_blank%22%3E%40dcookau%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%20I%20am%20trying%20to%20apply%20your%20suggestion%20in%20my%20case.%20Do%20I%20need%20to%20create%20two%20separate%20Lists%20for%20Level%201%20and%20Level%202%20category.%26nbsp%3B%20My%20cascade%20drop%20down%20is%3C%2FP%3E%3CP%3ELevel%201%20%3D%20North%20America%2C%20South%20America%2C%20Asia.%3C%2FP%3E%3CP%3ELevel%202%20%3D%20Canada.%20USA%2C%20Nicaragua%2C%20Paraguay%2C%20India%2C%20Japan%3C%2FP%3E%3CP%3EIf%20Level%201%20%3D%20North%20America%2C%20Level%202%20will%20only%20show%20options%20Canada%20and%20USA%3C%2FP%3E%3CP%3Eif%20Level%26nbsp%3B%201%3D%20Asia%2C%20Level%202%20will%20only%20show%20options%20India%20and%20Japan.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20use%20your%20solution%20(%3DIF(%5BLevel%201%5D%3D%22North%20America%2C%20Level%202%20....)%3F%20Your%20help%20will%20be%20much%20appreciated.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3EThomas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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