Help with formatting output from a CSV Table Action

[martinav]

I am happy to have found a great way to put together a table of multiple results in a Flow action.  However, I wish to display this in an email in a format that is much more friendly that comma delimited.  I would love to find a nice way to space the results like tabs, etc.  I have toyed with some HTML to setup tabs, but I was not successful.  Here is my table:

The Send Eamil action (HTML) Looks like this:

ECR,Description,Part_Number,Revision,Submitted_By,Pending_Days

ECR.1220,ADJUSTMENT SCREW ASSEMBLY,205049,0,Michael,192.890476476225

ECR.1221,SPRING BLOCK GUIDE,204690,2,Michael,189.780913044224

ECR.19005,ADJUSTMENT SCREW ASSEMBLY,205030,3,Michael,40.0900076462245

What I want it to look like: (it can vary a bit, i'm flexible...)

ECR              Description                                       Part_Number  Revision    Submitted_By    Pending_Days

ECR.1220      ADJUSTMENT SCREW ASSEMBLY    205049           0               Michael              192.890476476225

ECR.1221      SPRING BLOCK GUIDE                     204690           2                Michael              189.780913044224

ECR.19005    ADJUSTMENT SCREW ASSEMBLY    205030           3                Michael              40.0900076462245

Thank you.

[martinav · Accepted solution]

Wow... a quick fix... use Create HTML Table...

Makes output like this:

ECR	Description	Part_Number	Revision	Submitted_By	Pending_Days
ECR.1220	ADJUSTMENT SCREW ASSEMBLY	205049	0	Michael	192.909383534834
ECR.1221	SPRING BLOCK GUIDE	204690	2	Michael	189.799820102834
ECR.19005	ADJUSTMENT SCREW ASSEMBLY	205030	3	Michael	40.1089147048343

I'm quite happy with that!

[AlanPs1 · Accepted solution]

Hi @martinav , thank you for posting this.

Maybe a good starting point could be this post and this blog

Forgetting all the Graph Calls etc, as we go down the page you will see I have used an HTML table and some css in the body of an email to format the table. Make sure the HTML aspect of the email is enabled (as I'm sure you have it like that already) and then use css to style the table.

In my example the table looks like this:

This is acheive with css to style the table like the following code that provides padding & rge greay header:

<style>
         table {
         border-collapse: collapse;
         width: 100%;
         text-align: center;
         }
         td, th {
         border: 1px solid #ddd;
         padding: 4px;
         }
         th {
         padding-top: 8px;
         padding-bottom: 8px;
         background-color: #7F7D7E;
         color: white;
         font-weight: normal;
         }
      </style>

You could just as easily use the below for a neatly spaced table with no border or background colour.

<style>
         table {
         border-collapse: collapse;
         width: 100%;
         text-align: center;
         }
         td, th {
         padding: 4px;
         }
         th {
         padding-top: 8px;
         padding-bottom: 8px;
         color: white;
         font-weight: normal;
         }
      </style>

All the code I have used is in the blog so I think if you look below step 4 and keep going you will get what you acheive.

Hope this helps!

Alan

[AlanPs1]

Hi @martinav 

Looks like some cross posting there in the time it took me to type that up.

Although, some ways to style the table are now presented should you wish too.

I know you said you were happy with the result so in simple terms, HTML table all the way in an email.

[martinav]

Sweet!!  I will look into what you shared.  I hope you dont think of it as wasting your time.  I more elegant solution for sure.  I am very lacking in HTML stuff... I'm just smart enough to put in a <p> at the end of my lines to force a carriage return.  

I will revisit this later.  your formatting is quite nice!

Thanks so much!

Rod

[AlanPs1]

Hi @martinav 

Not at all Martin, totally happy you found a method that suits you. Now also, you know of an enhanced method to boot, so feel free to get back in touch on the HTML / CSS front should you require anything more enhanced than the above.

I've seen me pop in links to style sheets like the following to cut down the code and pop the .css file on the web somewhere. Assuming Outlook or your mail client can handle it, that is!

<link rel="stylesheet" type="text/css" href="css/stylesheet.css" />

Either way all good. I think there are 2 solutions in this thread, hence you have marked tham as so! A good one for users to refer back to in the future I guess.

Best Wishes, 

Alan