Forum Discussion
swati8826
Sep 18, 2020Copper Contributor
Sharepoint modern List choice column with dynamic values
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 ?
- MJShelly2006Copper Contributor
Hello, what if after creating the initial dropdown dependency that writes back to a SharePoint site you have to totally update the list to a new or revised list. I think per a test I made that changes to update the cascading dependent dropdown list that it then affects the existing SharePoint's entries on that same field. - How does one update or replace a field with such dependencies and have it NOT mess up the historical information in the Sharepoint field? -- I see nothing in Microsoft about how to handle these edits (as things change over time). e.g. one of my fields changes each new fiscal year so what was a choice one year is not the same as the next.
- SharonFryBrass ContributorStumbled 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-and-powerapps
- 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