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

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Trigger an email to us...
Power Automate
Unanswered

Trigger an email to user email id by reading Excel file, if status task status "No"

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Im new to flow and trying few automate tasks. Right now Im checking how to read excel file using flow and trigger an email to user email id mentioned beside task status, if row status says "NO" and not trigger email if row status says "YES"

 

Task          Status           Email

Task1         YES               testuser1@email.com

Task2          NO               testuser2@email.com

 

 

Categories:
I have the same question (0)
  • manuelstgomes Profile Picture
    6,625 on at

    Hi @ganesh815 

     

    Super easy. Let me walk you through the steps.

    1. The data below should be in a named Excel table. Otherwise, you won't be able to access the data.
    2. Then use a trigger that makes sense. You can use Scheduled or Manual, but not Automatic since there are no Excel triggers for that.
    3. Read the data. For that, you need to fetch the whole data and cycle through it.
    4. Add an if to filter out the results and send an email.
    5. Below you can find the Flow and attached the Excel example.

    Screenshot 2020-02-25 at 09.52.16.png

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.
    ​
    Cheers
    Manuel

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…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard