web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Condition logic for tr...
Power Automate
Unanswered

Condition logic for triggered email flow based on 3 column values

(1) ShareShare
ReportReport
Posted on by 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:

 

OneWinPlease_0-1720813663114.png

OneWinPlease_1-1720813760543.png

 

OneWinPlease_2-1720813835934.png

 

OneWinPlease_3-1720814101045.png

 

 

Categories:
  • OneWinPlease Profile Picture
    155 on at

    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. 

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 414

#2
11manish Profile Picture

11manish 331 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard