web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send an email using a ...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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:

 

EMAILMONTHLYEMAIL
aaa@hotmail.comYes
bbb@hotmail.comYes
ccc@hotmail.comNo

 

only aaa and bbb will receive the email.

 

Can someone help me with that?

 

Thanks!!

Categories:
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    on at

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

    2\My Flow

    1.JPG

    Filter Query:

     

    MONTHLYEMAIL eq 1

     

    Best Regards,

    Bof

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard