Answered

Flow running on news posts changes status of post from posted to draft

(0) Share

Report

Posted on by webbrewers

Similar to other questions about triggering a flow when a column values changes, rather than every time an item is modified but a little different.

My flow sends an email when a news post is published ie promoted state goes from 1 to 2. To prevent another email being sent when a post is edited after publishing, the flow also changes the value of the "email sent" field to yes. Since that change puts the post back into draft mode, the flow also updates the promoted state field to = 2.

The problem is that even though the promoted state = 2, the post is still put into draft mode and needs to be reposted. It looks like no matter what I do, any change to any field while not necessarily firing the flow, will be read as a change and put the post into draft status.

Any ideas on how to workaround this?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-litu-msft on at

Like (0)

Report

Hi @webbrewers,

You could create a condition after the trigger, if the status equal to 1, do the following steps. If not, it equals to 2, do nothing.

For example:

Or you could set the trigger condition to make the trigger be fired just when the status equals to 2, there is a video about how to set it:

https://www.youtube.com/watch?v=j-gP-E6CCE4

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
webbrewers 35 on at

Like (0)

Report

Thanks - maybe I wasn't clear. I already have a condition checking the status so future edits don't send another email. The last actions update 2 fields - and one is to update the status to "2" ie repost the news. That updates the field but because Msft didn't think through the news function properly, that change sets status as "2" but also puts the post back into draft mode. Is there an action that reposts news that works properly? Obviously as in all the other questions about this. if we could do something based on a column changing rather than ANY change, this wouldn't be an issue. But we can't as far as I know. Any change triggers the flow.
Here are screenshots:

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

Hi @webbrewers,

Thank you for your response, so you want the Flow only trigger when the status column changed in the SharePoint, right?

There is a blog to introduce how to Check for a Change in a SharePoint List Column Value, hope it could help you:

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Check-for-a-Change-in-a-SharePoint-List-Column-Value/ba-p/241347

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No