Fix Microsoft Lists Rich Text Column Requires Access Request Issue
Question details
Users are prompted with an access request when trying to interact with a multiple-lines-of-text column formatted as rich text, even though they have access to the rest of the list item.
- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- A user selects or attempts to edit a rich text column within a Microsoft List item and gets an unexpected access request denial.
- Observed behavior
- An access request prompt appears specifically for the rich-text column, preventing users from viewing or modifying it, while other cells in the same list item remain fully accessible.
Ensure you have Site Owner or Full Control permissions on the Microsoft List so you can accurately check and modify item-level access rights.
Check and Reset Item-Level Permissions
Verify the affected user's access rights using the Advanced permissions settings to rule out unique permission conflicts.
Sometimes individual list items develop unique permissions that break inheritance from the main list. Resetting these permissions can restore normal access to all columns, including rich text fields.
Select the problematic list item and open the Details pane on the right side of the screen.
Click on 'Manage access' and scroll down to select 'Advanced' at the bottom of the pane.
In the Advanced permissions page, click on 'Check Permissions' in the ribbon. Enter the affected user's name to verify their current access level.
If the item has unique permissions, click 'Delete unique permissions' to force the item to inherit access rights from the parent list, then test the rich text column again.
Isolate the Issue and Contact Microsoft Support
Determine if the glitch is isolated to a specific list or tenant-wide, as persistent rich text access errors often require backend support.
Manage Your Data Smoothly with WPS Office
Dealing with permission glitches in Microsoft Lists can slow down your workflow. For straightforward data tracking and robust spreadsheet management, WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office. Enjoy familiar interfaces and offline access without complex permission hurdles.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open WPS Spreadsheet: Launch the application and select Spreadsheet to start organizing your data.
- 3. Import Your Data: Easily open your existing Excel or CSV files exported from your lists to manage your data without access request errors.
Frequently Asked Questions
Can I set permissions for specific columns in Microsoft Lists?
No, Microsoft Lists does not provide separate permissions for individual columns natively. Permissions can only be configured at the list, folder, or item level.
Why does a list item have unique permissions?
A list item might have unique permissions if it was manually shared with specific users, or if an automated Power Automate flow adjusted its access rights independently from the parent list.
How do I remove unique permissions from a list item?
Select the list item, navigate to Details > Manage access > Advanced, and click 'Delete unique permissions' in the ribbon. This will restore the item's permission inheritance from the parent list.
