Recent from talks
Nothing was collected or created yet.
Microsoft InfoPath
View on Wikipedia| Microsoft InfoPath | |
|---|---|
Screenshot of Microsoft InfoPath 2013 running on Windows 7 | |
| Developer | Microsoft |
| Final release | 2013 (15.0.4805.1000)[1]
/ May 3, 2016 |
| Operating system | Windows Vista and later |
| Successor | Microsoft Forms |
| Type | Collaborative software |
| License | Trialware |
| Website | www |
Microsoft InfoPath is a discontinued software application for designing, distributing, filling and submitting electronic forms containing structured data. Microsoft initially released InfoPath as part of the Microsoft Office 2003 family. The product features a WYSIWYG form designer in which the various controls (e.g. text box, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields.
InfoPath 2013 became available for the first time as a freestanding download on September 1, 2015, when Microsoft made it available in its Download Center. However, unlike previous versions of InfoPath, the standalone version of InfoPath 2013 requires an active ProPlus subscription to Office 365.[2] The current version of InfoPath 2013 (15.0.4733.1000) is designed to be an optional component to the Office suite of applications for users that need it. Its indirect successor is Microsoft Forms, which is free to anyone with a Microsoft Account.
Features
[edit]In order to use InfoPath to fill in a form, a designer must develop an InfoPath template first. According to Jean Paoli and John Godel, two of its developers, a key architectural design decision was "to adhere to the XML paradigm of separating the data in a document from the formatting."[3] A patent filed in 2000 by Adriana Neagu and Jean Paoli describes the technology as "authoring XML using DHTML views and XSLT."[4]
All the data stored in InfoPath forms are stored in an XML format, which is referred to as the "data source". The form template must have one primary data source for submitting data and can have multiple secondary data sources for retrieving data into the form. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service. The files of the InfoPath form template are saved as an archive in the cabinet file format with the file name extension xsn.[5]
InfoPath provides several controls (e.g. textbox, radio button, checkbox) to present data in the data source to end-users. For data tables and secondary data sources, "Repeating Table" and other repeating controls are introduced. Template parts and ActiveX controls can also be added as custom controls in the designer.
For each of these controls, actions (called "rules") can be bound in. Rules come in three types: formatting rules such as hiding or coloring a control, validation rules (e.g. allow only a nine-digit number), and action rules such as setting a field's value based on other fields. Rules can be triggered either by a user action such as clicking a button or by the evaluation of various conditions such as field values. For example, a conditional rule could be: "Set field 'Total' to 100 when field 'field1' is not blank".
Paradigm
[edit]- Rules apply specific actions when triggered by button clicks or changing values in the form. They can change the values of fields in the data source, submit to and query databases, display messages, open and close forms, and switch to different views of the form.
- Data validation tests the validity of input into fields by comparing the input to patterns, checking for the correct data type (such as a string or an integer), and in other customizable ways.
- Conditional formatting can be used to change the appearance or visibility of objects based on values in the form.
- InfoPath has many different ActiveX Controls, all of which have a value bound to a field in the form's data source. Common controls include list boxes, radio buttons, text boxes, buttons, and check boxes. Info Path also uses controls such as Calculated Values, which display the result of xPath expressions, and sections, which are containers for other controls. InfoPath also includes repeating fields and sections, which can store many different values.
- XPath expressions and functions can be used to calculate values by applying functions to the value of fields in the form, such as "
concat(string(field1 + field2), "#;", field3)" (the concatenation of the sum of two fields, the string "#;", and the value of another field). XPath functions for manipulation of strings, simple mathematical operations, and many other operations are included in InfoPath. In addition, data can be filtered (select individual values from a repeating field or database). - InfoPath supports connections to external datasources. SQL, Microsoft Access, and SharePoint databases can be connected to and submitted in the form.
- JScript, Visual Basic, C#, and other languages can be used to extend InfoPath's capabilities by adding custom HTML taskpanes, iterating through data, using Active Directory, and generally accomplishing tasks that are impossible in the InfoPath design environment. The language support is facilitated by Visual Studio, although a specific version of Visual Studio is required to use with each version of InfoPath.
- SharePoint integration (see Integration with SharePoint).
- User roles can customize a user's experience by changing views or using conditional formatting based on the identity of the user.
- InfoPath's formatting capabilities and user interface are similar to Microsoft Word 2003 and 2010, depending on version.
Usage
[edit]InfoPath is used to create forms to capture information and save the contents as a file on a PC or on a web server when hosted on SharePoint. InfoPath can be used to access and display data from divergent sources (web services, XML, databases, other forms) and have rich interactive behaviors based on Rules, Conditions and Actions. An InfoPath form requires the client to have InfoPath Filler or InfoPath Designer installed, or by viewing the form in a browser when hosted on SharePoint. InfoPath is mostly used in business rather than by individuals, as it is a collaboration tool used to gather data from multiple individuals in a structured method, and to deploy requires either a SharePoint host and/or individual licensed Filler copies. InfoPath forms can be viewed on mobile devices if viewed from a browser (hosted on SharePoint) or by using a third-party product.
To run as a Web browser form, the file needs to be uploaded to a server running InfoPath Forms Services. The advantage of this is the client doesn't need InfoPath, just a Web browser. The form can then be set up to be e-mailed when completed or its fields can be added directly to a SharePoint list.
Integration with SharePoint
[edit]One common use of InfoPath is to integrate it with Microsoft SharePoint technology. InfoPath forms can submit to SharePoint lists and libraries, and submitted instances can be opened from SharePoint using InfoPath Filler or third-party products. Alternatively InfoPath Forms Services enables a browser-enabled InfoPath form to be hosted on a SharePoint installation and rendered as an HTML page with client-side script and post back behaviors similar to an ASP.NET page.
In SharePoint, a "Form Library" is a document library having an InfoPath template as the designated document type. InfoPath fields can be promoted when publishing to SharePoint so they can be read and displayed as a "Column" data in a library View. As with other SharePoint documents, InfoPath forms can have workflows associated with them that can access the promoted fields.[6]
Support
[edit]On January 31, 2014, Microsoft announced that InfoPath was discontinued and will be replaced by a more cross-platform solution called PowerApps, released in late 2016.[7] On March 1, 2016, Microsoft announced that the InfoPath 2013 client application will be supported through July 2026.[8] Microsoft specifies that "InfoPath Forms Services is included in the on-premises release of SharePoint Server 2016, as well as being fully supported in Office 365 until further notice."[9] Microsoft MVP Roger Haueter[10] states that InfoPath is still expected to be supported in SharePoint Server 2019 On-Premises.[11]
Server-side components
[edit]Forms Server 2007 is a discontinued product that converts InfoPath client forms into Ajax HTML forms that can be accessed and filled out using any browser, including mobile phone browsers. Forms Server 2007 supports using a database or other data source as the back-end for the form. It requires Microsoft Windows SharePoint Services 3.0 and the .NET Framework version 2.0.[12]
InfoPath Forms Services (or Office Forms Services) takes over the features of Form Server 2007, allowing InfoPath forms to be hosted in a SharePoint web site and served via web browser. Originally a component of Microsoft Office SharePoint Server 2007 Enterprise edition,[13] in 2013, it was made available with:
- SharePoint Online Plan 2[14]
- Office 365 E3/A3/G3 or higher
- SharePoint Server 2013 Enterprise CAL
On January 31, 2014, Microsoft said they are discontinuing InfoPath Forms Services.[15] Later in an undated update to the original post Microsoft changed the plan and announced that InfoPath Forms Services would be included in SharePoint 2016 after all.[16]
InfoPath Forms Services is available to Office 365 Education subscribers (Office 365 A1, Office 365 A3 and Office 365 A5 plans).[17]
Versions
[edit]
| Version | Included in... | Release date[18] | Support end date[19] |
|---|---|---|---|
| InfoPath 2003 | Microsoft Office 2003 Professional Enterprise | November 19, 2003 | April 8, 2014 |
| InfoPath 2007 | Microsoft Office 2007 Ultimate, Professional Plus and Enterprise | January 27, 2007 | October 10, 2017 |
| InfoPath 2010 | Microsoft Office 2010 Professional Plus; Office 365 | July 15, 2010 | October 13, 2020 |
| InfoPath 2013 | Microsoft Office 2013 Professional Plus; Office 365 | January 29, 2013 | July 14, 2026 |
References
[edit]- ^ "May 3, 2016, update for InfoPath 2013 (KB3114946)". Microsoft. Retrieved 21 June 2022.
- ^ "Download InfoPath 2013 for Office 365 ProPlus Subscription from Official Microsoft Download Center". Microsoft. 1 September 2015. Retrieved 25 September 2015.
- ^ "Jean Paoli on Microsoft Office InfoPath 2003 - InfoPath - Office.com". Office.microsoft.com. Archived from the original on 2012-09-10. Retrieved 2012-01-25.
- ^ "United States Patent: 7191394". Patft.uspto.gov. Retrieved 2012-01-25.
- ^ "XSN File Extension - What is an .xsn file and how do I open it?". 26 May 2009. Retrieved 30 January 2020.
- ^ "Introduction to InfoPath Forms Services". Retrieved 2014-01-28.
- ^ "Announcing General Availability of PowerApps". Microsoft. 2016-10-31. Retrieved 2018-12-03.
- ^ "InfoPath is not included in Office 2016". Office Blogs. Microsoft. 1 March 2016. Retrieved 29 May 2018.
- ^ "Update on InfoPath and SharePoint Forms - Microsoft 365 Blog". Microsoft 365 Blog. 2014-01-31. Retrieved 2018-05-29.
- ^ "Roger Haueter - Microsoft MVP". www.rogerhaueter.com. Retrieved 2018-05-29.
- ^ "What's coming with SharePoint Server 2019 on-premises - techtask". techtask. 2017-09-27. Retrieved 2018-05-29.
- ^ "Forms Server 2007". TechNet. Microsoft. 16 November 2006. Retrieved 2 February 2014.
- ^ May, Andrew (8 June 2006). "InfoPath Forms in Office SharePoint Server 2007". Andrew May's Blog. Microsoft. Retrieved 2 February 2014.
- ^ "SharePoint Online Service Description". TechNet. Microsoft. 18 December 2013. Retrieved 2 February 2014.
- ^ Protalinski, Emil (January 31, 2013). "Microsoft discontinues electronic forms software InfoPath, will support latest version until April 2023". The Next Web. Retrieved February 1, 2014.
- ^ "Update on InfoPath and SharePoint Forms". Office Blogs. Microsoft.
- ^ pebaum. "Office 365 Education". docs.microsoft.com. Retrieved 2018-11-13.
- ^ "Microsoft InfoPath Life-cycle Information". Retrieved 2011-10-25.
- ^ "InfoPath Product Lifecycle". support.microsoft.com. Retrieved 2018-05-29.
- "The Future Of Infopath & SharePoint Forms". ClaySys Technologies. 2019-07-11. Retrieved 2020-10-13.
External links
[edit]Microsoft InfoPath
View on GrokipediaHistory and Development
Origins and Initial Release
In the early 2000s, businesses increasingly sought to transition from paper-based processes to digital forms, driven by the rise of XML technologies for structured data exchange and the need for more efficient information gathering.[12] Microsoft recognized this shift and developed InfoPath, originally codenamed XDocs, as a tool to enable the creation and management of XML-based electronic forms without requiring advanced programming skills.[13] The application aimed to democratize XML form design for knowledge workers, allowing non-developers to build forms that adhered to XML schemas while integrating seamlessly with backend systems like databases and web services.[8] Microsoft first publicly unveiled InfoPath on February 10, 2003, highlighting its support for industry standards such as XML, XPath for data navigation, and elements inspired by the emerging W3C XForms specification to ensure interoperability and future-proofing.[13] A beta version followed shortly after as part of the Microsoft Office System Beta 2, released to over half a million testers in March 2003, where it was praised for streamlining data collection from disparate sources into structured XML documents.[14] This early testing phase focused on validating InfoPath's ability to reduce the complexity of form creation, addressing pain points in traditional tools that lacked native XML handling. InfoPath 2003 achieved general availability on November 19, 2003, bundled exclusively with the Microsoft Office 2003 Professional Enterprise Edition to target enterprise users needing advanced collaboration features.[2] The release positioned InfoPath as a direct alternative to PDF-based forms, such as those from Adobe Acrobat, by emphasizing editable, data-driven XML forms that could merge with Office applications for broader workflow adoption.[15] Subsequent versions would build on this foundation, but the initial launch established InfoPath's role in accelerating the industry's move toward standards-based electronic forms.[12]Evolution Through Versions
Microsoft InfoPath 2007 was released on January 30, 2007, alongside the Microsoft Office 2007 suite, marking a significant advancement in electronic form capabilities. This version introduced browser-based forms, enabling users to fill out and submit forms directly in web browsers without requiring the full InfoPath client, through integration with InfoPath Forms Services on Microsoft Office SharePoint Server 2007. Additionally, it added support for ADO.NET data connections, allowing forms to bind to richer data sources and perform more complex data operations. These features expanded InfoPath's utility beyond desktop environments, facilitating broader deployment in enterprise settings.[16][17][18] The subsequent release, InfoPath 2010, arrived on June 15, 2010, as part of the Office 2010 family, incorporating the Ribbon interface for a more intuitive user experience consistent with the broader Office suite redesign. Key enhancements included Quick Rules, a simplified mechanism for adding validation, formatting, and action-based logic to forms without extensive coding, accessible via the Rules task pane. Improved mobile support was also added, allowing forms to be optimized and hosted for access on mobile devices through SharePoint Server 2010, extending usability to field workers and remote users. These updates built on prior capabilities, emphasizing ease of design and cross-device accessibility.[19] InfoPath 2013, released on October 22, 2012, served as the final major version of the product, integrated into Office 2013 and offering previews of cloud-based integration with emerging services like Office 365 for form hosting and collaboration. It enhanced digital signature handling, supporting more flexible signing of form sections and improved compatibility with cryptographic standards for secure data submission. Compatibility with Office 365 was emphasized, allowing forms to leverage cloud storage and sharing features. This version refined existing functionalities without introducing entirely new paradigms, focusing on stability and alignment with Microsoft's shifting ecosystem.[20][21][4] Throughout its versions, InfoPath offered edition variants to suit different needs: the full Standard edition for form design and filling, and the Filler edition, a client-only component for opening and submitting forms without design tools. After the 2007 release, InfoPath was excluded from retail Office suites, available instead through volume licensing programs for enterprise customers, ensuring targeted distribution to organizations requiring advanced form solutions. Cumulative advancements included the introduction of template parts in 2007 for reusable form components and progressive improvements to secondary data connections, enabling forms to pull and submit data from multiple external sources like databases and web services across all versions.[22][23][17]Core Features
Form Design Paradigm
Microsoft InfoPath employs a declarative design paradigm that enables users to create structured, XML-based electronic forms without requiring extensive coding knowledge. This approach centers on a drag-and-drop interface within the InfoPath Designer, allowing designers to define XML schemas, add views, and incorporate controls such as text boxes, drop-down lists, and repeating tables directly onto the form layout. By leveraging XML Schema Definition (XSD) files, InfoPath ensures that the form's data structure is predefined, facilitating structural validation of input and output XML documents during design and runtime.[24][8][25] The visual designer provides intuitive layout tools for arranging elements, including sections, tables, and optional controls, while supporting advanced features like conditional formatting and data validation rules. Conditional formatting allows dynamic changes to control appearance—such as font color, bold text, or visibility—based on XPath expressions that evaluate form data conditions, ensuring the form adapts to user input without manual intervention. Similarly, data validation uses XPath-based rules to enforce constraints like required fields or numeric ranges, displaying error messages to guide users toward compliant entries. These elements promote a user-friendly design process focused on visual composition and rule-based logic rather than imperative programming.[26][27][28] At its core, InfoPath's template-based approach results in the creation of .xsn files, which are compressed cabinet (.cab) packages containing the XML schema, view definitions (in XSL transformations), business logic, and the manifest (.xsf) file that orchestrates all components. This packaging encapsulates the form's data structure, presentation, and behavior into a single deployable unit, streamlining distribution and maintenance. Forms support multiple views per template, enabling designers to create distinct layouts—such as summary or detailed perspectives—that users can switch between dynamically. Additionally, the designer includes preview modes for real-time testing of form functionality, allowing seamless transitions between design and end-user simulation without saving intermediate files.[29][30][31] To implement calculations and logic non-programmatically, InfoPath offers built-in formulas expressed as XPath functions, which can be inserted via a formula dialog without writing custom code. For instance, theconcat() function combines text from multiple fields or constants into a single output, while today() retrieves the current system date for timestamping entries. These formulas integrate directly into controls for default values, validations, or rule conditions, empowering non-developers to add sophisticated behavior like dynamic text generation or date-based computations.[28][32]
Data Management and Security
Microsoft InfoPath facilitates data management through dynamic data connections that link forms to external sources, enabling the retrieval and submission of structured data. These connections support XML files as primary or secondary data sources for storing form data in a schema-defined format. Databases such as Microsoft SQL Server or Access can be connected via ADO.NET, allowing queries to populate form fields or submissions to update records. Web services, including those using SOAP protocols or Windows Communication Foundation (WCF), provide integration for real-time data exchange, while email connections enable form submissions directly to recipients as attachments or embedded XML.[33][34][35] Validation in InfoPath ensures data accuracy and compliance by enforcing XML schemas inherent to the form template, which check structural and content rules during input to prevent invalid submissions. Custom validation rules can be applied to controls like text boxes or date pickers, specifying conditions such as required fields or value ranges, with user-friendly error messages displayed via ScreenTips or alerts. Error handling includes options for blocking form submission until corrections are made, providing immediate feedback to users and maintaining data integrity without halting the overall process.[36][24] Security features in InfoPath include digital signatures compliant with the W3C XML Digital Signature (XML-DSig) standard, which verify form integrity by detecting alterations and authenticate the signer using digital certificates from trusted authorities. Signatures can apply to the entire form or specific data sections, supporting non-repudiation through embedded timestamps and environmental details, while allowing multiple signers for collaborative scenarios. This mechanism protects sensitive data during transmission and storage, ensuring trustworthiness in enterprise environments.[21][37] For offline use, InfoPath caches secondary data sources within the form template or local storage, allowing users to query and populate fields without an active connection by retrieving previously stored data. Forms can be filled and saved locally in the absence of connectivity, with submissions queued for later dispatch upon reconnection, thus supporting mobile or intermittent network scenarios while minimizing data loss. Data expiration policies can be configured to refresh cached information after a specified period when online.[38] Export capabilities in InfoPath enable the conversion of completed forms to various formats for archiving or analysis, including PDF for fixed-layout preservation that maintains visual fidelity and restricts edits. Form data can be exported as XML files for programmatic processing or integration with other applications, and merged into Excel workbooks to aggregate multiple submissions for reporting, filtering, or charting without altering the original structured data.[39]Usage and Applications
Standalone Form Creation
Microsoft InfoPath enables standalone form creation through its dedicated applications, InfoPath Designer for building form templates and InfoPath Filler for completing them, allowing users to work entirely on local desktops without requiring server infrastructure.[4] In Designer, users construct forms by dragging controls onto a canvas, defining data sources in XML schema, and adding rules for validation or calculations, resulting in a .xsn file package that encapsulates the template, views, and logic.[40] Filler then opens these templates for data entry, supporting offline editing and saving as .xml instance files, which store user-submitted data separately from the template.[41] Distribution in standalone mode occurs via simple methods such as emailing the .xsn template or .xml instances directly to recipients, who can open them in Filler if installed, or hosting templates on accessible file shares for users to download and use locally.[42] To email a template, designers use the Publish Wizard in InfoPath, selecting recipients and attaching the file, which maintains the form's structure and any embedded rules upon receipt.[43] File share publishing involves saving the .xsn to a network location, enabling multiple users to access and fill instances independently, with updates propagated by replacing the template file.[44] Common use cases for standalone InfoPath forms include internal business processes like expense reports, where employees fill out details such as receipts and approvals offline before submission; surveys for quick feedback collection; and HR documents like leave requests, which benefit from structured data entry without complex routing.[45] For instance, an expense report form might include repeating sections for line items and calculations for totals, filled locally and emailed back for review.[46] However, standalone mode has key limitations: forms render only in the desktop Filler application, requiring users to have InfoPath installed, with no support for browser-based viewing or filling.[5] Security levels restrict features—such as disabling web service connections in restricted mode—unless elevated to full trust via digital signing or installation, potentially limiting advanced functionality without additional setup.[47] To enhance user adoption, designers can incorporate digital signing in forms to establish trust and enable full-trust execution, where users verify signatures before filling, reducing concerns over authenticity in emailed distributions.[48] Additionally, merging multiple form responses is supported by enabling the feature in Designer, allowing users to combine .xml instances from various submissions into a single aggregated form for analysis, such as consolidating survey data via File > Merge Forms in Filler.[49][50]Enterprise Workflow Integration
Microsoft InfoPath supports integration of electronic forms into enterprise workflows, primarily through server-side components like SharePoint, to automate business processes such as approvals and data collection. Basic rule-based submissions, such as emailing forms or connecting to web services, can trigger simple actions based on data without custom coding, but advanced sequential tasks, routing, and notifications typically require SharePoint integration. This enables dynamic workflows informed by user inputs, enhancing efficiency in departmental operations.[51] Workflow attachments in InfoPath allow for the inclusion of supporting documents or diagrams, such as those created in Microsoft Visio for process visualization, which can be attached to forms and referenced during automation when integrated with SharePoint. Custom scripts, often developed using managed code, enable further automation by processing attachments and integrating them into workflow logic, such as validating diagrams against form data before advancing to the next approver. For instance, Visio diagrams can model complex approval paths that are then associated with InfoPath forms to guide task execution.[52][53] Role-based form routing utilizes rules to direct submissions to multiple users based on predefined criteria, such as department or hierarchy level, ensuring sequential or parallel reviews when deployed in a SharePoint environment. This supports scenarios like multi-level approvals, where forms are routed to designated groups and tracked through status fields that update in real-time, such as "In Progress" or "Approved." Status tracking is achieved by binding form fields to workflow metadata, allowing participants to view progress without leaving the form interface.[54][55] In enterprise applications, InfoPath forms are commonly deployed for compliance processes, including regulatory submissions that require structured data entry and validation to meet standards like Web Content Accessibility Guidelines (WCAG) 2.0 Level AA in browser-based deployments.[40] Approval processes can route requests through review cycles, capturing justifications and attachments.[40][56] Scalability challenges in high-volume submissions arise from form complexity and data processing demands, which can be addressed by optimizing view structures and limiting repeating sections to reduce load times. Custom extensions via Visual Studio Tools for Office (VSTO) add-ins allow developers to enhance forms with advanced logic, such as batch processing for thousands of submissions, ensuring performance in large-scale environments.[53][40] Best practices for enterprise deployment include maintaining version control of form templates through iterative publishing and testing to prevent disruptions during updates. Auditing submission history involves configuring forms to capture timestamps, user details, and modification logs where supported by the deployment environment, enabling comprehensive tracking of workflow instances for compliance and troubleshooting.[54]Microsoft Ecosystem Integration
SharePoint Compatibility
Microsoft InfoPath enables seamless integration with SharePoint by allowing users to publish form templates directly to SharePoint libraries as .xsn files, facilitating browser-based form filling through InfoPath Forms Services.[5] This process uses the Publishing Wizard in InfoPath Designer to upload templates to a SharePoint site collection, where administrators can approve them for deployment, enabling end-users to access and complete forms without installing InfoPath on their devices.[57] Browser-enabled forms render in standard web browsers such as Internet Explorer, Firefox, or Safari, supporting collaborative environments where multiple users can interact with forms hosted on SharePoint servers.[18] Form libraries in SharePoint serve as centralized repositories for storing InfoPath form submissions, leveraging SharePoint's built-in capabilities for metadata management and versioning.[5] Each submitted form instance is saved as an XML document within the library, accompanied by customizable metadata columns that capture additional context, such as submission date or approver notes, which can be promoted from the form fields during publishing.[58] SharePoint's versioning feature automatically tracks changes to these submissions, allowing users to view historical versions and maintain audit trails for compliance purposes, while content types enable reuse of form templates across multiple libraries or site collections.[5] InfoPath's compatibility with SharePoint spans several versions, beginning with initial support in SharePoint Server 2007, which relied on Windows SharePoint Services 3.0 for basic form hosting.[5] Subsequent iterations, including InfoPath 2013, extended compatibility to SharePoint Server 2016 and 2019, ensuring that form templates remain functional in supported on-premises versions and cloud environments like SharePoint Online until the extended support end date in 2026.[10][59] InfoPath Forms Services is not supported in SharePoint Server Subscription Edition.[60] This backward and forward compatibility allows organizations to deploy InfoPath forms without major redesigns during SharePoint upgrades, though some configurations, such as data connections, may require adjustments for site collection boundaries in newer versions.[61] Key features of this integration include digital workflows created via SharePoint Designer, which can associate InfoPath forms with approval processes in lists or libraries.[54] For instance, workflows can initiate tasks based on form submissions, displaying status updates within the form through rules that adjust views or fields dynamically.[54] Additionally, form-to-list mappings allow InfoPath submissions to populate SharePoint lists directly, promoting specific fields as list columns for querying and reporting, which enhances data-driven workflows without manual data entry.[57] Despite these capabilities, browser mode imposes limitations on certain controls and features to ensure cross-browser compatibility.[18] ActiveX controls, for example, are entirely unsupported in browser-enabled forms, as are ink picture controls and file attachments on mobile devices, requiring users to rely on InfoPath Filler for full functionality in such cases.[18] Digital signatures are restricted to sectional signing in Internet Explorer only, and rich text boxes offer limited formatting in non-IE browsers, potentially affecting form usability in diverse environments.[18]Office Suite Synergies
Microsoft InfoPath enhanced productivity within the Microsoft Office suite by enabling seamless data exchange and integration with applications like Excel, Word, Outlook, and Access, allowing users to leverage form data across desktop environments.[39] These synergies facilitated workflows where structured form data could be analyzed, embedded, or stored without manual re-entry, streamlining tasks such as reporting and document management.[50] InfoPath supported importing Excel workbooks to create form templates, converting spreadsheet structures into interactive XML-based forms while preserving data validation and layout options.[62] Conversely, users could export form data directly to Excel for analysis, charting, and further manipulation, with InfoPath 2007 automatically generating XML maps to enable seamless reopening in Excel.[39] This bidirectional flow was particularly useful for aggregating multiple form submissions into spreadsheets for quantitative review. Forms designed in InfoPath could be embedded in Outlook for email-based submissions, where recipients opened, filled, and submitted them directly within the email client without launching InfoPath separately, provided both applications were installed and configured.[50] In Word, InfoPath templates imported documents to hybridize forms with rich text elements, supporting scenarios like embedding fillable sections in reports or contracts.[63] These integrations allowed for forwarding editable forms via email or merging form data into Word documents for collaborative review. InfoPath integrated with Access databases through data connections, enabling synchronization for backend storage and querying by designating Access as a primary or secondary data source via the Data Connection Wizard.[35] As a primary source, forms submitted data directly to Access tables using ADO, provided simple structures without complex joins, while secondary connections populated controls like list boxes from queries.[64] This setup supported real-time querying and updates, ideal for maintaining relational data from form inputs in desktop databases. Form templates could be published to shared network locations accessible via OneDrive, facilitating template sharing among users, though co-authoring of active forms was limited in later versions like InfoPath 2013, lacking the real-time editing capabilities of native Office files.[65] Integration with Teams occurred indirectly through OneDrive-stored templates, but without dedicated co-authoring support for form design or filling within the platform. Automation across Office applications was achievable via VBA macros, where scripts in Excel or Word used COM interop to instantiate the InfoPath Application object and manipulate forms, such as creating new instances from templates or opening existing ones with predefined data.[66] For example, VBA code likeSet objInfoPath = CreateObject("InfoPath.Application") enabled external apps to automate form submission or data import, extending custom behaviors without native scripting in InfoPath itself.[66] This approach was common for building interconnected workflows, such as pulling form data into Excel macros for processing.
Server-Side Components
InfoPath Forms Services
InfoPath Forms Services is a server-side component of Microsoft SharePoint that enables the deployment and browser-based filling of InfoPath forms, allowing organizations to host form templates centrally without requiring the InfoPath client on user machines.[67] The architecture integrates with SharePoint Server, utilizing web front-end (WFE) servers and a shared database farm to manage form processing.[68] Key elements include IIS and ASP.NET for handling HTTP requests, an HTTP handler that routes traffic to the page generator, a converter for transforming form templates, and the page generator for managing session state and data interactions.[68] Central Administration provides the primary interface for configuring InfoPath Forms Services, particularly for data connections and user roles. Administrators can manage universal data connection (UDC) files through the "Manage data connection files" option, approving or rejecting connections to external data sources like web services or databases to ensure controlled access.[69] User roles are defined via SharePoint's permission model, integrated with theMicrosoft.Office.InfoPath.Server.Administration namespace for automating tasks such as enabling the web service proxy, which facilitates cross-domain data queries.[67]
The rendering engine converts InfoPath form templates (.xsn files) into HTML and ASP.NET pages for browser compatibility, primarily supporting Internet Explorer and compatible browsers; Microsoft Edge requires Internet Explorer compatibility mode.[18] This process occurs via the Converter component, which transforms the template into an .aspx page and caches it for reuse, while FormServer.aspx and MobileFormServer.aspx handle the actual rendering, incorporating JScript for client-side interactions and AJAX-like postbacks.[68]
Security in InfoPath Forms Services relies on SharePoint's claims-based authentication, where user identities are mapped through the Secure Store Service to handle multi-hop scenarios without exposing credentials.[69] Forms operate in a sandboxed environment to restrict code execution, and connection whitelisting is enforced by administrators approving UDC files in data connection libraries, preventing unauthorized external access.[69] Authentication supports methods like Kerberos and forms-based, with the web service proxy enabling unauthenticated outbound connections on behalf of users.[69]
Performance tuning focuses on caching and resource limits to optimize form rendering and data handling. The solution cache stores form templates up to 300 MB per web application, configurable via PowerShell cmdlets like Set-SPInfoPathFormsService, reducing load times by avoiding repeated disk access.[70] Session data is limited to prevent overload, with defaults around 4 MB per form session managed by the page generator, and administrators can adjust thresholds to balance responsiveness and server load. This is a configurable setting in Central Administration.
Deployment differences exist between on-premises and cloud environments: on-premises setups offer full Central Administration control, including support for full-trust forms and custom code, whereas SharePoint Online restricts configurations to tenant-level defaults, disables full-trust forms, and imposes stricter limits like 30-second publishing timeouts and 5 MB attachment sizes due to managed infrastructure.[61]