Send an email using a Sharepoint List and a YES/NO column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I've been trying to build a flow that send an email to all the emails on a Sharepoint List, but using a YES/NO column as condition to send the email, but no success.

Example:

EMAIL	MONTHLYEMAIL
aaa@hotmail.com	Yes
bbb@hotmail.com	Yes
ccc@hotmail.com	No

only aaa and bbb will receive the email.

Can someone help me with that?

Thanks!!

Categories:

Building flows

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :

Could you tell me what EMAIL's data type is?

I assum EMAIL is a single line of text column.I've made a test for your reference:

1\My data source

2\My Flow

Filter Query:

MONTHLYEMAIL eq 1

Best Regards,

Bof