cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mahipundir
Helper II
Helper II

Send email if a cell value matches

Dear all, 

I'm trying to send an email based on excel sheet cell value, for example IF CELL says YES, copy that row data and send email.
I have tried using trigger FOR A SELECTED ROW and action SEND AN EMAIL which does work but I'm looking a way to email only certain row data based the cell value. Power automate.png

 

Tried checking the community but no luck, hope someone can share their knowledge. 


Many thanks 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @Mahipundir,

If you just want send an email with some certain rows, I think you could use the Get rows and send email with a HTML table.

 

Here is a flow how I configured:

vqiaqimsft_1-1648180516337.png

vqiaqimsft_2-1648180576107.png

vqiaqimsft_3-1648180588351.png

Here is the test result.

vqiaqimsft_0-1648180504444.png

Best Regards,
Qi

View solution in original post

1 REPLY 1
v-qiaqi-msft
Community Support
Community Support

Hi @Mahipundir,

If you just want send an email with some certain rows, I think you could use the Get rows and send email with a HTML table.

 

Here is a flow how I configured:

vqiaqimsft_1-1648180516337.png

vqiaqimsft_2-1648180576107.png

vqiaqimsft_3-1648180588351.png

Here is the test result.

vqiaqimsft_0-1648180504444.png

Best Regards,
Qi

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,371)