Send e-mail ONLY when certain condition is met!

(1) Share

Report

Posted on 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:

General topics

I have the same question (0)

All responses (5)

Answers (0)

seyoungchoi74 17 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

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')

Was this reply helpful? Yes No
seyoungchoi74 17 on at

Like (0)

Report

I just tried this, but it won't send anything. Even in test mode it acts like nothing even got triggered?

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report
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.

Was this reply helpful? Yes No
seyoungchoi74 17 on at

Like (0)

Report

I might have found a workaround - creating two separate lists, but thank you for this! I will give it a try!

Was this reply helpful? Yes No