web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Creating flow to filte...

Power Automate

Answered

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

(1) Share

Report

Report

Posted on by Prasanth2021

14

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

Categories:

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

JuanPJesusG 49 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

I think your flow should be something like this.

.
.
.
.
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>')

.
I hope this could work.
Sorry for the spanish language in the connectors and formulas.

Regards
JP
Prasanth2021 14 on at

Like
a
(0)

Report
Copy link

Link copied!

HI Jp

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

JuanPJesusG 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok. Good luck!

Join the conversation