{"id":295,"date":"2013-07-18T16:28:16","date_gmt":"2013-07-18T16:28:16","guid":{"rendered":"https:\/\/www.harepoint.com\/Blog\/?p=295"},"modified":"2022-07-15T13:55:55","modified_gmt":"2022-07-15T13:55:55","slug":"sharepoint-workflow-repeating-content","status":"publish","type":"post","link":"https:\/\/www.harepoint.com\/Blog\/sharepoint-workflow-repeating-content\/","title":{"rendered":"How to create Invoices with a variable number of items in SharePoint workflow"},"content":{"rendered":"\n

HarePoint was asked whether it is possible to create an invoice with a variable number of rows in a table. So we have added new workflow action, Add New Row into Word Document<\/b>, to HarePoint Workflow Extensions.<\/p>\n

This new action can add a copy of the last row in the Repeating Section Content Control<\/b>. Then this new row can be edited with the Update Word Document<\/b> action. Note that Repeating Section Content Control<\/b> was introduced in Microsoft Word 2013.<\/p>\n

This article describes how to create an invoice with a variable number of items. And we will use the Update Word Document<\/b> and the new Add New Row into Word Document<\/b> actions from HarePoint Workflow Extensions for SharePoint:<\/p>\n\n\t\n\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t
Component name and type<\/b><\/td>\n\t\t\tWorkflow components used<\/b><\/td>\n\t\t<\/tr>\n\t\t
SharePoint Workflow<\/b><\/td>\n\t\t\tHarePoint Workflow Extensions<\/b><\/td>\n\t\t<\/tr>\n\t\t
Add New Row into Word Document (Action)<\/td>\n\t\t\t<\/td>\n\t\t\t<\/td>\n\t\t<\/tr>\n\t\t
Update Word Document (Action)<\/td>\n\t\t\t<\/td>\n\t\t\t<\/td>\n\t\t<\/tr>\n\t\t
Set Workflow Variable (Action)<\/td>\n\t\t\t<\/td>\n\t\t\t<\/td>\n\t\t<\/tr>\n\t<\/tbody>\n<\/table>\n

We will use an Invoice created from a Microsoft Word template<\/a>.<\/p>\n

<\/p>\n

First, remove empty rows and leave only one. Select it and click Repeating Section Content Control in the Developer menu.<\/p>\n

<\/p>\n

The Plus<\/i> button will appear on the right to add new rows to the table. We do not have to click it because our SharePoint workflow will do all the required actions for us.<\/p>\n

<\/p>\n

Set up Title and Tag in the Content Control Properties.<\/p>\n

<\/p>\n

Next add a Plain Text Content Control<\/b> to each cell and give them unique names. They will hold the required data. The table should look like this:<\/p>\n

<\/p>\n

Let’s start creating the Workflow that will fill the table.<\/p>\n

Use the Update Word Document<\/b> action to set values of each content controls. Note that for the content controls from the repeating section you need to choose \u201clast occurrence (repeating content control)\u201d option in the workflow action. For regular content controls (outside the repeating section), use \u201call occurrences\u201d option. Make sure you have the latest version of HarePoint Workflow Extensions<\/a> for these options to be available.<\/p>\n

<\/p>\n

Save, publish and test the Workflow to update the table in the invoice in the Word Document:<\/p>\n

<\/p>\n

You can also watch the whole process of creating such a workflow in this video:<\/b><\/p>\n