Power Platform Community Forum Thread Details

Hi All,

I have setup a flow to send emails to relevant users when an item moves across columns in my DevoOps board. It is triggered by "When a work item is updated". It works great as items move across the board, but the issue is that every time a comment is made on an item on the board or a field changes in the item, it sends the same email notification out that I only want sent when the item is moved across columns.

I attempted to change the trigger from "When a work item is updated" to "When a work item is created" but that obviously doesn't work.

Flow:

1. When a work item is updated

2. And Board Column = "Board Column Name"

3. Send an email

Does anyone know how I can modify this to only send the email notification on an item when the board column changes, and not under any other circumstance?

Thank you

Categories:

Building flows

I figured out a resolution for this.

I created a new custom string field in DevOps to track 'Previous Board Column'.

I then created a new flow that when an item is create din DevOps it fills that 'Previous Board Column' with the initial column (in my case this column is called 'Prioritization').

I then have another flow that is triggered by "When a work item is updated". This flow gets the current work item details, including the column the item is in, plus the previous board column. I then run a condition for each column that checks the board column = column name (text). It also then checks the 'Previous Board Column' name to make sure it does not match the current board column name. if both of those are true, it sends out the email notification. Once the email is sent out, it then updates the 'Previous Board Column' to the one it is currently in.

By updating the column after the email is sent, it means that any comments or any other changes to the devops item don't trigger the emails that should only be sent when items change columns and not for any other reason, but still sends emails if the item is moved across columns.