Workaround for IF Logic on Multi-Select Columns in Microsoft Lists
Question details
The user needs a way to apply conditional IF logic to multi-select Choice columns in Microsoft Lists.

- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Setting up conditional formatting or validation rules based on user selections in a multi-select field.
- Observed behavior
- Microsoft Lists natively blocks direct conditional formulas on multi-select Choice, Person or Group, Calculated, Currency, Location, and Managed Metadata columns.
Ensure you have adequate permissions to customize forms in your SharePoint environment or Microsoft Lists. You will also need access to Microsoft Power Apps to implement this workaround.
Customize the List Form Using Power Apps
Since native IF formulas aren't supported on multi-select columns, use Power Apps to enforce conditional visibility and validation rules dynamically.
Power Apps provides a robust environment to override default list form behaviors. By modifying the Visible or Required properties of your form fields using Power Fx formulas, you can check the contents of a multi-select Choice column and trigger actions accordingly.
Open your Microsoft List in the browser. From the top menu bar, click on 'Integrate', select 'Power Apps', and then choose 'Customize forms'.
Once the Power Apps Studio loads, select the specific data card or field you want to hide, show, or make required based on the multi-select column.
In the right-hand properties pane, click on the 'Visible' or 'Required' property. Enter a Power Fx formula to evaluate the multi-select column (e.g., using the 'in' operator to check for specific selected values).
Click 'File' > 'Save' to save your changes, then click 'Publish to SharePoint' so the customized form becomes active in your Microsoft List.

Looking for a Free and Powerful Office Suite?
While Microsoft Lists handles complex list management, for your everyday document, spreadsheet, and presentation needs, WPS Office offers a lightweight, highly compatible, and completely free alternative to Microsoft Office.
- 1. Download the installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install WPS Office: Run the installation wizard to set up the software on your device in just a few minutes.
- 3. Open your files: Launch WPS Office and directly open your existing Microsoft Office files to continue working seamlessly.

Frequently Asked Questions
Why doesn't my IF formula work on a multi-select Choice column in Microsoft Lists?
Microsoft Lists natively restricts conditional formulas on several complex column types, including multi-select Choice, Person or Group, and Managed Metadata columns, because these columns return arrays rather than simple text values.
Can I use calculated columns as a workaround for multi-select choice validation?
No, Microsoft Lists does not support conditional formulas directly on Calculated columns either. You must use Power Apps customized forms to handle dynamic visibility or validation for these fields.
Do I need a special license to customize list forms with Power Apps?
Basic form customization using Power Apps is generally included with most enterprise Microsoft 365 plans that feature SharePoint and Microsoft Lists. Check your specific Microsoft 365 subscription for Power Apps capabilities.




