Forum Discussion
Conditionally Hiding Columns in SharePoint
- Mar 24, 2023
Barking_Mad I just tried conditionally hiding multiple selection choice field and it worked for me.
Formula:
Item 1:
Item 2:
However if you are trying to hide any other column based on values selected in multiple selection choice column, Microsoft official documentation says it is not supported yet: Unsupported column types in conditional formulas
In this case, you will have to customize the list form using Power Apps.
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
Hi,
Sorry for the late reply, I've been away and only just had a look at this.
Well, that is a pleasant surprise. I can only presume I had the formula wrong in some way (maybe ' ' around true and false, as it seems to work fine. Also the documentation says:
Unsupported column types in conditional formula
While the formula supports many of the available column types, we do not currently support the following column types:
Person or Group with multiple selections
Choice with multiple selections
Time calculations in Date and Time column
Currency columns
Location columns
Calculated columns
Managed Metadata columns
Barking_Mad Yes, you can apply conditional formula on multiple selection choice columns.
But, you cannot read values from multiple selection choice columns in conditional 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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs