To send mail alerts when a news post is published, you can create a Microsoft Flow that triggers when a new item is added to the Site Pages list. You can then use a Condition action to check if the item is a news post or a normal page. Unfortunately, there is no ‘Promoted state’ field in Site Pages list to distinguish between news posts and normal pages. However, you can use the Content Type field to differentiate between the two.
Here are the steps to create the Flow:
- Open Power Automate and create a new flow.
- Select the When an item is created trigger and select the Site Pages list.
- Add a Condition action and set the condition to check if the Content Type field equals the news post content type.
- If the condition is true, add a Send an email action to send the mail alert.
Please note that you will need to have the On-Premises Data Gateway installed to connect to your SharePoint 2019 on-premises environment. You can find more information on how to set up and configure the gateway in the Microsoft Learn documentation.