Oct 22 2016 05:15 PM - edited Oct 22 2016 05:17 PM
With PowerApps nearing its first birthday (though still in preview), some people are asking whether it is ready for prime time and if not, what are the options. In this article, I’m presenting some common forms requirements and look at solutions that are available for free to build these forms.
Common Forms Requirements
If you have developed many forms in the past, you will probably agree that after finishing the first few, the ones that followed were permutations of the same requirements. Sure, all forms include some controls for data entry, field validation, and maybe some basic logic. The following categories represent these requirements:
Look & Feel
Who doesn’t like their website to look beautiful? The importance of the look and feel also holds true for the forms, particularly on public-facing websites and large intranets as they represent the brand of your organization. Some of the requirements that fall into this category are text fonts, colours of controls and other components, and general layout of the form.
Mobile Access
Working anywhere on any device is the new norm. With the massive increase in mobile device usage globally in the last decade, your users are expecting to do more and more on their mobile devices. Filling out forms falls into this category as well, particularly for users whose job is to work in the field. Imagine having a safety inspection worker filling out safety checklists on-site. Could you imagine them completing the lists on paper and then transcribing the information when their back in the office? Not likely.
Conditional Formatting
Injecting logic is one of the of the great benefits of digital forms. A form can request various type of information from the user based on some criteria, such as data that the user previously entered or information acquired indirectly, such as the user name and other information about them. Conditional Formatting can be used to reduce the size of the form to be completed by automatically ruling out additional questions.
Lookups
Another way to lessen the amount of user data entry is with lookups. Lookups let you query for specific information from SharePoint or other systems (e.g. SQL, Exchange, Active Directory, etc.). The fact that the user doesn’t need to enter the data also reduces the risk of incorrect data entries where corresponding field values don’t match (for example a person’s name, social security number, and address in the case of an insurance renewal).
Repeating Sections
Repeating sections are used to capture sets of fields when you don’t know how many sets will be filled-in. Paper forms usually contain a fixed number of fields or suggest attaching additional documents as needed. Properly built forms will let your users enter a variable number of values.
Available Solutions
Depending on your form needs listed above, you have a few options to choose. Here’s a quick summary of the various tools provided by Microsoft.
SharePoint List Form
These are the forms that are built directly into the different SharePoint lists and libraries. They get generated automatically by SharePoint when you create the lists. You can configure the lists to display the fields in particular orders and have validation through the SharePoint user interface. You want to further enhance the look and feel and functionality using client-side scripting.
SharePoint Designer
SharePoint Designer lets you modify the existing SharePoint list forms and also create new ones. Using SharePoint Designer provides you more flexibility than the default list forms but requires knowledge of HTML and client-side scripting. Look and Feel can be more easily configured using SharePoint Designer than the native lists.
InfoPath
InfoPath is a separate application that has been the preferred forms development tools for SharePoint by many developers for many years. It has a rich feature set that addresses all requirement categories listed above.
PowerApps
PowerApps is new forms visual forms development app that lets you create forms from SharePoint and numerous other apps from within the Office 365 apps family and outside. PowerApps allows you to select the layout you want to use for your forms app, and there is a definite focus on mobile access. As PowerApps is not a SharePoint-only forms solution, it requires you to install the PowerApps app on the device you want to use the forms on before being able to open them.
Microsoft Forms
Microsoft Forms is a survey-like education tool that as developed for creating quizzes and provide feedback. Its functionality is mainly geared around building forms that have branching, multiple choice, and short text answers. This app is only available to Office 365 Education tenants.
3rd Party tools
There are also some 3rd party tools available on the market the focus specifically on forms creation. Many of them use a visual interface and are very feature rich to meet all your forms needs. Such tools usually carry an additional cost with them, but before dismissing them as a viable option, you should assess your specific requirements around how many forms you need and how long it would take to build them using some of the other available tools.
With all these requirements and tools available to you, which is the best option? To derive the answer, you need to consider a few things for our organization, such as:
If you’re thinking of using SharePoint Designer or InfoPath, then you need to consider that both of these products are being phased out. According to Microsoft, InfoPath 2013 and SharePoint Designer 2013 will be the last versions of those products. SharePoint Designer is not being re-released with SharePoint Server 2016, although we will continue to support custom workflows built with SharePoint Designer and hosted on SharePoint Server 2016 and Office 365. Support for InfoPath 2013 and SharePoint Designer 2013 will match the support lifecycle for SharePoint Server 2016, running until 2026.
Here’s a quick summary of the available options.
Requirement | SharePoint List Form | SharePoint Designer | InfoPath | PowerApps | Microsoft Forms |
Look & Feel | Yes* | Yes | Yes | Yes | Yes |
Mobile Accessible | Yes | Yes | Yes | Yes | Yes |
Conditional Formatting | Yes* | Yes* | Yes | Yes | Yes |
Lookups | Yes* | Yes* | Yes | Yes | No |
Repeating Sections | No | No | Yes | No | No |
* Can be achieved through client-side scripting
Oct 22 2016 10:59 PM
I a missing the infopath problems if people have not a IE browser or are not using IE10 or lower...
But to compare it is a nice overview.
Oct 22 2016 11:45 PM
Oct 24 2016 11:33 AM
My understanding was that Excel Surveys required the tenant to be set to allow 'Anonymous Sharing'. Which has its own implications.
Oct 24 2016 09:24 PM
Paul, everyone one of these solutions carries its own limitations. I tried to keep this article at a high level, but if there's interest, I'd be happy to go deeper into each one of these solutions. Thanks for your feedback.
Oct 24 2016 09:29 PM
Jun 13 2017 01:36 AM
Would love to hear about what can be done with Visual Studio..
Jun 14 2017 04:53 AM
Today i found out that i have forms on my NON Education tennant with E3 so something has changed a long the way :)
Jun 16 2017 08:42 PM
Indeed! Forms is now available on other tenants. I beleive if your tenant is set up with First Release, you should have access to it. Visit https://forms.office.com to check it out.
Jun 16 2017 11:28 PM
Jun 17 2017 01:29 AM
Hi to all,
Yes I can confirm that Forms is available as preview to "First Release Tenants".
If is not available in your tenant as Juan said the message in "Message Center" that is rolling out, please if you want enable First Release and wait a few days.
Jul 27 2017 12:41 PM
Thank you so much for your very useful summary of Form options for SharePoint. It's unfortunate that a tool like Microsoft Access cannot be used for this purpose given its oodles of options and ease of use. However, I know that Microsoft will never support that. My question is regarding whether there is any application out there that allows you to easily build forms with the same degree of customization but does not require users to know HTML or JavaScript. Thanks in advance for any help you can provide.
Feb 27 2018 02:36 AM
Since we have not so many options for designing forms for SharePoint modern UI, I want to mention a 3rd party solution that allows you design fully responsive forms for SharePoint modern lists and libraries - Plumsail Forms. It provides easy-to-use designer with drag-n-drop UI, supports repeating sections, conditional formatting, and many other features.
Jan 23 2019 01:57 AM
Dec 27 2019 09:04 AM
Wow, there's really no replacement for handling repeating sections effectively besides the soon to be phased out InfoPath.