Skip to main content
< All Articles

How to create an alert on metadata value in SharePoint

Posted on February 19, 2020

A while back, I published a blog post on how to create an alert in SharePoint. Today I would like to take this functionality further and explain to you a neat trick on how to set up conditional alerts based on metadata value. Here is a scenario. You have a document library with a Status column and would like to be notified ONLY when someone changes the status of a document to Approved. As we know, by default, it is either all modifications or none. Luckily, with a quick trick I am about to show you, you will be able to create an alert on metadata values, which, in this case, means that users will only get an alert when Status is changed to Approved. Intrigued already? Well, honey, grab some popcorn – let’s do it!

Prep Work before we create an alert on metadata

As far as prep work, we have a document library with a Doc Status Choice Column with Submitted, Pending, and Approved drop-down choices. I suggest you check out this post on how to create custom metadata for your list or library. I assume that your IQ is high enough to get past this hurdle.

create an alert on metadata

Step 1: Create a filtered view that captures a specific condition

The first step in the process is to create a filtered view based on a Status Column.

  1. From the document library, click on the drop-down next to the column name, then Filter by create an alert on metadata
  2. Check the box next to the condition you want to be alerted about (i.e., Approved), click Apply Howtocreatealertmetadata3a
  3. Save the view by doing Save view as Howtocreatealertmetadata4
  4. Give the view a name, click Save Howtocreatealertmetadata5

Step 2: Create an alert on a filtered view

This is where the magic happens. Go ahead and create an alert on the document library, like you usually would.

  1. Click the ellipsis > Alert me create an alert on metadata
  2. Under Send Alerts for These Changes, check the radio button next to Someone changes an item that appears in the following view, then choose the view you created in the previous step. Save the alert. create an alert on metadata
  3. Now, go ahead and change the status on one of the documents to Approved – and head over to the Inbox! You will see the email alert sent to you! (emails will not be sent for any other metadata changes) Howtocreatealertmetadata8


  1. A view must be based on a filter for it to show in the alert setup screen. Any other views you have on your list or library (i.e. Grouped by or Sorted By) will not show up
  2. Views with filtering on system columns (i.e., Modified By) will not show up in the list of available views in the alert setup screen

About Me

I’m Greg Zelfond, a U.S. based SharePoint consultant, and I provide affordable out-of-the-box SharePoint consulting, training, and configuration assistance to small and medium-sized businesses all over the world.

Need help?
Alarm Gc9c7657b4 1280

How Planner Notifications work

Planner application proved to be a great task management tool for small and lightweight projects that do not need to follow a formal Waterfall project management approach. Of course, as…

Read More