# Microsoft Lists rule did not send the email: what to check

> For the full documentation index, see https://250highstreet.com/llms.txt

> A built-in Microsoft Lists rule sent nothing, or only to the wrong person. Use this checklist to find why, and learn when to switch to Power Automate.

Short answer: check four things first. You need Contribute permission to manage rules, a rule on a multi-line text column is not supported, a rule cannot notify a group email address, and a list or library can have only two "a date approaches" rules. Then look in junk mail for no-reply@sharepointonline.com, the address Microsoft says the notification emails come from. If you need groups or more date reminders, use a Power Automate flow.

Exact names may differ on your screen. The Microsoft help page for this feature is listed at the end.

## What a list rule is

A rule watches a list or library. When something happens, such as an item being changed, the rule sends an email. You set it up by filling in a sentence. You pick the trigger, then select each underlined part of the sentence to choose a column, a value, and who to notify.

Microsoft's example is a rule that emails the person in the Created By column when the Purchase price changes to more than an amount you set.

Rules are meant to be quick. They are not a full automation tool. Knowing where they stop saves a lot of time.

## What rules can and cannot do

These are the facts Microsoft states on its rules help page.

- Who gets the email: a specific person, several people, or a person column. Microsoft says you cannot use a group email address.
- Rules based on a multi-line text column are not supported.
- "A date approaches" rules are limited to two per list or library.
- The email comes from no-reply@sharepointonline.com, not from you. People may not see it as coming from your team.
- A new rule is turned on by default and shows on the Manage rules page.

The help page does not list other limits. It does not say how many people you can add to one rule, so do not assume a number.

## Diagnosis checklist

Go in this order. Each step is quick.

1.  Check you are allowed to manage rules. Microsoft says the likely cause of an error when you create a rule is permissions, and that you need Contribute permission on the list or library. If you get an error, ask the list owner for access.
2.  Open the Manage rules page and confirm your rule is there and turned on. If it is not listed, it was not saved or someone removed it. Create it again.
3.  Read the rule sentence out loud. Does it say what you meant? A rule on "An item is modified" is different from a rule on a change to one column.
4.  Check the column type. If the rule depends on a multi-line text column, it is not supported. Move the key value to a single line, Choice, Number or Date column.
5.  Check who is set to be notified. If you used a group email address, that is the problem. Use named people, or a person column, instead.
6.  If it is a date rule, count the "a date approaches" rules on the list. Two is the limit.
7.  Check the rule is looking at the right column and value. A value that is typed slightly differently from your real choice text will never match.
8.  Check the inbox of the person who should get the email, including junk. The sender is no-reply@sharepointonline.com. Your mail system may treat it as junk, or an admin rule may block it. Ask your admin to allow that address.
9.  Make a test change that should fire the rule, and watch for the email. Use your own address as the person to notify while you test.

## A rule is missing from the menu

Microsoft says to open rules with the list or library open: select Integrate, then Rules. Microsoft says you must be granted Contribute permission to manage rules, so check that first. If the rule is not on the Manage rules page, it was not saved or someone removed it.

## When to switch to Power Automate

Rules are good for one simple email. Power Automate is the next step when you need more control. Microsoft describes cloud flows that start from a trigger or on a schedule, and these facts about them are on its Power Automate pages.

- A flow can run on a schedule, such as once a day. This helps when you want one summary instead of many messages. See "[Late tasks nobody notices](/guides/late-tasks-nobody-notices/)".
- A flow can run a date check each day. This helps when you need more than two date reminders. See "[Send a reminder before a due date in a SharePoint list](/guides/send-reminder-before-due-date/)".
- A flow can post to Teams instead of sending email. See "[Post to Teams when a SharePoint list item changes](/guides/teams-message-from-sharepoint-list/)".

Switch when:

1.  You need more than two "date approaches" rules on one list.
2.  You need to notify a group of people and a group address is not allowed.
3.  You want one summary per person each day, not one email per change.
4.  You want the message in Teams, or in more than one place.
5.  You want the message to say more than a rule can fill in, such as a link and a short instruction.

Keep a rule when you need one plain email to one named person and nothing else.

Before you build a flow, check what your Microsoft 365 plan includes. Which flow features you get depends on your license, so check with your admin.

## Rules or Power Automate: side by side

- Notify a group email address: a rule cannot. Microsoft says you can name a person, several people or a column, but not a group email address. Name the people in the rule, or send from a flow and test that the group gets it.
- "A date approaches" reminders: a list or library can have two rules of this type. A scheduled flow can run a date check each day.
- One email per person per day: a rule sends from a trigger. A scheduled flow can send one summary.
- Message text and several conditions: Our advice, not a Microsoft rule: a flow gives more control over both, at the cost of someone owning it.
- Setup: a rule is one sentence you fill in. A flow needs an owner and a check that it still runs.

## Know the limits of flows too

A flow is not a set-and-forget tool. Microsoft's limits page says a cloud flow with a trigger or actions that fail continuously is turned off after 14 days. It also says: "A cloud flow that isn't triggered within a 90 day period might be turned off." The same page says flows owned by users with premium licenses are exempt from that. Run history is kept for 30 days.

So name one person who watches the flow, and make sure the failure emails reach a real inbox.

## What to avoid

- Do not set a group email address as the person to notify. Microsoft says it is not allowed.
- Do not build a rule on a multi-line text column. It is not supported.
- Do not plan on more than two date rules on one list. Two is the limit.
- Do not assume the email reached the person. Test with your own address first.
- Do not rely on one rule for something that must not be missed, such as a contract date. Add a second check, such as a view that someone reads each week.
- Do not build a flow when a rule is enough. A flow needs someone to own it.

## Check that the fix works

1.  Make the change that should fire the rule.
2.  Confirm one email arrives in the right inbox.
3.  Change something that should not fire it. Confirm no email arrives.
4.  Check Manage rules to confirm the rule is still on.
5.  If you moved to a flow, run it once by hand and read the run result.

## Honest limits

This page covers the built-in rules as Microsoft describes them. Microsoft's help page does not explain every cause of a missing email. If you have checked everything above and nothing arrives, the next place to look is your mail system, and your admin can help with that.

A rule or a flow tells people. It does not make them act. If emails are ignored, look at how many people get them and whether the owner of each item is clear.

If you do not have a list yet, see "[Replace a spreadsheet tracker with a SharePoint list](/guides/replace-spreadsheet-with-sharepoint-list/)".

## When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: \$5,000 for one, built in 2 weeks. See "[What a SharePoint tracker costs to build](/guides/what-a-sharepoint-tracker-costs/)". Bring one example of the problem to a free call.

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: [Tools I built](/portfolio/)

## FAQ

### Why is my list rule missing?

Microsoft says to open rules with the list or library open: select Integrate, then Rules. Managing rules needs Contribute permission, and a rule that was not saved is not on the Manage rules page.

### Should I use a list rule or Power Automate?

A rule is one simple email with limits: no group address, no multi-line text column, two "a date approaches" rules per list. A flow can run on a schedule or post to Teams, and it needs an owner.

### Why is my list rule not sending emails?

Check Contribute permission, the column type, a group address as recipient and the two-rule date limit. Then check junk mail and allow no-reply@sharepointonline.com, the address Microsoft says the emails come from.

### Can a list rule email a group address?

Microsoft says you can specify a person, several people, or a column, but not a group email address. Name the people, or use a flow.

### How many date reminders can one list have?

Microsoft says "a date approaches" rules are limited to two per list or library. For more, use a scheduled flow.

## Sources

- [Microsoft Support, Create a rule to automate a list or library](https://support.microsoft.com/office/create-a-rule-to-automate-a-list-151ea008-7fa6-409b-b0bd-b04a3b3cacd5)
- [Microsoft Learn, Limits of automated, scheduled, and instant flows](https://learn.microsoft.com/en-us/power-automate/limits-and-config)

## Related guides

- [List form says Something went wrong when I save](/guides/sharepoint-list-form-something-went-wrong/)
- [Show each person only their own items in a SharePoint list view](/guides/sharepoint-list-view-filter-current-user/)
- [SharePoint alerts are retired: what to use instead](/guides/sharepoint-alerts-retirement-replacement/)
- [Power Automate new designer: switch back to classic and copy actions](/guides/power-automate-new-designer-switch-to-classic/)

Source: https://250highstreet.com/guides/microsoft-lists-rules-not-working/