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.
Solved! Go to Solution.
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.
Tables in Email Body
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!