Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Suggested answer

Send e-mail ONLY when certain condition is met!

Like (1) ShareShare
ReportReport
Posted on 17 Oct 2024 18:03:21 by 17
I already know how to send an e-mail when an item is created in SharePoint. However, I ONLY want the e-mail to send if a certain condition is met for a CHOICE COLUMN. 
 
In my case, I only want the e-mail to send when the "Start Reason" column has "Academic PAM Step 2/SST" 
 
How can I accomplish this? 
 
I already tried two things:
 
 
 
1. Start with the "when an item is created" trigger, go to the settings of that trigger, add a trigger condition, and type in: @equals(triggerOutputs()?['body/StartReason/Value'],'Academic PAM Step 2/SST')



 
 
2. Start with the "when and item is created" trigger, add a "Condition" where "StartReason" is equal to "Academic PAM Step 2/SST"
 
 
Please help!!!!!

 
Categories:
  • seyoungchoi74 Profile Picture
    17 on 17 Oct 2024 at 20:54:57
    Send e-mail ONLY when certain condition is met!
    I might have found a workaround - creating two separate lists, but thank you for this! I will give it a try!
  • Suggested answer
    Pstork1 Profile Picture
    66,477 Most Valuable Professional on 17 Oct 2024 at 20:03:23
    Send e-mail ONLY when certain condition is met!
    Sorry, my Syntax was a bit off.  It should be the following:
     
    @equals(triggerBody()?['StartReason']?['Value'], 'Academic PAM Step 2/SST')
     
    Using a Filter Array action to create the logic helps then switch to Advanced view and copy and paste. just don't fill in the From.  Like this then click the advanced mode link. Delete after you copy the code.
  • seyoungchoi74 Profile Picture
    17 on 17 Oct 2024 at 18:51:40
    Send e-mail ONLY when certain condition is met!
    I just tried this, but it won't send anything. Even in test mode it acts like nothing even got triggered?
  • Suggested answer
    Pstork1 Profile Picture
    66,477 Most Valuable Professional on 17 Oct 2024 at 18:32:53
    Send e-mail ONLY when certain condition is met!
    A Trigger condition is the better way to do this, but your condition should be based on the TriggerBody instead of Trigger output.
     
    @equals(triggerBody()?['StartReason/Value'],'Academic PAM Step 2/SST')
  • seyoungchoi74 Profile Picture
    17 on 17 Oct 2024 at 18:05:04
    Send e-mail ONLY when certain condition is met!
    Sorry - I didn't realize that copy pasting images wouldn't work!

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - General Discussion

#1
stampcoin Profile Picture

stampcoin 23

#2
Pstork1 Profile Picture

Pstork1 20 Most Valuable Professional

#3
Gprior Profile Picture

Gprior 19

Overall leaderboard
Loading started