Power Automate pulling a SharePoint List creating an HTML Table in an email

[mjfox52610]

I have a SharePoint list that is populated through a Power Apps Canvas Form, which works great.  Now I'm trying to get Power Automate to take the latest ID from my SharePoint list and email that in a Table

These are my steps.  The email is created with the table.  The problem is that through the Select step it is generating a Table for columns that are empty, which I kind of OK because if they were all full of data in the List I would need them all but it causes the Table to be very ugly.  I have 38 Columns on my List, 4 of them are repeated 5 times so if I could get them to drop to a new row that would help clean up the table.

Basically, I want something like this to give me a table like the Table below.

[abm · Accepted solution]

Hi @mjfox52610 

You can generate custom HTML table to do this. This article describes how to achieve this.

Power Automate HTML Table Styling – Ryan Maclean (ryanmaclean365.com)

Thanks

[mjfox52610]

I actually ended up having my Flow create 6 separate tables, 1 for the (Required) location information and 5 for the multiple equipment orders (1 is required).  This works well, in the email the Location and first Item tables look good, if there are no other items it just creates 4 empty tables.

213

Tables in Email Body