Sending an email via Power Automate when a news post is created

[Dickie1305]

Hi all,

Having some trouble with an existing Power Automate flow.

The flow is an automated cloud flow which sends an email to a specific group of users from a SharePoint list when a new news

post has been posted for their attention on my SharePoint communications site. 

The flow runs perfectly fine when I create a news post and post this straight away, but the flow does not trigger when I schedule a new

post to be posted at a later time or date. 

I believe this is due to the “promoted state”

of the news post but looking for some help please.

Thanks

Richard

[#2]

@Dickie1305 what trigger are you using? If it's the when a file is created or modified (properties only) then it will trigger whatever the Promoted State of the news post is. For your info there are 3 possible promoted state values: 0 for a site page, 1 for a draft/scheduled news post and 2 for a published news post:

A screenshot of your flow might help us to work out what is causing the behaviour you are experiencing.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

[#3]

Hi @Rob_Elliott, 

The trigger I'm using is when an item is created or modified (below)

There are also a couple of conditions we've introduced, such as checking if the item is already published:

AND

Checking that page details contains a Front Door ID (from our front door for communications requests) and that Send requestor notification and Send audience notification  are set to "Yes" and that the Promoted state is at "2".

It's this promoted state which I think is tripping me up as until the scheduled article is published, it appears as "1" so the flow runs and fails because all the other conditions (front door ID, requestor and audience notifications) are correct, except the promoted state which at the time the flow runs, is set to "1" until the item is published, when it changes to "2". But at that time the flow has already ran and doesn't run again. 

Any ideas would be appreciated. 

Thanks 

[#4]

@Dickie1305 there is clearly a bug somewhere when a scheduled news post goes to published. In my tests today it appears that Power Automate is not picking up that the Promoted State or First Published Date have changed and it's not even consistently picking up that the Modified column has changed.

I'll do some more testing and hopefully come up with a solution.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

[#5]

Thanks @Rob_Elliott

Appreciate you looking into this. 

Richard

[#6]

Hi @Rob_Elliott 

Just wondered if you had been able to uncover anything new that might help?

Thanks