cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JhonatanOB1993
Helper II
Helper II

Generate HTML table from Data table in Excel file

 

 

 

Good evening, everyone.

Please, Could you help me with the following question?

From Monday to Friday, I have a new data table with the similar structure (I attacht an example image about it).

I would like to generate a HTML table and insert it to an email body and next send it to each provider (I attacht an example image, also).
The HTML table will be generated from filter every "Provider Code" on the table in excel file.

Is posible make that flow and can automate its?

Thank you very much in advance.

Greetings,

Jhonatan Ora

 

 

 

DataTable

DataTable.PNG

Example HTML table with Code_01

Code_01.PNG

Example HTML table with Code_03

Code_03.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Microsoft
Microsoft

Hi @JhonatanOB1993 

 

In my example I have used an excel data source but you could use a list or CDS.  You need to filter an array based on the body of your data source and then use the create HTML action.

 

DamoBird365_0-1616319015139.png

You can then include the HTML Table in your Send Email Action.

 

If you are performing this action on multiple suppliers, you could consider using a config table with a list of supplier names and emails.  You could trigger the flow using a schedule and then retrieve the list of suppliers and emails.  You can then use an apply to each on the list of suppliers and apply the above steps so that the single flow will deal with all existing (and new as you dd them to the list) suppliers.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

View solution in original post

3 REPLIES 3
DamoBird365
Microsoft
Microsoft

Hi @JhonatanOB1993 

 

In my example I have used an excel data source but you could use a list or CDS.  You need to filter an array based on the body of your data source and then use the create HTML action.

 

DamoBird365_0-1616319015139.png

You can then include the HTML Table in your Send Email Action.

 

If you are performing this action on multiple suppliers, you could consider using a config table with a list of supplier names and emails.  You could trigger the flow using a schedule and then retrieve the list of suppliers and emails.  You can then use an apply to each on the list of suppliers and apply the above steps so that the single flow will deal with all existing (and new as you dd them to the list) suppliers.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

Good morning, @DamoBird365 

 

Thanks for your answer, It helped me with a good idea and I could run the flow.

 

Have a good Sunday.

 

Regards,

 

Jhonatan Ora

Hariyali
Regular Visitor

Please provide the final flow of this query

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,288)