How To Create Rules To Automate SharePoint List

Introduction

Now, we can create rules for the SharePoint list to automate the process such as sending someone a notification when data changes in the list.

There are some other tasks you can configure to automate the SharePoint list.

Follow the below steps to create rules in SharePoint rules,

Create a rule

Step 1

Go to your SharePoint list.

Step 2

Now, click on Automate from the ribbon and click on Create a rule.

How To Create Rules To Automate SharePoint List

Step 3

On clicking Create a rule, it will open a popup with all the conditions for which we can create a rule for the list.

How To Create Rules To Automate SharePoint List

Step 4

Here, select the condition for which you want to create a rule.

A column changes

  1. When you select the A column changes option, it will show the below fields:

    How To Create Rules To Automate SharePoint List

  2. In Choose a column dropdown down, select the column for which you want to create a rule.
  3. In Enter a name or email address column, select the user to whom you want to send email notification when the selected column is changed. You can select people and group column or you can type the user name/email address as well.
  4. Once you have selected both fields, click on Create button.
  5. Now, when you change the value of the selected column for the existing list item, it will send an email notification to the selected user. Mail will be as below screenshot:

    How To Create Rules To Automate SharePoint List

A column value changes

  1. When you select A column value changes option, it will show the below fields.

    How To Create Rules To Automate SharePoint List

  2. In Choose a column, select the column for which you want to create a rule.
  3. In Choose a condition, select the operation which you want to use for the condition.

    How To Create Rules To Automate SharePoint List

  4. In Enter a value field, enter the value which you want to compare for condition.
  5. In Enter a name or email address, select the user to whom you want to send an email when the condition fulfills. Here, you can select multiple users as well.

    How To Create Rules To Automate SharePoint List

  6. The above rule will send an email to Sanjay Makwana users when the Title is updated to text Intranet.

A new item is created

  1. When you select the A new item is created option, it will show the below fields.

    How To Create Rules To Automate SharePoint List

  2. In Enter a name or email address field, select the user to whom you want to send an email when a new item is created in the list. Here, you can select multiple users as well.
  3. Click on Create button. Now when a new item is created in the list, it will send an email notification to the selected users.

An item is deleted

  1. When you select A new item is deleted option, it will show the below fields.

    How To Create Rules To Automate SharePoint List

  2. In Enter a name or email address field, select the user to whom you want to send an email when a new item is deleted from the list. Here, you can select multiple users as well.
  3. Click on Create button. Now when an item is deleted from the list, it will send an email notification to the selected users.

Manage rules

Once you have created a rule, you can turn off the rule, update the rule and delete the rule.

Step 1

To manage the rules, click on Automate and select the Manage rules option,

How To Create Rules To Automate SharePoint List

Step 2

On clicking Manage rules, it will open a popup and lists all the created rules for the current list.

How To Create Rules To Automate SharePoint List

Step 3

To turn off the particular rule, you can turn off the toggle button.

How To Create Rules To Automate SharePoint List

Step 4

To edit, click on the particular rule. It will open the details of the rule. Here, update the rule and click on the Save button.

How To Create Rules To Automate SharePoint List

Step 5

To delete, click on the particular rule. It will open the details of the rule. Now, click on the Delete rule from the bottom left corner.

How To Create Rules To Automate SharePoint List

Conclusion

This is how we can create and manage the rules of the SharePoint list. I hope this article will be helpful for you!