cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Using Excel Table to Send Emails to Various People

Hi All,

 

The goal of this flow is to send my customers an email everyday based on the success/failure of a backup job.

1) a member of the backup crew uploads one excel sheet to Sharepoint with all of our customer's backup jobs on it.  

2) the upload triggers the flow to look through the table and send out emails to each of the various customers individually

 

Here's an example email sent to customers:

Picture: https://snipboard.io/8wJ2a5.jpg

1) The To: field is populated based on the POC column in the Excel sheet

2) The "Subject" field is populated with the same static text.  It should actually have the date on it (e.g: 10/02/20)

3) An attachment of a section of the table, relevant to the customer, is provided as an attachment

4) The section relevant to the customer is copied/pasted into the body of the email

 

I've looked through some of the tutorials and it looks like my flows are way off the mark and since I'm not very versed in programming this is proving to be more of a headscratcher than not so any help is appreciated.  Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Specialist
Solution Specialist

@davidhso04 You can use List Rows present in a table action and iterate through rows & columns to build the flow. 

Like and mark this as answer if this resolved your issue.

PrasadAthalye_0-1601817803254.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

1 REPLY 1
Highlighted
Solution Specialist
Solution Specialist

@davidhso04 You can use List Rows present in a table action and iterate through rows & columns to build the flow. 

Like and mark this as answer if this resolved your issue.

PrasadAthalye_0-1601817803254.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,793)