Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

How to create an email notification when new item is added (from Sharepoint list) if in any column entered data is "NO"?

(0) ShareShare
ReportReport
Posted on by

Hello!

How to create an email notification when new item is added (from Sharepoint list) if in any column entered data is "NO"?

I have a list with questions. I need to create a notification to my email, if someone answered "No".

Please help me to create such flow. 

I find good template which Sends a customized email when a new SharePoint list item is added, but it sends email when every item is created. I need to create a flow only when employees select "NO". flow.PNG

  • Community Power Platform Member Profile Picture
    on at
    Re: How to create an email notification when new item is added (from Sharepoint list) if in any column entered data is "NO"?

    @yashag2255 Done, thank you! I created a flow with conditions. But now i want to ask you how to create correct Email Body 

    I understand how to create a body with full lists of Questions and answers, but how to create body where i will see only Questions with "No" answers? 

    As i understand i need to have html code with conditions?

    Can you please give an example with correct code? 

    For example I have 3 questions: q1.value, q2.value, q3.value. 

    If Q1.Value = "NO" than show Q1 question and Q1.value and etc. 

     

    How to create correct code in the body?

  • Community Power Platform Member Profile Picture
    on at
    Re: How to create an email notification when new item is added (from Sharepoint list) if in any column entered data is "NO"?

    Hi @yashag2255 , If you present me an instruction how to do this, that will be great. 

    (Or screenshot of flow)

  • yashag2255 Profile Picture
    24,442 Super User 2024 Season 1 on at
    Re: How to create an email notification when new item is added (from Sharepoint list) if in any column entered data is "NO"?

    Hi @Anonymous 

     

    You can add a condition branch after the trigger to check if the column value was no and then add the send email action in the yes branch of the condition. 

     

    Hope this helps!

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492