Question

Nintex SharePoint : How to populate table that displays items from sharepoint list in Email Notification body?

  • 1 March 2023
  • 1 reply
  • 60 views

Badge

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

 


1 reply

Userlevel 5
Badge +20

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