InfoPath With SharePoint 2013 How-To
STEVEN MANNInfoPathwithSharePoint2013HOW-TO800 East 96th Street, Indianapolis, Indiana 46240 USA
InfoPath with SharePoint 2013 How-ToCopyright 2014 by Pearson Education, Inc.All rights reserved. No part of this book shall be reproduced, stored in aretrieval system, or transmitted by any means, electronic, mechanical,photocopying, recording, or otherwise, without written permission from thepublisher. No patent liability is assumed with respect to the use of theinformation contained herein. Although every precaution has been taken inthe preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damagesresulting from the use of the information contained herein.ISBN-13: 978-0-672-33694-2ISBN-10: 0-672-33694-4Library of Congress Control Number: 2013944877Printed in the United States of AmericaFirst Printing: July 2013TrademarksExecutive EditorGreg WiegandExecutive EditorNeil RoweDevelopment EditorMark RenfrowManaging EditorSandra SchroederProject EditorSeth KerneyCopy EditorAll terms mentioned in this book that are known to be trademarks orservice marks have been appropriately capitalized. Pearson cannot attestto the accuracy of this information. Use of a term in this book should notbe regarded as affecting the validity of any trademark or service mark.Keith ClineWarning and DisclaimerProofreaderEvery effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The informationprovided is on an “as is” basis. The author(s) and the publisher shall haveneither liability nor responsibility to any person or entity with respect toany loss or damages arising from the information contained in this book orfrom the use of the CD or programs accompanying it.IndexerErika MillenKathy RuizTechnical EditorJ. Boyd NolanTeam CoordinatorBulk SalesPearson offers excellent discounts on this book when ordered in quantityfor bulk purchases or special sales. For more information, please contact:U.S. Corporate and Government or sales outside of the U.S., please contact:International Sales 1-317-581-3793international@pearsoned.comCindy TeetersBook DesignerMark ShirarCompositorBronkellaPublishing
Contents at a GlanceIntroduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1Part I: Designing Forms for SharePoint1 Use InfoPath Designer 2013 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Create a SharePoint Form with InfoPath Designer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 Use SharePoint Form Controls . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 214 Create SharePoint Form Rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 415 SharePoint Form Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 576 Create SharePoint Form Page Designs and Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 717 SharePoint List Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 818 Submit and Publish to SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89Part II: Business Solutions9 Use Data in SharePoint Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11310 Use the InfoPath Form Web Part . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15111 Using Forms in SharePoint Workflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16312 Enhance the User Experience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18313 Using Template Parts to Create Reusable Form Components . . . . . . . . . . . . . . . . . . . 203Part III: Technical Solutions14 Customize a Document Information Panel Content Type. . . . . . . . . . . . . . . . . . . . . . . . . . . 21315 Leverage Visual Studio 2012 with InfoPath . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22116 Dynamically Populate a Repeating Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22917 Track Changes in a Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24318 Autogenerate Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259Part IV: Administrative Aspects19 Use Central Administration to Administer InfoPath Forms Services . . . . . . . . . . . 26720 PowerShell . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28121 Managing Form Permissions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 293
Part V: Troubleshooting22 General Form Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30123 Resolve Deployment and Publishing Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31124 Resolve Form Submission Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 315Part VI: AppendixesA Auto-Increment Repeating Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 321B Upload File Attachments in Forms to a Document Library . . . . . . . . . . . . . . . . . . . . . . . . . 323C Add Picture Files to InfoPath . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 327Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331
Table of ContentsIntroduction1Overview of This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1How to Benefit from This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1What Is New in This Book? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2How to Continue Expanding Your Knowledge . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2Part I: Designing Forms for SharePoint1 Use InfoPath Designer 20133Why Use an InfoPath Form?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3What Does InfoPath Do for My Lists? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4Why Use InfoPath Forms in Workflows? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4How Does InfoPath Integrate with My Data? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4InfoPath Versus Web Controls and Web Parts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5What Is the InfoPath Web Part? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 Create a SharePoint Form with InfoPath Designer7Design a SharePoint Form Using the Blank Form Template . . . . . . . . . . . . . . . . . . . . . . 9Add Controls. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10Preview Your Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11Name Your Data Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12Add Submit Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13Publish Your Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15Use Your Form in SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17Create a Form Library from InfoPath . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18Design a SharePoint Form Using the SharePoint Form LibraryTemplate. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 203 Use SharePoint Form Controls21What Are Input Controls?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22What Are Object Controls? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23What Are Container Controls? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24Drag Controls on Your Form. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24Allow Users to Enter Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25Make a Text Box Read-Only . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25Make a Text Box Multiline . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
viInfoPath with SharePoint 2013 How-ToAllow Users to Select a Single Selection from a List of Items . . . . . . . . . . . . . . . . 27Allow Users to Select Multiple Items from a List of Items . . . . . . . . . . . . . . . . . . . . . . 29Allow Users to Select an Optional Single Choice . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30Allow Users to Select from Various Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31Allow Users to Enter a Date/Time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32Allow Users to Select a Person . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34Allow Users to Select from a SharePoint External Content Type . . . . . . . . . . . . . 35Allow Users to Initiate an Action . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35Show Optional Controls on Your Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37Allow Users to Enter Multiple Instances of the Same Fields . . . . . . . . . . . . . . . . . . . 37Allow Users to Choose Which Set of Fields to Use . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38Make a Control/Field Required . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 404 Create SharePoint Form Rules41Hide or Show Controls Based on a Selected Option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42Format an Entry Based on a Condition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45Implement a Validation Rule . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47Add an Action Rule to a Button . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49Use Rules for Form Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50Use Rules for Form Loading. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53Validate Data Entry Using Patterns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 545 SharePoint Form Functions57Use the SharePoint URL Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58Calculate a Future Date. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59Get the Current SharePoint User . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60Remove Leading and Trailing Spaces from a Field Value. . . . . . . . . . . . . . . . . . . . . . . . 63Remove All Spaces from an Entry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63Default a Blank Amount to Zero . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64Calculate the Sum of All Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65Determine a Count of the Items Entered . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67Obtain a Portion of an Entered String . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68Obtain the Username from SharePoint Online (Office 365) . . . . . . . . . . . . . . . . . . . . 69Add Years to a Date Preserving the Month and Day . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 706 Create SharePoint Form Page Designs and Views71Change the Current View Name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72Create a New View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73Change the Default View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74Make a View Read-Only . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75Prevent a User from Selecting a View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75
ContentsviiUse a View for Printing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77Use a Different Layout for Your Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77Use a Theme for Your Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78Add Headers/Footers to Your Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79Insert a Table Layout into Your Form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80Modify a Table Layout in Your Form. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 807 SharePoint List Forms81Use a Form to Create a SharePoint List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82Modify the Form of an Existing SharePoint List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86Set Your List Form Template Back to the Default Form. . . . . . . . . . . . . . . . . . . . . . . . . . 878 Submit and Publish to SharePoint89Enable Your Form for Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90Configure Email Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91Publish Your Form to Email. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93Configure SharePoint Library Submission. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96Publish Your Form to a SharePoint Library . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97Use Multiple Forms in SharePoint Libraries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101Configure Web Service Submission . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105Configure SharePoint Server Connection Submission . . . . . . . . . . . . . . . . . . . . . . . . . . 107Modify the Available Menu Buttons During Form Submission . . . . . . . . . . . . . . . 110Part II: Business Solutions9 Use Data in SharePoint Forms113Use Data From a Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114Convert an InfoPath Connection to a SharePoint Connection File. . . . . . . . . . 119Use Data From a SharePoint List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121Use Data From a SharePoint Data Connection File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123Use Data from a (SOAP) Web Service . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124Populate a Drop-Down List with Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126Populate a Drop-Down List with Data Based on Another Selection(Cascading Drop-Down) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
800 East 96th Street, Indianapolis, Indiana 46240 USA STEVEN MANN InfoPath with SharePoint 2013 HOW-TO Infopath.indb i 7/12/13 9:53 AM
forms technology across SharePoint, Access and Word. This means that InfoPath 2013 is the last release of the desktop application and InfoPath Forms Services in SharePoint Server 2013 is the last release of InfoPath Forms Services. The InfoPath Forms Services technology within Office 365 will be maintained and it will function until further notice.
Developers do not like InfoPath Microsoft recently announced that InfoPath will be going away after SP 2013 Microsoft did not say what they will be replacing it with, but they promised to have a migration tool. InfoPath is used a lot 5/13/2014 SharePoint & InfoPath - Marcel Meth 6
InfoPath 2013 itself can continue to be used for the higher SharePoint versions until 2026. Users can continue to use InfoPath for XML documents, ECM and offline scenarios. Ever since then, Microsoft has been trying to sway away the SharePoint users from InfoPath, but in vain, due to the absence of any reliable alternative to it.
Both use the XmlFormView web part to display the InfoPath form rendered as HTML using Microsoft InfoPath Forms server. This web part is located in Microsoft.Office.InfoPath.Server.dll, and this web part must first be installed in a site. In this walkthrough the SharePoint site in which the document library and web part page will be created is
800 East 96th Street, Indianapolis, Indiana 46240 USA STEVEN MANN InfoPath with SharePoint 2013 HOW-TO Infopath.indb i 7/12/13 9:53 AM
3.3.7 InfoPath files are converted using an old version of the XSN template 39 Appendix - Using InfoPath with External Data Sources 40 Details for InfoPath 2007 40 Details for InfoPath 2010 & 2013 42 Digitally signing forms 42 Using Muhimbi’s ‘AutoTrustForms’ feature 42 Appendix –
Administration Guide For SharePoint 2019, SharePoint 2016, SharePoint Server 2013, SharePoint Foundation 2013, SharePoint Server 2010, SharePoint Foundation 2010 This manual has been produced by MAPILab and contains information essential for the successful installation of HarePoint HelpDesk for SharePoint on your computer. Product version 16.7 .
I can g writing. s L.K.6 Title: I can statements reading K Author: 4750060513 Created Date: 12/10/2014 2:14:46 PM
