cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Format data in Email

Jump to solution

Hi,

This might be repeated question but I need some inputs. I'm trying to format my list data in the workflow email.

I have 3 columns: OTD, Cust disruptions, Month-Year. I'm able to generate the report in this format:

But what i need is the below format:

I have used the Query action, For-Each and collection operations get the individual data for each field. But i'm not able to transpose this with my HTML.

Could anyone suggest how this can be done? Which field needs to be used in the For Each?

Labels: (2)
0 Kudos
Reply
3 Replies
Workflow Hero

Re: Format data in Email

Jump to solution

You would need to loop through your collection multiple times.  First time, just get the month and year.  Second time, just the OTD.  Third, just customer disruptions.  Then you will be able to build your table in the correct sequence.

 

<table>

  <tr><td>Month-Year</td><td>Sep-2015</td><td>Aug-2015</td></tr>  <-first time going through the collection

  <tr><td>OTD</td><td>60</td><td>80</td></tr>  <-second time going through the collection

  <tr><td>Customer Disruptions</td><td>6rd</td><td>5d</td></tr>  <-third time going through the collection

</table>

0 Kudos
Reply
Workflow Hero

Re: Format data in Email

Jump to solution

Thanks Jeremiah Powers

Needed bit work but your input helped. I have the desired output now.

0 Kudos
Reply
Not applicable

Re: Format data in Email

Jump to solution

Cool. Thanks for marking the answer correct!

0 Kudos
Reply