Answered

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

(1) Share

Report

Posted on by 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.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
mjfox52610 16 on at

Like (1)

Report

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

Was this reply helpful? Yes No