cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mjfox52610
Frequent Visitor

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

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.

mjfox52610_2-1649960361837.png

 

 

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

mjfox52610_0-1649960215334.png

 

 

mjfox52610_1-1649960215141.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

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

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

2 REPLIES 2
abm
Super User
Super User

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

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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.

 

221133

 

 

Tables in Email Body

Email.jpg

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,632)