Creating Rules for Microsoft Lists – A Simple Alternative to Power Automate Flows
Somewhere between the classic Alerts functionality and Power Automate flows, we find the ability in Microsoft Lists to create rules for lists. Rules allow us to do some pretty basic – but VERY common things.
Creating a rule for a list is fairly straightforward. In the toolbar at the top of the list view, click on automate, and Create a rule.
There are only four options right now, but I expect this will expand. Microsoft is getting better at building what I think of as “bridging functionality”. Rather than the old days, where almost everything useful required a developer, there are now multiple options along a spectrum to accomplish many things.
The four options today are Notify someone when…
- A column changes
- A column value changes
- A new item is created
- An item is deleted
Note that #2 and #4 weren’t even possible not that long ago. We had to do all kinds of hocus-pocus for #2 and there simply wasn’t a “hook” for #4.
If you think about it, a huge number of SharePoint Designer workflows were built over the years JUST to send email notifications. This applies the 80/20 rule (one of my favorite rules – aka the Pareto Principle) to those use cases.
When you choose which rule you’d like to use – and I love how the graphics make it much easier to decide – you land on a screen where you just need to select a few values to set things up. If you’ve ever created a rule in Outlook to shuffle emails from specific sources into folders, you’ll recognize this type of logic.
The screen is also “list aware” – it knows which columns might make sense for each slot and what its possible values are. Here, I’m asking the list to notify me when the Category column is (equals) “(1) Category1”.
For the notification, all Person columns in the list are available.
As you can see, there’s little thinking involved: the columns are available in a dropdown when you need them.
Once you’ve set up a rule or rules, you can manage them from the same dropdown.
The ensuing screen shows you all the rules you have created, allowing you to delete them or just turn them off. The “Off” toggle is excellent to have when you’re loading content or making bulk metadata changes. You can stop the flood of notifications easily but equally easily turn the rule(s) back on.
Under the covers, this capability undoubtedly uses the web hooks for list items. This means the notifications will be fast and painless.
By the way, you may be wondering what those notifications look like. Truth is, they are nothing fancy. But they probably look better than 80% of the notifications you ever built in SharePoint Designer workflows over the years. This is another area where I expect the capability will expand, allowing some level of customization for the emails.
So the next time someone asks you to write a flow just to send an email when list items change, make sure to think about using rules instead. They will be amazed how fast you solve the problem.
That looks useful! is it available now?
It’s available in my tenant and I’ve seen it in others. Looks like it rolled out in February. https://www.microsoft.com/en-us/microsoft-365/roadmap?featureid=64163
Sooooo…. I can write a rule to send someone else and email. Or it assumed I direct the requestor to write their own rule? How does the long term management of the rule work? If I leave the company 2 weeks after writing the rule does it go away and any rule I have written for someone else stops working?
Good questions, @Jeff. I’m not sure of the answers, but I’ll see if I can find out
@Jeff:
I checked with the product folks, and got some details for you.
Rules don’t use flows under the covers. (I expected they would.) Whoever saves a rule becomes the user that the rules engine will use to execute the rule, but there is no rule owner or member as all list members can access and manage rules. This means it’s more of a communal capability.
Hope this helps.
M.
Unfortunately this doesn’t appear to handle more than a single condition. What if I need to be notified when a record is marked Urgent, Pending, and is more than 3 days old?
For something like that, you’ll need Power Automate. But that’s also easy to set up – assuming you have permissions to do so.
I am not able to send a email to a Sharepoint group which i am referring from one of the field in the list.
I just tested, and I’m able to configure a rule to send the alert to the value stored in a Person or Group column. Are you unable to choose the column or is the email not arriving as you expect?
Hi
When you enter an email address for the notification to go to and that email address is to a person who is not a member of the SharePoint. Can you restrict it so that only see the single list item and can not access the rest of the list?