Create a rule to automate a list or library
Applies ToSharePoint in Microsoft 365 Microsoft Lists Microsoft Teams

After you create a list or a library in Microsoft Lists, SharePoint, or Teams, you can create rules to automate tasks such as sending someone a notification when data changes in the list or a new file is created in the library.

You'll choose a condition that triggers the rule and the action that the rule will take. (To demonstrate, the following procedure creates a rule for a list. It will trigger a notification when a column changes.)

  1. With the list open in Microsoft Lists, SharePoint, or Teams, near the top of the page, select Automate,select Rules, and then Create a rule.Create a rule to automate a list in SharePoint.

  2. Under Notify someone when, select a condition that triggers the rule. For example, Data in a column changes.Set the condition trigger for the rule. Your selection here creates a rule statement that you'll complete in the next step.

    Note: Creating a rule based on a multi-line text column is not supported.

  3. Select each of the underlined portions of the rule statement to customize the condition by choosing a column, the value of the column, and whom to notify. For example, to finish a rule to notify yourself when data changes in a column, you could choose when Content Type changes to anything, and then for Enter a name or email address, you could select Me. (You can specify a person, or multiple individuals, but not a group email address.)Customize your rule with the values you want.

  4. When you're finished customizing the statement, select Create.

You'll see your completed rule on the Manage rules page, and the rule will be turned on. Notification emails are sent from the email address no-reply@sharepointonline.com. Return to this page whenever you need to edit, delete, or otherwise manage a rule.

Troubleshooting: Can't create a rule

If you encounter an error when you try to create a rule, it's likely caused by the permissions applied to the list or library. You need the help of someone who is an owner of the library or list to fix this situation, as described below.  

Permissions for libraries

In order to manage rules, you must be granted "Edit" permission to the library by the owner. The owner can do this by sharing the library with you and specifying Can edit.

Permissions for lists

The owner needs to open the list and select: Settings > List settings > Advanced settings. All available settings for the list will be displayed. 

In addition, in order to manage rules, you must be granted "Edit" permission to the list by the list owner. The owner can do this by sharing the list with you and specifying Can edit.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.