SharePoint Document Issues

How to Make a SharePoint List Column Read-Only After Item Creation

Amos Gikunda Oct 9, 2026 868 views

Question details

The user wants to lock a SharePoint list column or make it read-only after an item has been created, specifically depending on the values in another column.

How to Make a SharePoint List Column Read-Only After Item Creation

Product: SharePoint Online / Power Apps
Device & OS: not provided
Scenario: Managing list data entry rules where certain fields should not be modified once the initial entry is completed or when specific criteria are met.
Observed behavior: SharePoint Online native list settings lack a built-in rule to conditionally disable column editing after item creation.

Before you start

Ensure you have Site Owner or Design permissions on the SharePoint list and an active Microsoft Power Apps license to customize the list forms.

Solution 1Recommended

Customize the SharePoint Form using Power Apps

Use Power Apps to modify the list form's interface and set conditional DisplayMode rules that prevent users from editing the column after creation.

Since SharePoint does not offer column-level security natively, customizing the entry form using Power Apps is the most effective approach. You can write a logic formula to lock the field based on whether the item is newly created or already exists.

Open Power Apps Integration

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

Select the Target Data Card

Once the Power Apps studio loads, look at the Tree view on the left, expand 'SharePointForm1', and select the specific Data Card for the column you want to make read-only.

Unlock the Data Card Properties

In the right-hand Properties pane, go to the 'Advanced' tab and click 'Unlock to change properties' so you can modify its behavior.

Modify the DisplayMode Property

Select the 'DisplayMode' property of the input control inside the data card. Change the formula in the top bar to: If(SharePointForm1.Mode = FormMode.Edit, DisplayMode.View, DisplayMode.Edit). This makes it read-only when editing an existing item, but editable when creating a new one.

Save and Publish

Click 'File' > 'Save', then select 'Publish to SharePoint'. Close Power Apps and refresh your SharePoint list to test the form.

Customize the SharePoint Form using Power Apps

Conditional Locking: You can also lock the column based on another column's value. For example: If(DataCardValueX.Text = "Approved", DisplayMode.View, DisplayMode.Edit).

Solution 2

Disable Quick Edit to Prevent Workarounds

Prevent users from bypassing the customized Power Apps form by disabling the grid view editing mode in your SharePoint list.

Free Microsoft Office alternative

Need a Simpler Way to Manage Team Data?

If navigating complex SharePoint configurations and Power Apps formulas is slowing you down, WPS Office provides a streamlined, lightweight alternative. Use WPS Spreadsheet to easily track data, manage lists, and apply built-in data validation rules without writing code.

1. Download the Software: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install WPS Office: Run the setup file and follow the quick installation prompts to launch the suite.
3. Manage Data Easily: Open WPS Spreadsheet to track tasks, apply robust data validation rules to restrict cell editing, and share the workbook securely with colleagues.

Completely free to use with a fast, lightweight installation processSeamless compatibility with Microsoft Excel (.xlsx), Word, and PowerPoint formatsIntuitive spreadsheet interface for effortless data tracking and list managementBuilt-in cloud syncing and sharing tools for simple team collaboration

microsoft office alternative - wps office

Frequently Asked Questions

Can I make a SharePoint column read-only without using Power Apps?

No, SharePoint Online does not provide out-of-the-box list settings to apply column-level security or conditional read-only status based on item creation. Power Apps is the recommended Microsoft solution for modifying form behavior.

Will making a column read-only in Power Apps affect site administrators?

Yes, standard DisplayMode rules in Power Apps apply to anyone using the form. To allow administrators to edit, you would need to write a more complex Power Apps formula that checks the current user's role or Microsoft 365 group membership.

Is it possible to automate column updates instead of making them read-only?

Yes, you can use Power Automate to create a cloud flow that checks if an unauthorized user modified a specific column. The flow can automatically revert the change to its previous value and send an email alert to the list owner.

Document & File Issues