Flow idea: Post to Team channel when SharePoint news item is published

%3CLINGO-SUB%20id%3D%22lingo-sub-74821%22%20slang%3D%22en-US%22%3EFlow%20idea%3A%20Post%20to%20Team%20channel%20when%20SharePoint%20news%20item%20is%20published%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-74821%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI'd%20like%20Flow%20to%20post%20to%20Teams%20when%20someone%20publishes%20a%20SharePoint%20News%20item%20in%20a%20new%20modern%20communications%20site%20(or%20the%20team%20site%20associated%20with%20the%20Team%2C%20for%20that%20matter).%20That's%20technically%20a%20%22file%22%20in%20the%20Site%20Pages%20library%2C%20so%20I%20tried%20using%20%22new%20file%20added%22%20%26gt%3B%20post%20a%20message%2C%20and%20this%20was%20the%20best%20I%20could%20do.%20It%20created%20a%20plain%20text%20post%20(no%20hot%20URL)%20with%20a%20filename.aspx%2C%20which%20is%20really%20all%20the%20builder%20would%20let%20me%20do.%20I'd%20love%20to%20at%20least%20have%20access%20to%20more%20metadata%20like%20the%20Title%20of%20the%20news%20post%2C%20the%20author%2C%20and%20the%20URL%20instead%20of%20the%20file%20path.%20A%20dedicated%20trigger%20for%20News%20would%20be%20ideal.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EVOTE%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F19484866-flow-idea-post-to-team-channel-when-sharepoint-ne%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F19484866-flow-idea-post-to-team-channel-when-sharepoint-ne%3C%2FA%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-74821%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdoption%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-74876%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20idea%3A%20Post%20to%20Team%20channel%20when%20SharePoint%20news%20item%20is%20published%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-74876%22%20slang%3D%22en-US%22%3EGet%20File%20Metadata%20does%20let%20me%20get%20a%20few%20more%20fields%2C%20but%20none%20of%20them%20useful%20for%20my%20purposes.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-74858%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20idea%3A%20Post%20to%20Team%20channel%20when%20SharePoint%20news%20item%20is%20published%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-74858%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20a%20%22Get%20file%20metadata%22%20or%20%22Get%20entity%20values%22%20action%20after%20the%20trigger%20and%20before%20the%20%22Post%20a%20message%22%20not%20give%20you%20access%20to%20better%20dynamic%20content%20to%20drag%20into%20your%20message%3F%20Never%20tried%20them%20on%20a%20News%20item%2C%20so%20not%20sure%20what%20will%20return%20on%20the%20.aspx.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-74834%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20idea%3A%20Post%20to%20Team%20channel%20when%20SharePoint%20news%20item%20is%20published%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-74834%22%20slang%3D%22en-US%22%3ENice%20and%20great%20idea!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2174701%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20idea%3A%20Post%20to%20Team%20channel%20when%20SharePoint%20news%20item%20is%20published%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2174701%22%20slang%3D%22en-US%22%3EHere%20I%20leave%20a%20link%20to%20a%20video%20tutorial%20I've%20made%20on%20how%20to%20achieve%20this%20step-by-step.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FsHUPqGDKqpk%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2FsHUPqGDKqpk%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EDon't%20forget%20to%20give%20a%20thumbs%20up%20%3Athumbs_up%3A%3C%2FLINGO-BODY%3E
Regular Contributor

I'd like Flow to post to Teams when someone publishes a SharePoint News item in a new modern communications site (or the team site associated with the Team, for that matter). That's technically a "file" in the Site Pages library, so I tried using "new file added" > post a message, and this was the best I could do. It created a plain text post (no hot URL) with a filename.aspx, which is really all the builder would let me do. I'd love to at least have access to more metadata like the Title of the news post, the author, and the URL instead of the file path. A dedicated trigger for News would be ideal.

 

VOTE here: https://microsoftteams.uservoice.com/forums/555103-public/suggestions/19484866-flow-idea-post-to-tea...

4 Replies

Does a "Get file metadata" or "Get entity values" action after the trigger and before the "Post a message" not give you access to better dynamic content to drag into your message? Never tried them on a News item, so not sure what will return on the .aspx.

Get File Metadata does let me get a few more fields, but none of them useful for my purposes.
Here I leave a link to a video tutorial I've made on how to achieve this step-by-step.
https://youtu.be/sHUPqGDKqpk

Don't forget to give a thumbs up :thumbs_up: