Answered

Flow that sends an email when news post is published on sharepoint with 'Post and Send'

(0) Share

Report

Posted on by HS-06020917-0

I've been trying to create a flow that sends an automated email when a news post is published to a site with 'Post and Send' button. But it has issues with it not running at times or at times sending multiple emails. What's the correct way to do this?

It looks at when an item is CREATED in Site Pages list of the site (as that is where news posts seem to go), but since it seems to send even on random edits of a news post and auto saves of a news post instead of only when Post and Send is pressed, it looks like this isn't the way to go?

I then have it send an email (as above).

Thank you.

Categories:

Building flows

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try adding the following as a trigger condition and change your trigger to when a file or item is created or modified:

@equals(triggerOutputs()?['body/{VersionNumber}'], '1.0')

You will need to check with the people who are creating these, but generally the page should be less than version 1.0 until it is published, which would typically occur with Post and Send. However, people could publish it and then realize it is visible to everyone and then unpublish the page. If that happened, your workflow would have already triggered and sent the e-mail.

Why do you not want to use the e-mail capability that news posts already allow? This has some tips for handling news posts: Create and send SharePoint news post as an email for specific users - Microsoft Q&A

Was this reply helpful? Yes No
HS-06020917-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @David_MA, @equals(triggerOutputs()?['body/{VersionNumber}'], '1.0') seems to have done the trick.

The reason I don't want to use the default e-mail capability that sharepoint offers is because it's very limited in what I can do with it. For starters the emails always arrive from some generic noreplaysharepoint which is not acceptable for our company. Secondly, it's always the same people the mail goes out to with the same optional message, so rather than the poster having to manually type in the same group every time and put the same optional message every time, power automate lets me do both those tasks automatically and choose the account the email comes 'from'.

Was this reply helpful? Yes No
David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@HS-06020917-0 since the trigger condition is working for you, please mark the post that answered this as answering your question, so it gets tagged as answered to close out the issue. I am glad that worked for you.

Was this reply helpful? Yes No