Skip to main content

Notifications

Power Automate - General Discussion
Answered

Generate HTML table from Data table in Excel file

(0) ShareShare
ReportReport
Posted on by

 

 

 

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

  • Hariyali Profile Picture
    Hariyali 4 on at
    Re: Generate HTML table from Data table in Excel file

    Please provide the final flow of this query

     

  • JhonaOB365 Profile Picture
    JhonaOB365 on at
    Re: Generate HTML table from Data table in Excel file

    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

  • Verified answer
    DamoBird365 Profile Picture
    DamoBird365 8,942 on at
    Re: Generate HTML table from Data table in Excel file

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard