Flow idea: Post to Team channel when SharePoint news item is published
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.
DJ HeyvOOn commented
After search all over for this solution and without success. I was able to achieve this and I leave a link to a video tutorial I've made on how to achieve this step-by-step in a very quick way;
Eulàlia Mesalles commented
As Tara Hammond says, We need also to post automaticaly a message in the messages Teams group (General) when someones posts news in the News section of sharepoint.
Tara Hammond commented
agreed! We have a modern page as an intranet and would like any News post to also post in a company Teams channel as well. Teams will notify people of the post, where the SharePoint news page will not.
Chris Webb commented
Hey Chris, All this stuff is available with the get list item and get list item metadata flow actions and you lookup pages by promoted state=2. Then you can add in a Post to Teams, need to use the Teams markup language stuff to get URL's etc. There is some kind of tool in the app store for Teams cards, I recommend creating those cards from the message post, so you can get fancy with the look. Other methods are using a webhook, posting that message to a webhook via flow, then subscribe to the webhook inside the Team channel which will get you the same thing with a card etc. But you get notifications.