Forum Discussion
Column Visibility based on previous multi-choice column
I have a SP List with a column "Color" that is a choice type that allows multiple choices (Red, Green, Yellow). What I need is for a Number Red, Number Green, and Number Yellow column to be triggered as "Visible" if the user select any combination of Red Green or Yellow. EG
If user selects Red, the Number Red column becomes visible. If the user selects Red and Green, both the Number Red and the Number Green becomes visible in the data entry "form".
=if([$Color] == 'Red, 'true', 'false') works when "Allow Multiple Choices" is false, but when I change it to "allowed", it stops working and the Number Red column is not visible in any scenario.
Google suggest that a conditional formula controlling column visibility does not work because the column value is no longer a simple string, which makes sense, but Google also suggests that a Flow is the way to go here. I am not a programmer, just the poor junior analyst that got assigned making this form. Are there any examples of how to make this work with a flow at the ELI5 level?
bigfoot360 You are right about choice column with multiple selections is not supported in SharePoint list form conditional formulas:
Microsoft Documentation: Show or hide columns in a SharePoint list or library form
So, you will have to achieve your requirements using Power Apps (not Power Automate flow). You have to customize the list forms using Power Apps and show/hide number controls based on the choice column selection. Check below links for more information:
- Customize a Microsoft Lists or SharePoint form by using Power Apps
- Hide /Show field depending on Multiple selections done in drop down menu
- Hide/Show Field based on Combobox Multiple Selections
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.
