Skip to main content

Hi, I am new to Nintex and currently trying to make an email notification where it runs every end of month and consolidate list of tasks and its status.

I have been browsing around and couldnt figure out how to populate a table in the email notification body that consolidates the tasks and its status which I want to get from Sharepoint list.

 

The Sharepoint list items that i want to populate is as below

 

the Email notification body that I want to populate on

Understand that if I do as the above on the email config., it will only allows me to populate a record from an item from the list. Im trying to get all the items on the list to be populated into the table.

 

Is there any particular action that I should use in the Workflow to make it possible?

thank you in advance

 

Hi,

To achieve this solution you will need to create the html table in the workflow first and then add the final variable to the email body.

Your basic table structure

<table>
  <tr>
    <th>Company</th>
  </tr>
  <tr>
    <td>Nintex</td>
  </tr>
</table>

A multi lines of text variable will hold the table. We will call it FinalTable.

The default value for the variable sets up the headers as below:
  <tr>
    <th>Company</th>
  </tr>


As you loop through the collection for the column you add a row using a build string:
{WorkflowVariable:FinalTable}
  <tr>
    <td>{WorkflowVariable:NextCompany}</td>
  </tr>

Once you have added all the rows in your loop you add another Build string action after the loop to finalise the table

<table>

{WorkflowVariable:FinalTable}

</table>

 

You then add the finalTable variable to your email body and you will see a table in the email.

 

 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings