Forum Discussion
Sending an email via Power Automate when a news post is created
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 ...
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 
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)