Forum Discussion

John Edward Paredes's avatar
John Edward Paredes
Copper Contributor
Oct 23, 2018

How to Send an Email when added a News Post in SharePoint Online site

How do you Send an Email to notify a user whenever a new News Post is created in SharePoint Online site? Please help on how to do this. What are the ways.
developer
SharePoint Online
Sites
Matt Weston's avatar
Matt Weston
Iron Contributor
Apr 18, 2019

Hi KevinO1984 that's a great question and a good extension of what we've already done.

 

As my trigger is "When a file is created or modified (properties only)" I'm able to see the properties of the page coming back. If I've used another trigger, I'll need to use the action "Get File Properties" to get the same info.

 

There are two properties which I could use to add some more info to my email:

  • Banner Image URL
  • Description

Banner Image URL will take the image url of the image which I have assigned as the header of my news page. If I have no header, this field will be populated with the first image that it finds on the page. This is how the rollup image to the news web part works. You can take this URL and use it within HTML in our email.

 

The Description takes the first paragraph from the news item, so again you can use this to add into your email. I don't think there's a native way of grabbing the entire news article from the properties as it doesn't get tagged as metadata, but I'll have a look to see if there are other options which we can explore.

fvp11's avatar
fvp11
Copper Contributor
Nov 27, 2019
Hi Matt. Is there anyway you could share this Flow?

As I understand it, you have designed a Flow that can send an email, when a news post have been published 🙂 Would really like to use that.
  • Neha_Rathi's avatar
    Neha_Rathi
    Copper Contributor
    Apr 29, 2020

    Matt Weston This solution works like charm for Outlook web client but it does not work for desktop. Can you please help us in anyway?

    Thanks,

    Neha

  • ALDINA3003's avatar
    ALDINA3003
    Brass Contributor
    Jan 30, 2020

    Hi Matt,

     

    I love this! Thank you thank you, Matt, for sharing.  The cherry on top of the cake would be sending notifications to all the people that follow that site otherwise it seems like you have to enter each individual's name into the flow. Any way to pull that basedo on the site viewers if "following" is not an option? 

     

    Matt Weston 

  • DaithiG's avatar
    DaithiG
    Steel Contributor
    Dec 03, 2019

    Thanks Matt Weston ! 

     

    It's a pity there's no inbuilt way to schedule a news digest and email it to staff.

  • Matt Weston's avatar
    Matt Weston
    Iron Contributor
    Dec 02, 2019

    Hi DaithiG that's correct, however you've got me thinking now if I could do something around the content roll up. Let me see what I can come up with 🙂

  • DaithiG's avatar
    DaithiG
    Steel Contributor
    Nov 29, 2019

    Hi Matt Weston that looks great!

     

    Correct me if I'm wrong but that only works per site? It wouldn't pickup a news post that was rolled up to the site?


    I.e. if I had a site called IT and site called "Main Intranet", I'd have to have a flow per site for the news email?

Resources