SOLVED

Filter a multi-select drop down column based on a choice column

%3CLINGO-SUB%20id%3D%22lingo-sub-146355%22%20slang%3D%22en-US%22%3EFilter%20a%20multi-select%20drop%20down%20column%20based%20on%20a%20choice%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-146355%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20building%20a%20new%20SharePoint%20list%20(we%20use%20SharePoint%20online)%20and%20in%20that%20list%20I%20have%20a%20lookup%20to%20Department.%26nbsp%3B%20This%20also%20captures%20the%20department%20ID%20number.%26nbsp%3B%20The%20next%20field%20I%20have%20is%20Positions.%26nbsp%3B%20I%20also%20have%20a%20DepartmentalPositions%20list%20(separately)%20that%20I%20want%20to%20use%20as%20a%20%22linking%22%20table%20that%20contains%20the%20DepartmentNumber%20and%20PositionID.%26nbsp%3B%20Ultimately%20what%20I%20want%20is%20when%20the%20department%20is%20selected%20to%20only%20display%20the%20positions%20that%20are%20linked%20to%20that%20department.%26nbsp%3B%20How%20would%20I%20go%20about%20doing%20this%3F%26nbsp%3B%20Eventually%20this%20list%20is%20also%20going%20to%20be%20part%20of%20a%20Power%20App.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20and%20if%20I%20am%20posting%20to%20the%20wrong%20community%2C%20please%20let%20me%20know%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-146355%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-263683%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20a%20multi-select%20drop%20down%20column%20based%20on%20a%20choice%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-263683%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Brad%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20something%20similar.%26nbsp%3BCan%20you%20share%20your%26nbsp%3Bsolution%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ETK%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147131%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20a%20multi-select%20drop%20down%20column%20based%20on%20a%20choice%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147131%22%20slang%3D%22en-US%22%3EEy%20Bradley%2C%20glad%20you%20were%20able%20to%20sorted%20out!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147122%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20a%20multi-select%20drop%20down%20column%20based%20on%20a%20choice%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147122%22%20slang%3D%22en-US%22%3E%3CP%3EJuan%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20for%20the%20response.%26nbsp%3B%20I%20was%20able%20to%20do%20it%20by%20manipulating%20power%20apps%20and%20the%20use%20of%20some%20variables%20to%20store%20the%20IDs%20of%20the%20items.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBrad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-147044%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20a%20multi-select%20drop%20down%20column%20based%20on%20a%20choice%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-147044%22%20slang%3D%22en-US%22%3EThe%20answer%20here%20is%3A%20it%20depends...if%20you%20are%20working%20with%20classic%20UI%2C%20you%20can%20achieve%20this%20by%20means%20of%20JSLINK%20or%20JS%20injected%20in%20the%20new%20%2F%20edit%20form.%20If%20you%20are%20working%20with%20the%20modern%20UI%2C%20you%20have%20two%20options%20here%3A%3CBR%20%2F%3E(1)%20SPFx%20Extensions%3CBR%20%2F%3E(2)%20PowerApps%3C%2FLINGO-BODY%3E
Contributor

I am building a new SharePoint list (we use SharePoint online) and in that list I have a lookup to Department.  This also captures the department ID number.  The next field I have is Positions.  I also have a DepartmentalPositions list (separately) that I want to use as a "linking" table that contains the DepartmentNumber and PositionID.  Ultimately what I want is when the department is selected to only display the positions that are linked to that department.  How would I go about doing this?  Eventually this list is also going to be part of a Power App.

 

Thanks and if I am posting to the wrong community, please let me know

4 Replies
best response confirmed by Bradley Allison (Contributor)
Solution
The answer here is: it depends...if you are working with classic UI, you can achieve this by means of JSLINK or JS injected in the new / edit form. If you are working with the modern UI, you have two options here:
(1) SPFx Extensions
(2) PowerApps

Juan,

 

Thanks for the response.  I was able to do it by manipulating power apps and the use of some variables to store the IDs of the items.

 

Brad

Ey Bradley, glad you were able to sorted out!

Hi Brad,

 

I need to something similar. Can you share your solution?

 

Thanks,

TK