'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Create Dependent Choice Columns in Microsoft Lists
Question details
The user wants to create dependent or cascading choice columns in Microsoft Lists or SharePoint Online.
- Product
- Microsoft Lists and SharePoint Online
- Device & OS
- not provided
- Scenario
- Customizing a list form so that the available choices in one column dynamically update based on the selection made in a previous column.
- Observed behavior
- Microsoft Lists and SharePoint Online do not support dependent choice columns out of the box, requiring advanced customization to achieve cascading choices.
Ensure you have the appropriate list owner or site member permissions to customize forms in your Microsoft Lists or SharePoint environment. You will also need access to Microsoft Power Apps to build the cascading dropdown logic.
Use Microsoft Power Apps to Create Cascading Choices
Since Microsoft Lists does not support native dependent columns, using Power Apps to customize your list form is the recommended workaround.
Power Apps allows you to replace the default SharePoint or Microsoft Lists form with a customized app. Within this app, you can apply filtering functions to define specific data validation and cascading logic for your choice columns.
Navigate to your Microsoft List or SharePoint list. Click on 'Integrate' in the top menu bar, hover over 'Power Apps', and select 'Customize forms'.
Once Power Apps Studio opens, select the data card for your dependent choice column. Change the 'Items' property in the formula bar to filter based on the selection of the primary dropdown (e.g., using the Filter() function).
After testing the cascading logic in the preview mode, click 'File', select 'Save', and then click 'Publish to SharePoint' to make the customized form available to all users.
Submit Feedback via the SharePoint Feedback Portal
If customizing with Power Apps is not a feasible option for your organization, you can submit a feature request directly to Microsoft.
Use WPS Spreadsheet for Native Cascading Dropdowns
If you are managing lists and data that require dependent drop-down menus without the complexity of Power Apps configurations, WPS Spreadsheet offers native Data Validation features to easily create cascading choices. It is a powerful, free, and lightweight alternative to Microsoft Office.
Frequently Asked Questions
Why can't I create dependent columns natively in SharePoint Online?
SharePoint Online and Microsoft Lists currently do not support dependent or cascading choice columns as a default, out-of-the-box feature. Complex form-level logic must be handled by external form builders like Power Apps.
Can I use JSON column formatting to create cascading drop-downs?
No. While JSON column formatting is highly effective for changing the visual appearance of columns and rows based on conditions, it cannot dynamically alter the available input choices of one column based on the value of another.
Will customizing my list form with Power Apps affect other list users?
Yes. Once you successfully publish a customized Power Apps form to your list, it replaces the default list form. All users with permission to add or edit items will see and interact with the new cascading logic you created.
