SharePoint Document Issues

How to Restore the Missing Automate Option in a SharePoint List

Huma Ashraf Ch Sep 28, 2026 869 views

Question details

Users need to restore the Automate option that has become disabled in a specific SharePoint list, preventing them from running Power Automate workflows.

How to Restore the Automate Option in a SharePoint List

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Attempting to trigger Power Automate workflows from a SharePoint list where the Automate button is unexpectedly disabled.
Observed behavior: The Automate option is grayed out or disabled in one specific list for multiple users, while it functions normally in other lists. Clearing the browser cache does not fix the issue.

Before you start

Ensure you have Site Owner or Full Control permissions for the affected SharePoint list before attempting to modify its advanced settings.

Solution 1Recommended

Adjust Item-Level Permissions in Advanced Settings

Modifying the item-level permissions back to default often restores the Automate functionality in the list.

Inconsistent behavior across different SharePoint lists is often caused by specific item-level permissions. If a list is configured so that users can only read items they created, it may inadvertently disable features like Power Automate.

Navigate to List Settings

Open the affected SharePoint list, click on the Settings gear icon in the top right corner, and select 'List settings'.

Open Advanced Settings

Under the General Settings column on the configuration page, click on 'Advanced settings'.

Modify Item-Level Permissions

Scroll down to the Item-level Permissions section. Set the read access to 'Read all items' and the create/edit access to 'Create and edit all items'.

Save and Verify

Scroll to the bottom, click 'OK' to save your changes, and reopen the list to verify that the Automate option is now restored.

Adjust Item-Level Permissions in Advanced Settings

Alternative for Restricting Views: If you need to restrict users to only see items they created, do not use item-level permissions. Instead, create a list view and set a filter where 'Created By' is equal to '[Me]'.

Free Microsoft Office alternative

Seamlessly Manage Your Office Documents with WPS Office

While SharePoint list settings require a web browser to manage, WPS Office offers a free, lightweight, and highly compatible alternative for opening, editing, and managing your SharePoint and OneDrive documents with a familiar interface.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your computer.
2. Open Your Documents: Launch WPS Office and navigate to your synced SharePoint folders to open any Word, Excel, or PowerPoint files natively.
3. Edit and Save: Edit your documents using familiar tools and save them directly back to your synced folders, maintaining full Microsoft Office format compatibility.

Fully compatible with Microsoft Word, Excel, and PowerPoint formatsEasily access and edit documents downloaded or synced from SharePointLightweight application that runs smoothly on most devicesFamiliar user interface for a seamless migration with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Automate button missing in only one of my SharePoint lists?

This usually occurs because specific custom configurations, such as restricted item-level permissions or specialized view formatting, have been applied to that individual list, overriding default site behaviors.

Can users with read-only permissions still run Power Automate workflows?

Historically, users with read-only permissions could trigger workflows. However, changes to permission structures or workflow sharing settings might restrict this. Ensure the workflow is shared properly as a 'Run-only' flow with the necessary users or groups.

How do I compare advanced settings between two SharePoint lists?

Open two separate browser tabs. In one tab, navigate to the Advanced Settings of a working list, and in the other, open the Advanced Settings of the problematic list. Check side-by-side to identify any discrepancies in permissions, versioning, or offline client availability.

What is the '[Me]' filter in SharePoint?

The '[Me]' filter is a dynamic view condition that automatically filters a list to only show items related to the currently logged-in user. It is a safer way to restrict visibility without altering foundational list permissions.

Document & File Issues