SharePoint Designer 2013 workflow to loop through InfoPath repeating table
In this InfoPath video you'll see how you can use a SharePoint Designer 2013 workflow to loop through rows of a repeating table on an InfoPath form and create SharePoint 2013 list items.
In recipe 92 of InfoPath 2013 Cookbook 2, you'll learn how to create a SharePoint Designer 2013 workflow to loop through rows of a repeating table on an InfoPath form and create items in a SharePoint list.
Get more solutions from InfoPath 2013 Cookbook 2 which is available on Amazon.com
Watch next video: Cascading multi-select list boxes with validation in InfoPath 2013
InfoPath demo video transcript:
Here I'm in SharePoint 2013 where I've got this SharePoint list, which as you can see is currently empty. I've also already published an InfoPath form template to this SharePoint form library.
This solution of InfoPath 2013 Cookbook 2 teaches you one of two techniques you can use to loop through data from an InfoPath form using the new Loop structure in SharePoint Designer 2013.
So here I'll add a new form. As you can see this form is a simple form that has a repeating table control on it, which has been prefilled with data. I'll just add one more item here, and then I'll save the form back to the SharePoint form library. Once I've done that, I'll close the form. And then I'll wait until a SharePoint Designer 2013 workflow has kicked off. So I'll continue refreshing this form library until I've seen that the workflow has kicked off.
So now that the workflow has kicked off, I'll go to the SharePoint list, and wait until the items have been created. The 6 items that were in the repeating table control on the InfoPath form. So here again I'll continue refreshing the SharePoint list until I've seen that all the items have been created...
So Apple has been created... we've got Banana... Kiwi has been created... we've got a fourth item... we need two more items... we've got a fifth item... and the last item was also created.
Note that the creation of the list items is slow on this machine, because I'm currently recording the video. But if I wasn't recording the video, then the creation of the items would have been quicker.
Related InfoPath Demo Videos:
- Create InfoPath 2013 forms through SharePoint Designer workflows
- Auto-fill InfoPath fields with Excel data in SharePoint 2013
- Bulk export selected InfoPath forms to Word documents
- SharePoint Designer workflow loop through people picker
- Autonumber InfoPath forms submitted to a SharePoint 2013 form library
- Basic SharePoint user profile info using a people picker
- Update an Excel spreadsheet when submitting an InfoPath form to SharePoint 2013
- Add validation rules to a people picker in InfoPath 2013
- Cascading multi-select list boxes with validation in InfoPath 2013
- Submit SharePoint list item to Excel workbook via InfoPath 2013
Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.