Answered

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

Like (1) Share

Report

Posted on 14 Apr 2022 18:34:43 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.

I have the same question (0)

All responses (2)

Answers (1)

mjfox52610 16 on 28 Apr 2022 at 14:53:06

Like (1)

Report

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

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
Verified answer

abm abm 32,570 Most Valuable Professional on 14 Apr 2022 at 21:12:20

Like (1)

Report

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

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