SharePoint List Rules
Microsoft Lists, AKA good old SharePoint lists, now have a new rules wizard. This is a very simplified way of creating notification rules, to be notified about certain things happening in the list. You can Create a rule, or click to Manage rules (edit or delete) rules that you’ve already created. Here’s what it looks like, at the top of a list:
Let’s start by clicking Create a rule.
Pick the trigger that you’d like to use, Notify someone when. Here’s some information about each trigger:
A column changes
Pick a column in the list, to be notified about the value in that column changing from anything to anything.
Who does the notification email need to be sent to? All people pickers (“person” columns) in the list will be shown here, to pick from. Would you like the alert to be sent to one of those people? If you’d like to receive the alert yourself every time, select Me.
A column value changes
Create this type of rule if the alert only needs to be sent when a specific column is changed to something specific. For example if you have a status column, and you want an alert when the status is “Completed”. Pick a column, then pick a condition such as is not and then enter a value. The choices available for conditions and values will be different depending on what type of SharePoint column you’ve selected.
In this example, the inventory column is a number column, so I can pick from the following conditions:
In this example, the Category is a choice column, so for the value, it shows the choice options from the column:
A new item is created
Send a notification when any new item is created in the list.
An item is deleted
Send an email each time any item is deleted from the list.
Managing Rules
On the Manage rules screen, you’ll see a list of the rules that you have created. Click any rule to edit it, or use the toggle to switch any rule off.
In the first 20 minutes of the following video, I demonstrated how to create rules, and the difference between rules and alerts. Alerts have been in SharePoint since version 2003, and are slightly different. Neither rules nor alerts allow customization of the notification email, but at least the alert emails are a bit more verbose, with details about the item(s) that triggered the alert.
Oh, and as I mentioned in the first sentence of this post, the new Microsoft Lists *are* SharePoint Lists.
@WonderLaura 
Do you know if this applies to 2016 or 2019 On Prem?
LikeLike
No, it does not.
LikeLike
Thanks Laura for all the good you do for SharePoint and related ecosystem. I don’t see this in my organization’s PROD tenant yet. I presume yours is in targeted release?
LikeLike
Yes. You should be getting it soon, unless you’re in a government tenant, then it could take a while.
LikeLike
Does these rules also apply to SharePoint Online Lists or just Microsoft Lists?
LikeLike
SharePoint Online Lists and Microsoft lists are the same thing. So yes, both.
LikeLike
Is this available in Document Libraries or just lists?
LikeLike
I don’t see this feature in libraries, not yet at least.
LikeLike
Laura, i was watched some videos about infopath forms and web parts, i am creating a web form in a library (infopath form) in sharepoint 2010, but i need to make a Form ID autoincrement to identify each web form saved, Let me know if you have a video that can help me to do it! thank you very much for your help!
LikeLike
Please note that there IS a similar functionality in SharePoint 2013 called “Alert Me”. Open your list, click on the List tab at the top and you will see “Alert Me” in the Share and Track group. It allows you to create similar alerts to add, update, delete, etc.
LikeLike
Yep, I covered that in the video and even showed examples of alerts versus rules and what the emails include.
LikeLike
Laura, why is not possible to add shared mailbox to the rule?
LikeLike
Not sure why Microsoft would not allow that.
LikeLike
I have 4 columns and only one of them is available in the drop down for the rule, “When ____ changes, send an email”. Why won’t other column names show up?
LikeLike
Found my own answer, in case anyone else needs it. My columns weren’t showing as options for the rule because “Note: We don’t support creating a rule based on a multi-line text column.”
LikeLike
Can you create a rule to be notified when an attachment is added to a list item in SharePoint Online
LikeLike
I don’t think so, no. Not with this rules feature. Maybe with a flow instead.
LikeLike
I’ve run into an issue where members of my Sharepoint site aren’t on the list when selecting users to email with a rule. Is this something you’ve seen before, or are you familiar with how the list rules parse / where they source recipients?
LikeLike
Oh interesting! No, I’ve never seen that happen. Maybe check to make sure that person does have permission to the list? All I can think is that it’s not showing people who don’t have access.
LikeLike
Can we send the notification to group of people through (PDL) using Create Rule. When new row is created I need to send notification to multiple people would it be possible?
LikeLike
Yes.
LikeLike
Do you know if there’s a history of notifications sent out from a SharePoint rule so we can keep track?
LikeLike
There is not a history of notifications, but there is version history on each item.
LikeLike