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
 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 (2,816)