Send e-mail ONLY when certain condition is met!

Like (1) Share

Report

Posted on 17 Oct 2024 18:03:21 by seyoungchoi74

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:

Process Advisor

All responses (5)

Answers (0)

seyoungchoi74 17 on 17 Oct 2024 at 20:54:57

Like (0)

Report

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 66,101 Most Valuable Professional on 17 Oct 2024 at 20:03:23

Like (0)

Report
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 17 on 17 Oct 2024 at 18:51:40

Like (0)

Report

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 66,101 Most Valuable Professional on 17 Oct 2024 at 18:32:53

Like (0)

Report

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 17 on 17 Oct 2024 at 18:05:04

Like (0)

Report

Send e-mail ONLY when certain condition is met!

Sorry - I didn't realize that copy pasting images wouldn't work!