cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
colken
Frequent Visitor

excel auto email

Hello, this is my first attempt to power automate anything, so thanks in advance for your help.

 

I would like to send an email to the address previously listed in the same row if "yes" is typed in another excel column. I would also like a separate email to be sent to another address if it is added to the row.

 

I started with the "Send an Office 365 email to selected contacts in an Excel table" template, but have quickly gotten lost.

1 ACCEPTED SOLUTION

Accepted Solutions
CollabTechie
Responsive Resident
Responsive Resident

Hi @colken ,
You would do something similar to what I've done in SharePoint below.

  • List rows
  • Add condition -> [ColumnName] is equal to Yes
  • Yes -> Send an e-mail -> To: [ColumnName] and add CC address

cap1.PNG

 

Hope this helps!

 

---------------------------------------------------------
If this was useful, please give a thumbs up or accept as solution

View solution in original post

4 REPLIES 4
CollabTechie
Responsive Resident
Responsive Resident

Hi @colken ,
You would do something similar to what I've done in SharePoint below.

  • List rows
  • Add condition -> [ColumnName] is equal to Yes
  • Yes -> Send an e-mail -> To: [ColumnName] and add CC address

cap1.PNG

 

Hope this helps!

 

---------------------------------------------------------
If this was useful, please give a thumbs up or accept as solution

View solution in original post

v-litu-msft
Community Support
Community Support

Hi @colken,

 

So what the issue during you use the "Send an Office 365 email to selected contacts in an Excel table" template?

Couldn't you find the email address in the excel table?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you, this did help!

Hi @CollabTechie,

I was able to set this up as you suggested, but nothing happens when "yes" is added in the appropriate cell. Is Sharepoint needed to complete this task? 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,410)