Formatting Table within either Approvals or Outlook Emails

(0) Share

Report

Posted on by rsparks

241

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:

approval gimped.PNG max width.PNG

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?

All responses (4)

Answers (1)

rsparks 241 on at

Like (0)

Report

Re: Formatting Table within either Approvals or Outlook Emails

@v-alzhan-msft perfect, thanks.
Verified answer

v-alzhan-msft on at

Like (1)

Report

Re: Formatting Table within either Approvals or Outlook Emails

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 241 on at

Like (0)

Report

Re: Formatting Table within either Approvals or Outlook Emails

@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 on at

Like (0)

Report

Re: Formatting Table within either Approvals or Outlook Emails

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-sharepoint-online/

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.