Sharepoint modern List choice column with dynamic values

[swati8826]

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 ?

[#2]

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

[#3]

Stumbled upon this conversation while searching for something else and also this link: https://learn.microsoft.com/en-us/microsoft-365/community/working-with-cascading-lists-in-sharepoint...