Solved: Creating flow to filter an excel file and send a m...

Prasanth2021 · ‎07-17-2021

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

JuanPJesusG · ‎07-22-2021

Ok. Good luck!

View solution in original post

JuanPJesusG · ‎07-18-2021

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 · ‎07-21-2021

HI Jp

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

JuanPJesusG · ‎07-22-2021

Ok. Good luck!

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

Helpful resources

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Register for a Free Workshop