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

Creating flow to filter an excel file and send a mail with HTML Body

HI

Request to support in creating a flow for an excel file in Onedrive folder.

 

Excel data contains as below

 

Customer Name          Sales       Manager Name             Manager email ID

ABC                           $1000         Ronaldo                        xcadf@gmail.com

BCD                            $500          Ronaldo                        xcadf@gmail.com

EDF                             $700          Christin                         chri@gmail.com

HIF                              $100          Christin                         chri@gmail.com

 

Requirement is > Filter the Data based on Manager name and send the details of Customer/Sale to respective Manager's mail ID

Data should be pasted as excel table or HTML Table in body of the mail.

 

kindly help in creating the flow

 

regards

 

Prasanth

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JuanPJesusG
Frequent Visitor

3 REPLIES 3
JuanPJesusG
Frequent Visitor

Hi,

 

I think your flow should be something like this.

 

JuanPierre_0-1626648051867.png

 

.

JuanPierre_2-1626648113522.png

.

JuanPierre_3-1626648141652.png

.

JuanPierre_4-1626648171006.png

.

JuanPierre_5-1626648193830.png

This is my code to format my table (html):

concat('<!DOCTYPE  html><body><style>Table {font-family: Arial, Helvetica, sans-serif; background-color: #EEEEEE; border-collapse: collapse; width: 100%;} Table td, Table th {border: 1px solid #ddd; padding: 3px 3px;} Table th {font-size: 15px; font-weight: bold; padding-top: 12px; padding-bottom: 12px; text-align: left; background-color: #1D33AD; color: white;}</style><h1><a name="bookmark0">Sales Report</a></h1><p><strong>Pendientes (',length(body('Filtrar_matriz')),')</strong></p><p></p>',body('Crear_tabla_HTML'),'</body></html>')

 

JuanPierre_6-1626648219095.png

.

I hope this could work.

Sorry for the spanish language in the connectors and formulas.

 

Regards

JP

 

HI Jp

 

Thanks for the revert. But Spanish language is an issue😊....

JuanPJesusG
Frequent Visitor

Ok. Good luck!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,613)