How to create Invoices with a variable number of items in SharePoint workflow


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, to HarePoint Workflow Extensions.

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

This article describes how to create an invoice with a variable number of items. And we will use the Update Word Document and the new Add New Row into Word Document actions from HarePoint Workflow Extensions for SharePoint:

Component name and type Workflow components used
SharePoint Workflow HarePoint Workflow Extensions
Add New Row into Word Document (Action)
Update Word Document (Action)
Set Workflow Variable (Action)

We will use an Invoice created from a Microsoft Word template.

First, lets’ remove empty rows and leave only one. Select it and click at Repeating Section Content Control in the Developer menu.

The Plus button will appear on the right to add new rows to the table. We don’t have to click it because our SharePoint workflow will do all the required actions for us.

Set up Title and Tag in the Content Control Properties.

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

Let’s start creating the Workflow that will fill the table.

Save, publish and test the Workflow to update the table in the invoice in the Word Document:

You can also watch the whole process of creating such a workflow in this video:

Learn more about HarePoint Workflow Extensions and over 300 new actions to automate any business process without programming.

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 3

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

(Visited 1,002 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *