Permission & Access Issues

How to Hide or Disable SharePoint Online Fields by Permission Level

Olivia Miller Sep 30, 2026 869 views

Question details

Users need a method to conditionally hide or disable specific fields in SharePoint Online lists based on a user's permission level or group membership.

How to Hide or Disable SharePoint Online Fields by Permission Level

Product: SharePoint Online
Device & OS: not provided
Scenario: Customizing SharePoint list forms to control data visibility and restrict editing capabilities for certain users or groups.
Observed behavior: Currently, SharePoint list forms display all fields by default, and users are looking for a configuration or customization approach to dynamically enforce read-only or hidden states per user group.

Before you start

Verify your SharePoint permissions. You must have Site Owner or Full Control access to customize list forms using Power Apps or apply JSON conditional formatting.

Solution 1Recommended

Customize the SharePoint Form with Power Apps

Using Power Apps is the most robust method for checking user groups and conditionally modifying the DisplayMode or Visible properties of a SharePoint field.

By integrating Power Apps with your SharePoint list, you can write specific formulas to verify if the current user belongs to a designated SharePoint or Microsoft 365 group. This allows you to dynamically toggle fields between Edit, View (read-only), or Hidden states.

Open Power Apps Integration

Navigate to your SharePoint list. Click on 'Integrate' in the top command bar, select 'Power Apps', and then click 'Customize forms'.

Select the Target DataCard

Once the Power Apps studio loads, select the DataCard corresponding to the field you want to hide or disable from the Tree View.

Unlock DataCard Properties

In the properties pane on the right, go to the 'Advanced' tab and click 'Unlock to change properties'.

Apply Permission Logic

Select the 'DisplayMode' (to disable/make read-only) or 'Visible' property. Enter a formula checking the user, such as: If(User().Email in ["admin@domain.com"], DisplayMode.Edit, DisplayMode.View).

Save and Publish

Click 'File', then 'Save', and finally select 'Publish to SharePoint'. Return to your list to test the form.

Customize the SharePoint Form with Power Apps

Security Consideration: Hiding fields in the UI using Power Apps does not secure the underlying data at the database level. Users with access to the list may still view the data via list views or API calls unless item-level permissions are applied.

Solution 2

Use SharePoint Conditional Formatting

For simpler scenarios that don't require checking user emails directly, you can use built-in conditional formulas to hide fields based on other column values.

Free Microsoft Office alternative

Discover WPS Office: A Powerful Free Microsoft Office Alternative

While SharePoint handles your team's online list permissions, you need a reliable suite to manage the actual documents stored there. WPS Office is a lightweight, free alternative to Microsoft Office offering familiar interfaces, powerful editing capabilities, and seamless document migration without the hefty subscription fees.

1. Download the Software: Visit the official WPS Office website and click the free download button for your operating system.
2. Install WPS Office: Run the lightweight installer and follow the simple on-screen instructions to set up the suite.
3. Open SharePoint Files: Download your documents from SharePoint and open them in WPS Office for seamless, compatible editing.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx) commonly stored in SharePoint.Lightweight application that launches quickly and consumes minimal system resources.Familiar user interface ensuring zero learning curve for users switching from Microsoft Office.Built-in PDF editing tools for comprehensive document management workflows.

microsoft office alternative - wps office

Frequently Asked Questions

Does hiding a field in the SharePoint form restrict access to the data?

No. Hiding a field using Power Apps or conditional formatting only removes it from the form interface. Users with list access can still see the data by modifying the list view, exporting to Excel, or using SharePoint APIs.

Can I hide columns in SharePoint based on a Microsoft 365 Group without Power Apps?

Currently, native SharePoint out-of-the-box form formatting does not support user or group-based conditions. You must use Power Apps to query Office 365 Groups or user profiles to achieve group-based field visibility.

How do I make a field completely read-only for everyone?

You can make a field read-only by customizing the form in Power Apps, selecting the specific DataCard, and permanently setting its 'DisplayMode' property to 'DisplayMode.View'.

Document & File Issues