Power Platform Community Forum Thread Details

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:

General topics