Sharepoint modern List choice column with dynamic values

%3CLINGO-SUB%20id%3D%22lingo-sub-1681985%22%20slang%3D%22en-US%22%3ESharepoint%20modern%20List%20choice%20column%20with%20dynamic%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1681985%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20add%20a%20column%20(of%20type%20choice%2Fdrop%20down)%20to%20an%20existing%26nbsp%3B%20sharepoint%20online%20modern%20list.%3C%2FP%3E%3CP%3Ethe%20choice%20option%20i%20want%20to%20provide%20depends%20on%20an%20other%20column%20eg.%20if%20column%20A%20has%20department%20sales%20then%20column%20B%20should%20have%203%20choice%20options%20%2C%20if%26nbsp%3B%26nbsp%3Bcolumn%20B%20has%20department%20finance%20then%20column%20B%20should%20have%204%20different%20options%20to%20select.%20how%20can%20i%20achieve%20this%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want to add a column (of type choice/drop down) to an existing  sharepoint online modern list.

the choice option i want to provide depends on an other column eg. if column A has department sales then column B should have 3 choice options , if  column B has department finance then column B should have 4 different options to select. how can i achieve this ?

1 Reply
Sounds like you are looking for "Cascading Columns".

The only way to achieve this currently is by customizing your forms in PowerApps. Here is a tutorial on how to achieve this.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/dependent-drop-down-lists