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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (1,859)