Auto-fill InfoPath fields with Excel data in SharePoint 2013
In this InfoPath video you'll see how you can retrieve data that is stored in an Excel workbook that is located in a SharePoint document library to fill a drop-down list box on an InfoPath browser form with data.
In recipe 109 of InfoPath 2013 Cookbook 2, you'll learn how to dynamically auto-populate fields on an InfoPath form with data from an Excel workbook that is stored in a SharePoint document library in SharePoint 2013.
Get more solutions from InfoPath 2013 Cookbook 2 which is available on Amazon.com
Watch next video: SharePoint Designer 2013 workflow to loop through InfoPath repeating table
InfoPath demo video transcript:
Here I'm in SharePoint 2013, where I've got this OfficeApplications Excel workbook that contains the names and colors of Office applications. The basic idea is that I would like to retrieve this data from the Excel workbook and display it on an InfoPath form.
I've already published an InfoPath form template to this SharePoint form library, so if I click new document to add a new form, you'll see that the drop-down list box will be empty. First I have to click this Get Office Applications button to retrieve the list of Office applications names and populate the drop-down list box with them. Then I can go ahead and select an item, then its color will be retrieved and displayed in this text box. I can select InfoPath and you'll see that Purple will be retrieved.
The beauty of this solution is that you can change the Excel workbook, the data in it, without having to update the InfoPath form template and republish it. So I'll go ahead and change Access and make it Yellow. And then I'll save the Excel workbook back to SharePoint. Once it has been saved, I'll go back to my form, and then select Access again, and then we should see Yellow appear instead of Red. And we do.
Related InfoPath Demo Videos:
- Create InfoPath 2013 forms through SharePoint Designer workflows
- 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
- 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.