Others

How to Show or Hide Microsoft Lists Columns Dynamically

Camila Milosovich Oct 10, 2026 869 views

Question details

The user wants to dynamically display or hide specific columns in Microsoft Lists based on the selection made in another column.

How to Show or Hide Microsoft Lists Columns Dynamically

Product: Microsoft Lists and SharePoint
Device & OS: not provided
Scenario: Creating conditional data entry forms where certain fields only appear when specific criteria are met in other fields.
Observed behavior: Standard column formulas do not support dynamically hiding or showing columns in the form; conditional interface behavior requires deeper customization.

Before you start

Ensure you have the necessary edit permissions for the Microsoft List and access to customize SharePoint forms using Microsoft Power Apps.

Solution 1Recommended

Customize the List Form Using Power Apps

Use Power Apps to modify the form's interface and set conditional visibility properties for specific data cards.

Microsoft Lists and SharePoint do not provide a built-in formula option to dynamically control column visibility on default forms. To achieve conditional formatting where a column hides or shows based on another column's value, you must customize the list entry form with Power Apps.

Open Power Apps integration

Navigate to your Microsoft List. On the top command bar, click on 'Integrate', hover over 'Power Apps', and select 'Customize forms'.

Select the target data card

Once Power Apps Studio opens, select the specific Data Card (representing the column) that you want to dynamically show or hide from the Tree View on the left.

Modify the Visible property

Go to the 'Advanced' properties pane on the right side, unlock the properties if necessary, and locate the 'Visible' property.

Enter the conditional formula

Replace the default 'true' value with a conditional formula. For example: If(DataCardValueX.Selected.Value = "TargetValue", true, false), adjusting the DataCardValue name and "TargetValue" to match your specific trigger column.

Save and Publish

Click 'File', then 'Save', and finally click 'Publish to SharePoint' to apply the customized conditional form to your Microsoft List.

Customize the List Form Using Power Apps

Form vs. List View: This method changes the form interface for data entry but does not dynamically remove columns from standard tabular list views. List views will still display the column headers.

Free Microsoft Office alternative

Try WPS Office for Efficient Everyday Data Management

While complex conditional forms require Microsoft SharePoint and Power Apps, everyday data management, spreadsheet analysis, and document editing can be done efficiently with WPS Office. It is a lightweight, fully compatible, and free alternative to Microsoft Office.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) file formats.Lightweight software package with a fast, user-friendly, and familiar interface.Built-in PDF editing and conversion capabilities at no extra cost.Free to download and ideal for personal or business spreadsheet management without complex setup.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use JSON formatting to hide a column dynamically in a Microsoft List view?

Yes, you can use JSON view formatting to conditionally hide or show a column in the tabular list view by applying a formula to the 'display' CSS property based on another column's value. However, JSON formatting does not affect the actual data entry form.

Why doesn't standard SharePoint column validation hide fields?

Column validation in SharePoint is designed strictly to ensure data integrity by restricting what values can be saved to the database. It cannot be used to modify the user interface or control the visibility of fields on the form.

Do I need a premium license to use Power Apps for SharePoint forms?

No, customizing standard SharePoint list forms with Power Apps is included in most standard Microsoft 365 business and enterprise plans. It does not require a premium standalone Power Apps license, provided you are only using standard SharePoint connectors.

Office Quick Solutions