Modern SharePoint Alerts for News Posts

%3CLINGO-SUB%20id%3D%22lingo-sub-1698604%22%20slang%3D%22en-US%22%3EModern%20SharePoint%20Alerts%20for%20News%20Posts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1698604%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20work%20out%20how%20our%20staff%20can%20be%20notified%20when%20a%20new%20News%20Post%20is%20published.%20I%20am%20aware%20it%E2%80%99s%20not%20possible%20to%20simply%20subscribe%20to%20news%20posts%20with%20the%20current%20built%20in%20alerts%20system%20therefore%20I%20have%20managed%20to%20create%20a%20Flow%20that%20uses%20the%20trigger%20%22When%20file%20is%20created%20or%20modified%22%20using%20the%20steps%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fcollab365.community%2Fusing-flow-sharepoint-news-notifications%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcollab365.community%2Fusing-flow-sharepoint-news-notifications%2F%3C%2FA%3E%3C%2FP%3E%3CP%3EThe%20problem%20I%20am%20now%20having%20is%20that%20it%20won%E2%80%99t%20accept%20our%20staff%20mailing%20list%20email%20address%20as%20the%20email%20recipient%20and%20I%20am%20wondering%20how%20to%20get%20the%20email%20to%20send%20to%2050%2B%20people.%20Other%20than%20manually%20adding%20each%20email%20address%20(trying%20to%20avoid%20this%20as%20will%20then%20have%20to%20constantly%20add%2Fremove%20email%20addresses).%3C%2FP%3E%3CP%3EI%20tried%20adding%20a%20column%20to%20a%20list%20of%20current%20staff%20which%20has%20their%20individual%20email%20address%20and%20thinking%20there%20is%20a%20way%20can%20get%20it%20to%20pull%20from%20that%20column%20but%20I%20am%20not%20sure%20how%20to%20go%20about%20it%2C%20can%20anyone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1698604%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1698647%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20SharePoint%20Alerts%20for%20News%20Posts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1698647%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F802991%22%20target%3D%22_blank%22%3E%40gcassidy%3C%2FA%3E%26nbsp%3B-%20what%20happens%20when%20you%20try%20to%20use%20the%20staff%20email%20address%3F%20You%20may%20want%20to%20try%20using%20a%20variable%3A%3C%2FP%3E%3CP%3EStep%20is%20called%20'Initialize%20variable'%2C%20maybe%20call%20it%20varEmail%2C%20set%20it%20to%20be%20a%20string%20and%20then%20add%20the%20staff%20email%20address%20there.%20In%20the%20email%20step%2C%20rather%20than%20type%20in%20the%20true%20email%20address%2C%20type%20in%20varEmail.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

 

I am trying to work out how our staff can be notified when a new News Post is published. I am aware it’s not possible to simply subscribe to news posts with the current built in alerts system therefore I have managed to create a Flow that uses the trigger "When file is created or modified" using the steps here: https://collab365.community/using-flow-sharepoint-news-notifications/

The problem I am now having is that it won’t accept our staff mailing list email address as the email recipient and I am wondering how to get the email to send to 50+ people. Other than manually adding each email address (trying to avoid this as will then have to constantly add/remove email addresses).

I tried adding a column to a list of current staff which has their individual email address and thinking there is a way can get it to pull from that column but I am not sure how to go about it, can anyone help?

1 Reply

Hi @gcassidy - what happens when you try to use the staff email address? You may want to try using a variable:

Step is called 'Initialize variable', maybe call it varEmail, set it to be a string and then add the staff email address there. In the email step, rather than type in the true email address, type in varEmail.