How to Enable Create a Rule in SharePoint Online Lists
Question details
The user wants to find or enable the 'Create a Rule' feature in SharePoint Online lists, as it is missing from the Automate menu in certain lists.

- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- A user is trying to set up automated rules within a SharePoint list but cannot find the feature under the Automate menu or the admin center.
- Observed behavior
- The 'Create a Rule' option appears in some SharePoint Online lists but is completely missing in others, with no direct setting available in the SharePoint admin center to turn it on.
Verify that you have at least 'Edit' permissions for the SharePoint list, as users with only 'Read' or 'View' access will not see the automation features.
Verify List Limits and Column Compatibility
Use this method to ensure your specific SharePoint list meets the technical requirements for the 'Create a Rule' feature.
The 'Create a Rule' feature has specific prerequisites. If your list exceeds the maximum rule limit or uses unsupported column types, the option will be hidden from the Automate menu.
Navigate to the list, click 'Automate', and select 'Manage rules'. Ensure your list currently has fewer than 15 active rules, as this is the maximum allowed per list.
Go to 'List settings' via the gear icon. Review your columns to ensure you are not exclusively using complex or unsupported column types (like certain calculated columns) that might restrict basic rule creation.
Click the gear icon, go to 'List settings', and select 'Permissions for this list'. Confirm that your account has 'Edit' or 'Full Control' permissions.

Monitor Tenant Rollout and Contact Support
Since the feature is deployed gradually by Microsoft, follow these steps to determine if the rollout is pending or if there is a tenant-side error.
Need a lightweight office suite to open documents from SharePoint?
While SharePoint handles list automation online, you still need a reliable desktop application to view and edit downloaded Word, Excel, and PowerPoint files. WPS Office is a highly compatible, fast, and completely free alternative to Microsoft Office.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the software: Run the installer and follow the simple on-screen instructions to set up WPS Office on your computer.
- 3. Open your SharePoint documents: Download your documents from SharePoint and double-click them to edit seamlessly inside WPS Office.

Frequently Asked Questions
Can I manually enable 'Create a Rule' from the SharePoint Admin Center?
No. There is no toggle or configuration setting in the SharePoint Admin Center to manually switch this feature on. It is deployed and enabled automatically by Microsoft's backend updates.
Why is 'Create a Rule' grayed out or missing when I try to use it?
This usually happens if your list has reached the maximum limit of 15 rules, your account lacks Edit permissions, or the list consists of unsupported column types.
What is the maximum number of rules a SharePoint list can hold?
A single SharePoint list can hold a maximum of 15 rules. If you need more complex automation or a higher volume of workflows, you should consider using Power Automate.
Does 'Create a Rule' support all column types in SharePoint?
No, rules generally work best with standard text, date, and choice columns. Certain complex columns, lookups, or specifically calculated columns may not be fully supported by the basic rule builder.




