1

I have a SharePoint list with a choice field column; when a specific choice value is selected, a new section with new columns need to appear. Is this possible?

Please help!

enter image description here

2 Answers 2

0

In SharePoint online modern experience, you can use conditional formulas to show or hide columns in a list or library form based on other column values.

Example:

=if([$Category] == 'Product Management', 'true', 'false')

Where [$Category] is in format [$InternalNameOfColumn], which means you have to use the "internal name" of choice column in formula. You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?

Note: You have to add conditional formulas on individual columns in list form as you cannot write conditional formulas on sections in "body" layout.

Microsoft official documentation: Show or hide columns in a list or library form


Update from comments:

For advanced list form customizations, you have below two options:

  1. Customize a Microsoft Lists or SharePoint form by using Power Apps
  2. Use SPFx Form Customizer extension: check my answer given here for more information & links: SPFx Form Customizer extension
3
  • Thank you. I'm realizing my question may not have made sense. I was hoping that the column wouldn't be hidden. I'm hoping that if a value (in this case, Hot Topics) is selected from the Request Type, it would open a new section of columns to fill out. Is that doable?
    – user104988
    Oct 5, 2022 at 13:42
  • This is not possible using SharePoint out of the box capabilities, you have to customize the list forms using power apps for advanced customizations. Oct 5, 2022 at 13:45
  • Check updated answer for other available options for advance customizations in modern experience. Oct 5, 2022 at 13:54
0

Here're steps:

1.Click "+New" button -> Edit columns -> Choose the column you want to show -> Edit conditional formula.

enter image description here

enter image description here

2.Use this formula: =if([$choice] == 'test1', 'true', 'false')

Note: The column is represented by specifying the internal name of the field.

enter image description here

1
  • Detailed steps are already given in Microsoft official documentation link provided in my answer. Oct 5, 2022 at 10:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.