Forum Discussion
Create a drop-down column - SharePoint List
- May 25, 2023
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.
Świetnie, wydaje mi się, że to pomaga, ale niestety nie działa. mam 3 kategorie "Kategoria" ,,Liczba Pomaranczowa", "Liczba biała" w tabeli 'liczba pomaranczowa' formatowanie JSON wprowadziłem formułę =if([$Kategoria] == 'Sprzęt IT', 'true', 'false ') następnie po zaakceptowaniu pojawiła się następująca formuła (ekran)
ale jak klikam w nowy formularz i wybieram sprzęt IT z kategorii to żadna dodatkowa tabela "liczba pomaranczowa" się nie rozwija
SebastianSzyroki For which columns are you adding the formulas?
You have to apply formula on the fields which you want to show/hide conditionally and not on category drop down field. Also, make sure you are using correct internal names of columns in the formula.
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.
- SebastianSzyrokiMay 26, 2023Copper Contributor
great, works thank you ! 🙂