SharePoint Designer workflow loop through people picker
Watch this demo video of how you can use a loop in a SharePoint Designer 2013 workflow to loop through account IDs from a people picker control on an InfoPath form and create list items corresponding to those people in a SharePoint list.
In recipe 91 of InfoPath 2013 Cookbook 2, you'll learn how to use a SharePoint Designer 2013 workflow to loop through data that has been merged from a people picker control on an InfoPath form.
Get more solutions from InfoPath 2013 Cookbook 2 which is available on Amazon.com
Watch next video: Basic SharePoint user profile info using a people picker
InfoPath demo video transcript:
Here I'm in SharePoint 2013 where I've already published an InfoPath form template to this SharePoint form library, so if I add a new form, you'll see that we've got this simple form that has this people picker control on it.
The basic idea is that I'd like to enter one or more users in this people picker control, save the form back to the SharePoint form library, have a SharePoint Designer 2013 workflow kick off, and create SharePoint list items in this People SharePoint list, which as you can see is currently empty.
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. In this case we're going to be using a SharePoint Designer 2013 workflow to loop through merged data from a people picker control thereby retrieving account IDs. And for each account ID we'll be retrieving a display name and an email address from within the workflow, and then creating a list item in this People SharePoint list.
Let me show you how this works...
So I'll add a new form, and then I'll enter a couple of names here. I'll take john.doe, clovis.caralho, and jane.doe. Then I'll save the form back to the SharePoint form library. And then we'll wait here until the SharePoint Designer 2013 workflow has kicked off.
So as you can see it has kicked off. So I'll go to the People SharePoint list and wait until the items have been created. So as you can see the People SharePoint list is still empty. So I'll continue refreshing until we've got all the three items in the SharePoint list...
John Doe has been created... we've got Clovis now... and finally Jane Doe.
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
- 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
- SharePoint Designer 2013 workflow to loop through InfoPath repeating table
- 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.