Formatting Table within either Approvals or Outlook Emails

[rsparks]

I'm trying to feed this data from a Sharepoint list into a table in either an email or an approval:

I realise 11 is a lot of columns, and that Mens Size/Ladies Size have a fair bit of data. 

When I tried to use table formatting in an approval email, it looks like this:

Unreadable, due to what I assume is the max width of the approval window. The outlook example didn't look much better:

Only half (6 instead of 11) the columns were used in the test, and it still almost reached the edge of the email window.

I stole the formatting for the outlook HTML table from an online HTML editor. How would I go about giving the table some borders, some padding around those borders, and the equivalent of "Text Wrapping" so that cells aren't as wide? 

[v-alzhan-msft]

Hi @rsparks ,

Hope the link below about create and format HTML table could help you:

https://www.c-sharpcorner.com/article/how-to-create-and-format-html-table-using-microsoft-flow-and-s...

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rsparks]

@v-alzhan-msft I've already seen that example, but the issue is his method "get items". Meaning all of the rows in the sharepoint list are printed to the table. 

I need an example that only prints the item that triggered the flow. I don't understand why "Operations - Select" can only use "get items" as a trigger, not "get item"? 

If I try to workaround this by using "get items" as the value for the "from" in "Select" and use the outputs from "get item" as the mapped values for each column, it simply prints a table with multiple rows of the exact same data:

How can I force it to only print 1 row?  And how can I add padding where the blue line is? The data is almost overlapping it's so close.

[v-alzhan-msft · Accepted solution]

Hi @rsparks ,

The Select action would require an Array input.

You could add the filter array in your "Get items" action as my screenshot below to get only one record:

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rsparks]

@v-alzhan-msft perfect, thanks.