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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel: Send Email When...
Power Automate
Unanswered

Excel: Send Email When Status Cell Value = Open in multiple rows, include all the rows in the email

(0) ShareShare
ReportReport
Posted on by

I have an Excel Sheet with 20+ Columns and 50+=Rows. One Column is titled status. Where the Cell entry is Open in the status column, I want to send an email with all the rows that have a status of Open. I don't want to email all the Columns maybe 5 or 6. 

I have tried many different methods but either just get the first row with a status of Open or a separate email for each Status open row.

 

Alternatively, if anyone can advise how I can move all Rows with a Status Cell Value = Open to a different worksheet that would be a help.

 

Thanks

Pat

 

Categories:
I have the same question (0)
  • PowerDeveloperTP Profile Picture
    453 on at

    Hello,

     

    could you please let me know where is this excel stored?

     

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 791

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 535

Last 30 days Overall leaderboard