Condition logic for triggered email flow based on 3 column values

(1) Share

Report

Posted on by OneWinPlease

155

Hoping for help since I can't figure it out. This is attached to a sharepoint list. There are 3 conditions. The triggered email runs inconsistently: sometimes it does when I add the Assigned To name to the field, and sometimes it runs when I remove the name from the field.
The goal is to send an email when:

The value of the request type is "Other"
Get changes for the Item using Trigger Window start and end tokens
Check that the Assigned To column has changed AND the Assigned To field is not empty
Send an email if both those things are true

The reason for the Not Empty part is because it was triggering when a new item was created. We only want this to go when somebody has manually been assigned to a ticket. Edited to add: I'd like the flow to run anytime the Assigned To column is modified. Maybe I don't need start and end tokens?

Here's my flow build:

All responses (1)

Answers (0)

OneWinPlease 155 on at

Like (0)

Report
Re: Condition logic for triggered email flow based on 3 column values

It turns out this was overcomplicated. I simplified it as follows and so far seems good:
The value of the request type is "Other"
Get changes for Item just using Trigger Window start token (end token not needed)
Has the column called Assigned To column is equal to true (no need to check whether empty)
If yes, send the email.