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
Solved! Go to Solution.
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
HI Jp
Thanks for the revert. But Spanish language is an issue😊....
Ok. Good luck!