Trigger email when condition is met

Like (0) Share

Report

Posted on 26 Jan 2023 09:50:38 by mikechan1234

Hi everyone,

I am wondering how can i trigger email using Power Automate when a trigger condition is met.

From the list below. which is uploaded in SharePoint, the trigger condition will be if Price Difference is greater or equal to 3, and it should automatically email to the address stated in column "Customer Email"

i.e. we should email to "BCD@gmail.com"since prince difference =3

Item	Buying Price	Selling Price	Price Difference (Buying Price - Selling Price)	Customer Email
Apple	4	2	2	ABC@gmail.com
Orange	4	1	3	BCD@gmail.com

I have created the first step to use "When an item is created or modified" and created the trigger condition, can any folks here advise the next step? Thanks!!!

I have the same question (0)

All responses (3)

Answers (1)

Expiscornovus 32,891 Most Valuable Professional on 26 Jan 2023 at 10:11:07

Like (0)

Report
Re: Trigger email when condition is met

Hi @mikechan1234,

Are you using a calculated column for the Difference column? If so, how what is the returned data type, single line of text?

Btw, if you say it needs to be greater or equal to 3 I would suggest to use the greaterOrEquals function in your expression as well.

If you are returning it as string I would suggest to try:

@greaterOrEquals(triggerOutputs()?['body/Difference'], '3')

Was this reply helpful? Yes No
mikechan1234 10 on 26 Jan 2023 at 12:44:03

Like (0)

Report

Re: Trigger email when condition is met

Hi @Expiscornovus ,

Thanks for your reply!!

It should be a single line of text, as the calculation formula will be removed when exporting excel to sharepoint as a list.

But what should be the next step, should use Send an email (V2) and put Customer Email in To? The error message pop out and stop me from saving my flow

Was this reply helpful? Yes No
Verified answer

Expiscornovus 32,891 Most Valuable Professional on 26 Jan 2023 at 16:04:41

Like (0)

Report

Re: Trigger email when condition is met

Hi @mikechan1234,

Yes, it should be possible to use the Customer Email field directly in the To.

What type of field did you use for the Customer Email field? In the screenshot it looks like you used a different field called Mail Address. The error suggests that field you used is not a string but maybe of type hyperlink?

1. The flow setup

2. The Customer Email column setting

Was this reply helpful? Yes No