Unanswered

Generate HTML table from Data table in Excel file

(0) Share

Report

Posted on by JhonaOB365

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

Example HTML table with Code_01

Example HTML table with Code_03

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (3)

Report

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.

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

Was this reply helpful? Yes No
JhonaOB365 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Hariyali 4 on at

Like (0)

Report

Please provide the final flow of this query

Was this reply helpful? Yes No