Forum Discussion
Solved
Create a drop-down column - SharePoint List
Is it possible to create an expandable column? What I mean is that for example I create a column "Category" in which I have two categories "IT Equipment" and "Training" (drop down list). After select...
SebastianSzyroki If you want to show/hide columns based on selection of option from choice column, you can use conditional formulas in SharePoint.
Let's say you created 3 columns: Category (choice column), TypeOfEquipment (Text), NameOfTraining (Text).
Then you can conditionally hide TypeOfEquipment and NameOfTraining fields from list form based on value of Category column.
Check this documentation: Specify conditional formula to show or hide columns
Example, for TypeOfEquipment column, you can use formula like:
=if([$Category] == 'IT Equipment', 'true', 'false')Where Category is the internal name of your SharePoint choice column.
OR If you want TypeOfEquipment and NameOfTraining also of type choice columns, you can use Power Apps to customize list form and create cascading drop downs:
- Working with Cascading Lists in SharePoint and Power Apps
- Create dependent drop-down lists in a canvas app
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
SebastianSzyroki If you want to show/hide columns based on selection of option from choice column, you can use conditional formulas in SharePoint.
Let's say you created 3 columns: Category (choice column), TypeOfEquipment (Text), NameOfTraining (Text).
Then you can conditionally hide TypeOfEquipment and NameOfTraining fields from list form based on value of Category column.
Check this documentation: Specify conditional formula to show or hide columns
Example, for TypeOfEquipment column, you can use formula like:
=if([$Category] == 'IT Equipment', 'true', 'false')
Where Category is the internal name of your SharePoint choice column.
OR If you want TypeOfEquipment and NameOfTraining also of type choice columns, you can use Power Apps to customize list form and create cascading drop downs:
- Working with Cascading Lists in SharePoint and Power Apps
- Create dependent drop-down lists in a canvas app
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
and can i make a drop down list where i select several options and there are several fields to fill in? In this case, I can't have multiple selections in the Category column, I can only have one selection, then the note column appears conditionally.
if I select two options from the category list, e.g. IT equipment and training, then two additional columns for entering text will appear. Now it's like I can choose only one of these two options and then a new table appears
SebastianSzyroki Unfortunately, SharePoint conditional formulas does not support Choice columns with multiple selections, check: Unsupported column types in conditional formulas
For this requirement, you have to completely customize the SharePoint list form using Power Apps.
Please consider giving a Like if my post helped you in any way.