Get notified by email when a news post is created on a SharePoint site

Photo by Bram Naus on Unsplash

If you looking for publishing news content to your organization quickly and with perhaps looking to SharePoint News should be the way to go. You’ll have access to multiple tools and get for example content displayed from multiple sites. If you have the SharePoint App on your phone, you’ll be notified once something new is published. However, there are some scenarios where people may want to receive an email with this type of information.

If you want to create a newsletter to send to multiple people on the following link more information about it. In this case, we will cover a way to be notified by email once a news article is published on your site. For that, we gonna use the Power Automate.

  1. Create a flow
  2. Select the Trigger – When a file is created or modified (properties only)
    1. For Site Address select the site that you want to be notified
    2. For Library Name write Site Pages which is the library that will have the News-Post.
  3. Now select a Condition
    1. Select from the dynamic content the Property Promoted State and select if that is equal to 2
  4. On if yes:
    1. Select the Mail – Send an email notification (V3)
      1. You can now select your email, title and body email. You can use the properties stored on SharePoint to show some content from the News
  5. On if No:
    1. Pick the option to terminate.
PowerAutomate

Some considerations about this Power Automate:

  • The property Promoted State is used by SharePoint depending on the status of your page:
    • PromotedState equal to 0 is for pages on the site.
    • PromotedState equal to 1 is for unpublished pages
    • PromotedState equal to 2 is for News pages
  • Each time that the article is modified the users will receive a new email.
Email Sample

Conclusion

After a new news post is created you will be notified by email with a news post. Since we’re using the PowerAutomate to process this, you can expand this Automated Flow to for example publish on a Team Channel and others.

If you want to send this email with the no-reply take a look to this sample and combine this with that:

17 Comments

  1. Sylv1 said:

    Thanks. But that does not work when a page is created, then the user create a page then clicks on “Promote”

    January 20, 2021
    Reply
    • David Ramalho said:

      Hi,

      That probably means that when creating the pages they are of type page rather than News. They turn out News when you click to promote as news.
      To avoid this issue, I would recommend saving a page as a template with the Type news.

      My best,
      David Ramalho

      January 22, 2021
      Reply
  2. Translation problem said:

    Hi, I cannot find the property Promoted State. The problem is that my site is in Swedish and not English. What is the description for this property? I cannot find anything that matches in the list.

    February 26, 2021
    Reply
    • Søren said:

      I had the same problem, using a Danish tenant.
      Therefore, I ended up changing the display language and regional format (locale) to English & United Kingdom from within Power Automate settings.
      Then I will just put it back when I’ve built my flow.

      March 4, 2021
      Reply
  3. Gabriel Falcão said:

    Hayo, any ideas on how to send the entire body of the news post in the e-mail? The dynamic content “body” doesn’t work.

    April 6, 2021
    Reply
    • David Ramalho said:

      Hi Gabriel,

      You should be able to get that information from SharePoint REST API, however, it could be challenging to manage the code to send a proper formated email.

      My best,
      David Ramalho

      April 25, 2021
      Reply
  4. Linda said:

    Hi David,
    Thanks for your posts. I have a question.

    You wrote:.
    – Now select a Condition
    – Select from the dynamic content the Property Promoted State and select if that is equal to 2.

    What if I have no “promoted state” to choose? It’s always empty in my case and there is no dynamic content…

    thanks for helping,
    Linda

    July 1, 2021
    Reply
    • David Ramalho said:

      Hi,

      Please verify if you select the correct trigger the name should be “When a file is created or modified (properties only)”.

      My best,
      David Ramalho

      October 21, 2021
      Reply
  5. Luminara said:

    Hi! I cannot also see the PromotedState property.There is “no dynamic content available”.

    September 20, 2021
    Reply
    • David Ramalho said:

      Hi,

      Please verify if you select the correct trigger the name should be “When a file is created or modified (properties only)”.

      My best,
      David Ramalho

      October 21, 2021
      Reply
  6. Chris said:

    Same here. No Promoted state option available in dynamic content.

    September 29, 2021
    Reply
  7. Vincent said:

    We want to send an email to the entire company when a new post has been published/promoted. At the moment it only works when i create the news post.

    How can i solve this?

    December 8, 2021
    Reply
      • Jan said:

        I have the same problem. The flow is only working when I publish the news item, not when my colleague does it. It is not draft posts, she has published a post today, but my flow didn’t send an email.

        February 16, 2022
        Reply
  8. Daniel said:

    Thanks for the post! really helpful!
    Is there a way to avoid multiple emails for the same news post? I want to email a group of people when a file is created but not when it is modified… It seems like it creates multiple emails sometimes.
    I tried “When a file is created” as a trigger but it doesn’t trig most of the time, probably because the promoted state is at 1 rather than 2 when the file is created.

    February 23, 2022
    Reply
  9. Hi to every single one, it’s actually a pleasant for me to visit this site, it consists of precious Information.

    May 16, 2023
    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *