Permission & Access Issues

How to Share a Microsoft Lists Form Without Exposing Fields

Maira Mehtab Oct 9, 2026 869 views

Question details

The user needs to share a Microsoft Lists form but wants to hide specific fields from end-users while retaining visibility and edit access for the list administrator.

How to Create and Share a Microsoft Lists Form Without Exposing Fields

Product: Microsoft Lists
Device & OS: not provided
Scenario: Sharing a data-entry form with users while keeping specific admin-only fields hidden and protected from unauthorized edits.
Observed behavior: By default, all fields are visible, and simply removing them from the list completely removes them for administrators as well. Furthermore, users might still bypass form restrictions using the grid view.

Before you start

Ensure you have Owner or Full Control permissions for the Microsoft List so you can modify form layouts and advanced list settings.

Solution 1Recommended

Hide Columns in Form Settings and Disable Grid Editing

Use the built-in list form editor to hide specific columns and turn off grid editing to prevent users from bypassing the form restrictions.

Share the Form

Open your Microsoft List and use the built-in 'Copy link' feature to generate a sharing link for the form.

Edit Form Columns

Click the arrow next to 'Edit form' at the top of the list, then select 'Edit columns'.

Hide Sensitive Fields

In the side panel, clear the checkboxes for the columns that users should not be able to see or edit, then click 'Save'.

Access List Settings

Click the gear icon (Settings) in the top right corner and select 'List settings', then click on 'Advanced settings'.

Disable Grid View Editing

Scroll down to the 'Quick property editing' section and set it to 'No'. This prevents users from using the 'Edit in grid view' mode to modify hidden fields.

Hide Columns in Form Settings and Disable Grid Editing

Solution 2

Use a Conditional Formula with a Trigger Password

Apply a conditional formula to specific fields so they remain hidden until a specific 'password' or trigger value is entered by the admin.

Free Microsoft Office alternative

Manage Your Data Securely with WPS Office

If you are looking for a straightforward, lightweight, and free way to manage tabular data and forms without wrestling with complex SharePoint or Microsoft Lists permissions, WPS Office is an excellent alternative. It offers robust spreadsheet protection features and seamless compatibility with Microsoft Office formats.

1. Download WPS Office: Visit the official WPS Office website and download the free suite for your device.
2. Open Your Data File: Launch WPS Spreadsheet and easily open your existing .xlsx or .csv data files.
3. Protect Sensitive Data: Navigate to the 'Review' tab and use the 'Protect Sheet' feature to lock specific cells or hide formulas from other users.

100% compatibility with Microsoft Excel (.xlsx) and CSV formats.Easy-to-use worksheet protection and cell locking to hide sensitive data from unauthorized users.Free, lightweight office suite including Writer, Presentation, and Spreadsheet.Familiar user interface requiring zero learning curve for users migrating from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Can I hide fields in Microsoft Lists based on a user's role or permissions?

Out of the box, the standard Microsoft Lists form does not support field-level security based on user roles. To achieve role-based field visibility, you need to use Power Apps to create a customized form where you can define visibility logic based on user groups.

Why can users still see and edit hidden fields in grid view?

Hiding a column in the list form settings only applies to the form itself. It does not automatically remove the column from the 'Edit in grid view' (Quick Edit) mode. You must navigate to List Settings > Advanced settings and set 'Quick property editing' to 'No' to fully restrict users from accessing those fields.

What column types are not supported by conditional formulas in Microsoft Lists?

Conditional formulas cannot be used with Person or Group columns (with multiple selections), Choice columns (with multiple selections), Time calculations, Currency, Location, Calculated, or Managed Metadata columns.

Document & File Issues