Show or Hide SharePoint Fields Based on a Multi-Select Choice Column
Question details
The user needs to show or hide a SharePoint form field when a multi-select choice column includes a particular selection.
- Product
- Microsoft SharePoint list forms
- Device & OS
- not provided
- Scenario
- A list form uses a choice column with multiple selections allowed to control the visibility of another field.
- Observed behavior
- A conditional formula that works for a single-choice field does not work when the controlling field allows multiple selections.
Open the controlling column's settings and confirm that multiple selections are allowed. To use the workaround, check that you have permission to customize the list form and access to Power Apps in your organization.
Control Field Visibility in a Power Apps Custom List Form
Use this workaround when another field must appear only if a multi-select choice column contains a specific option.
SharePoint column conditional formulas generally cannot evaluate multi-select choice values as a simple text string. Comparing the entire field with one choice does not test whether that choice is included.
In a Power Apps custom form, the choice control exposes its selections as a table. Use a membership check against those selected values to control the target data card's Visible property.
Open the SharePoint list and select Integrate > Power Apps > Customize forms. If the option is unavailable, ask your administrator to check your permissions and whether form customization is supported for the list.
In Power Apps Studio, expand the form in Tree view and select the combo box inside the controlling choice field's data card. Note its control name, such as DataCardValue5, and confirm that it allows multiple selections.
Select the data card for the field you want to show or hide. Choose Visible from the property selector and enter: "Choice 1" in DataCardValue5.SelectedItems.Value. Replace DataCardValue5 with your combo box's actual name and Choice 1 with the exact choice label. If necessary, unlock the card through the Advanced pane before editing its properties.
Select Preview in Power Apps Studio. Select Choice 1 by itself, select it alongside another option, and then remove it. Confirm that the target field appears whenever Choice 1 is selected and disappears when it is absent.
Select File > Save, then Publish to SharePoint. Return to the list and open a new or existing item to verify the published form's behavior.
Use WPS Office for Documents and Spreadsheets Alongside SharePoint
WPS Office does not fix SharePoint conditional formulas or replace Power Apps form customization. It is a free, lightweight, easy-to-use alternative for related document and spreadsheet work, with a familiar interface and Microsoft Office format compatibility that makes migration straightforward.
Frequently Asked Questions
Why does my formula work with a single-choice column but not a multi-select column?
A single-choice field has one selected value, while a multi-select field contains multiple values. A comparison such as =IF([$Choices]=='Choice 1','true','false') does not reliably test whether a multi-value field includes Choice 1. Use a Power Apps custom form to evaluate the selected values instead.
How do I check whether a particular choice is selected in Power Apps?
Select the target field's data card and set its Visible property to "Choice 1" in DataCardValue5.SelectedItems.Value. Replace DataCardValue5 with the controlling combo box's name and Choice 1 with the exact option text. This checks membership rather than comparing the whole selection table with a string.
Can I keep using a native SharePoint conditional formula if I disable multiple selections?
If users only need one selection, open List settings, select the choice column, and turn off Allow multiple selections. A single-choice field can then be used in a supported conditional visibility formula. Do not change the column merely as a workaround if your process requires multiple choices.
Does hiding a field remove its saved value?
No. Setting a Power Apps data card's Visible property to false only hides it. Existing values can remain stored, and required-column rules still apply. Test both new and existing items before publishing the form.
Where can I request native support for multi-select visibility formulas?
Use your organization's available SharePoint feedback option or Microsoft's current SharePoint feedback portal to request multi-select choice support in conditional visibility formulas. Include the choice column settings, the formula you tried, and the expected behavior.
