Getting Started Guidelines to Microsoft Forms Limits and Boundaries

Microsoft Forms is a basic lightweight app for quickly collecting information via surveys and quizzes, but you should be aware of its limits.  The strength of Microsoft forms is its licensing.  It’s free to use for anonymous or authenticated users, and the data can be stored in a list or connected to flow to push into other systems, but there are some limits to be aware of especially in relation to using it to build an app.  When do you decide to use a PowerApp vs. a form or even just use the list?  Microsoft Forms is a great way to get started with the new generation of tools in Office 365, but when should you look into the Microsoft ecosystem?  It was when I started pushing the limits that I found there are some limitations in Microsoft Forms.  Even walking through User Voice, you can’t get a clear picture.  I couldn’t find a single place with guidelines on what those limits were that I decided to put together an infographic to simplify the process.  I’m working on a broader infographic for what to use when, and I’m hoping this will simplify the process.  As with all things in Office 365, it’s a moving target and these limits are subject to change anytime, but this is current as of my evaluation and testing on 2/11/2019.  I did see acknowledgement on various forums, but never saw a list of Microsoft Forms Limits in one place so this is my effort to try to consolidate.  Feel free to add your own thoughts in the comments or feedback on my experience as well.  Hopefully this posting will encourage users to weigh in on User Voice options to increase these limits.  Let me know if you see any changes as time goes on.  I will plan to support this list over the coming year… and maybe more with encouragement from the community.

1.  Users Can’t Update or Come back to finish their responses. 

In this limitation users have to fill out the form and be done.  If users might need to come back to change a response such as in an RSVP or if they want to save and come back later to finish, Microsoft Forms is currently not able to support users coming back.

2. Hard Limit of 100 Questions. 

Essentially there is a hard limit of 100 questions in Microsoft Forms.  This boundary does seem like one that should be published and I expect it will be published in the near future.  Of note it really depends on how you ask the questions and what style of questions you’re using as to how this limit is reached.  Some users have experienced the limit at 60 by using different style of questions… see #6 for another example.

3. You are limited to 2 to 10 options on a ranking question. 

If you have 10 ranking questions you can only ask 10 questions.  If you have a ranking question with 2 options you’ll only be able to ask 50 questions.  This can make for an odd survey if you keep finding you’re hitting a limit.

4. Choice Questions store only 60 options. 

This is a soft limit, so you won’t even notice.  You can provide hundreds of options, but only a max of 60 options are stored to viewed in your results.  So imagine you’re asking the user to choose their country.  As a traveler I know there are 193 UN countries, but At&t seems to think there’s a whole lot more than that so they can say they are in a ton more than they actually are.  That aside, if you ask someone to choose their country, you’ll find Microsoft Forms is only storing 60 options.  So when you’ve got users from 90 countries you’ll find only 60 of them were stored.  In my mind that’s pretty serious.  You could ask that question in a text field, but that’s a little strange.

5. You get a max of 4000 characters in a response. 

Imagine your users are giving you feedback and you get a nice essay as a response and find it’s only half there.  Be aware you’ll only get 4000 characters in the long text box response.  I can’t imagine someone pouring their heart out to provide detailed responses and then you get only the first 4000 characters in that response.  Is that enough?  Who knows, but to have it be truncated isn’t cool.

6. Likert scales are limited to 20 questions. 

Just as in the limits above, you might find yourself designing a survey and finding you’re running out of questions.  Be aware.

image

If you like the infographic and want to use it in a blog or in your presentations at SharePoint Saturdays or community events, no problem.  This infographic is shareable with creative commons share with attribution.  As long as you include the whole image you’re good to go.  You can download it as a PDF or as an image. 

Join me for a Webinar on this Topic and More

If you liked what you saw here and want more.  You can join me on a Webinar on March 7, 2019 where I’ll be discussing “Apps, Forms, Workflows and Tools of Office 365: What to Use When?”  This webinar is being sponsored by Crow Canyon.  They have built a number of powerful tools to simplify and extend the power of Office 365, so they also frequently hear from their customers where to add value.  In the webinar I’ll be going over each of the Microsoft Apps and Tools and describing their strengths, helping you best understand “when to use what tools” in building out your solutions. 

Three Tiers to Increase to Unlimited Storage in OneDrive for Business

In recent history, Microsoft quietly supported 1TB to 5TB.  Many customers didn’t notice that change.  Many Office 365 Admins don’t realize the limit is NOT 1TB.  This quiet update to the pricing plans with the reference to unlimited storage with the little circled i with more information has not really made it to general mindset of the community and many customers still support competing products not realizing that OneDrive as well supports UNLIMITED STORAGE for users!  A simple search for OneDrive Unlimited results in old information no recent discussions.

Why would you not want 25TB quotas for your users especially those who refuse to move because there isn’t enough cloud storage or they are worried about the cost?  OneDrive just got 25x more cool and beyond!

 

image

I put together the very sharable infographic above, so you can help promote the fact that OneDrive for Business is now Unlimited.  Feel free to use the image how every you’d like feel free to download it or use it in your slides.

Download the OneDrive Unlimited Storage Infographic.

It’s not hard to give all your users 5TB of storage by default.  Simply go to https://admin.onedrive.com/?v=StorageSettings and change the default 1TB to 5TB

 

image

Or through the Office 365 Admin Powershell:

To change default quota to 5TB  for OneDrive for Business for entire Tenant

Set-SPOTenant -OneDriveStorageQuota 5120

To change quota for a user:

Set-SPOSite -Identity <user’s OneDrive URL> -StorageQuota <quota>

Note Subscriptions with less than five users receive 1 TB of personal cloud storage per user.  In fact all start that way.

“Customers will initially be provisioned 1 TB of personal cloud storage per user in OneDrive for Business. You may increase the default OneDrive for Business storage space to up to 5 TB per user with the help of your Office 365 administrator once the 1TB quota is 90% full.”

Thats the tricky part.  Microsoft is basically saying wait until a user has reached that capacity, but getting to 5 TB default you don’t need to wait, but going to 25 TB quotas you’ll need MS support help with justification such as a user who is close.

“Whenever you need cloud storage beyond the initial 5 TB, open a case with Microsoft technical support to request it. Additional cloud storage will be granted as follows:

  • When a user has filled their 5 TB of OneDrive for Business storage to at least 90% capacity, Microsoft will increase your default storage space in OneDrive for Business to up to 25 TB per user (admins may set a lower per user limit if they wish to).
  • For any user that reaches at least 90% capacity of their 25 TB of OneDrive for Business storage, additional cloud storage will be provided as 25 TB SharePoint team sites to individual users. This additional storage is provided to the tenant by way of credit.

To see how much personal cloud storage you are using, your Office 365 administrator can go to the OneDrive Admin Center to manage their users’ personal cloud storage.”

See Change your users’ OneDrive storage space using PowerShell for more information on how Office 365 administrators can manage user storage in OneDrive for Business.

 

I had heard rumors that the 15GB per file limit was increased.  I have not seen this play out.  Uploading a file of 15.1 GB failed. I confirmed 15GB max individual file is still the case.  I’m hoping to see this increased for video files.  clip_image002

You can determine your personal quota by navigating to your onedrive for business and appending /_layouts/15/storman.aspx?root=Documents  It’s also in site settings… look for Storage Manager.  The nick name was StorMan

References:

https://docs.microsoft.com/en-us/onedrive/set-default-storage-space

https://docs.microsoft.com/en-us/onedrive/change-user-storage

https://products.office.com/en-us/onedrive-for-business/compare-onedrive-for-business-plans

https://products.office.com/en-us/business/compare-more-office-365-for-business-plans

5 Powerful Steps to Maximize Office 365 & SharePoint UX

5 Simple Steps to Maximize Office 365 and SharePoint Usability

 

I am humbled to have been selected as a Microsoft Regional Director, which made me realize it’s been a little while since I’ve posted.  I intend to correct that.  I’m excited to announce a new blog series on how to drive maximum usability in Office 365 in SharePoint Online, Office 365 Groups and beyond.  In my experience at Blizzard I’ve found simply migrating our data to SharePoint Online won’t accomplish the most important updates in the past year.

 

5 Steps to Maximize Office 365 & SharePoint Usability

Classify – Both Sites and Groups support classification in Office 365.  Being able to take action such as not listing a group or site in a directory, or using a flow to approve a site based on the need to support external guests can allow one to have a much better handle on HR data vs Finance or Legal data as an example.  It can also lend itself to support putting sites in Hubs based on department, division or location.

Hubify – Hubs are a new type of site, but really they simply roll up the documents and provide search scopes.  It’s running a Windows Powershell that makes a site into a hub site.  In this post we’ll dig into the how and why with samples.

Groupify – Groups is all the buzz.  Groups gives you all storts of stuff you never asked for, but the approach does have some merits especially in relation to adoption.  Much of the new tools will never be used until people experience them.  Teams and Groups expose these new tools.  The Group OneDrive and Group Inbox and Group Calendar are fantastic as is Planner for a team.

Modernify – The Modern UI is out, but there’s no one big switch to take your classic site all the way to a Modern SharePoint Site, but you can do it in 3 pretty basic steps.

CulturifyHow are you going to handle branding and incorporating company culture? We’ll look at the best approaches available today the answer is slightly different in Modern and Classic sites.

Upgrade SharePoint 2016

Top 10 Reasons to Upgrade to SharePoint 2016 Infographic

“The most reliable, scalable, secure and high-performing SharePoint Server release ever”

The Future of SharePoint got everyone’s heads spinning, but I’ve seen tons of new energy in the community. Companies everywhere are looking for ways to help justify upgrade or migration to the new platform that is poised to be the platform that nails it. (At least it may be time to give it another shot, right?) Microsoft calls SharePoint 2016 release “the most reliable, scalable, secure and high-performing SharePoint Server release ever”

Is that enough?  There’s more. I think many businesses want the details in an easy to consume easy to share format that makes it easy for management to make a clear decision on a winning platform designed for the future. Following the Future of SharePoint event, I gathered my list of reasons to upgrade and updated it with a few of the new additional reasons to upgrade and I think we have something that is worth sharing.

You have unlimited permission to share this with infographic with your management, share it on your blog, share it in your social media circles. We want to get the community up on SharePoint 2016 and I think this list of reasons will help!

You can download the Infographic as a sharable PDF document or as a PNG image.

Download, Share and View

SharePoint 2013 Mobile App Device Support Matrix

In preparing for my Mobile Enterprise Strategy Session in London, I put together two different mobile app support matrices.  People want to see what works on what platform.  None of this I’m calling Official.  This is my experience and from my own testing.  There may be bugs and you need to should also verify this yourself if you have any questions.  If you disagree with anything please add in the comments so I can either update or you can make others aware.

If you want the full slides you can download them here: SharePoint 2013 Mobile Enterprise Strategy. Despite the fact that it says only says SharePoint on some of these images.  This applies to SharePoint 2013 On Premises, Office Online, OneDrive, and Office 365.  I’m sure MS would like to know what you use that is missing from apps they are targeting for your device.

Enjoy!  Feel free to download this infographic “SharePoint 2013 Mobile App Platform Supportability Matrix”  or share it on your own blog!

SharePoint 2013 Mobile App Support Matrix

I love seeing all these boxes.  Reminds me of a conversation with Noah Sparks in 2013.  We asked… Will Microsoft ever check all the boxes?  They checked all those… so I had to add more!

 

Here’s the extended Office 365 and SharePoint mobile platform and OS support matrix.

 

SharePoint Mobile Extended Support Matrix

Download this image as a file: SharePoint 2013 Mobile OS and App Platform supportability Matrix

Microsoft doesn’t officially support Linux, and I’ve never seen anything officially called out about Kindles, but I do know there is an Ubuntu community that uses Office Online and OneDrive.

 

Download: Office 365 Mobile OS Platform Support Matrix

Office 365 Mobile OS Platform Support Matrix

Any Doubts Office 365 is More Secure Than Your Datacenter? [Infographic]

It was originally posted “10 Hard Facts That Prove Your Data’s Safer in Office 365 [Infographic]” by Ben Niaulin.  I put together an infographic myself based on the Office 365 Trust Center to help you in your efforts to share critical information about security and privacy.  I like how these Infographics help to make the business case and can help bring awareness to the emphasis Microsoft has put on building Trust and really cares about data security.

 

Search-First Approach to SharePoint 2013/2016 Migration Infographic

I’m working on a strategy paper on the Search-First approach to migrating or upgrading SharePoint.  I see three big phases to this approach.  The first is building out the brand new ultimate farm, the SharePoint farm that provides enterprise search.  Many may decide that this first state should also provides profiles and also may provide the new OneDrive to also get people started with SharePoint.  Those who previously deployed my sites, may wait for phase 2 for that.  I’ll be providing more detail in the paper on these phases and a few recommendations on the strategy.  Love to get feedback from those who have approached the upgrade and migration in this manner.

Those that are planning an upgrade SharePoint on prem should consider a search-first migration.  The Search-First approach to migration assumes you want to get started, and you are willing to invest in separate infrastructure for SharePoint 2013 Search and leave your existing farm alone for some period of time with the idea of indexing that content with the new farm.  This approach allows organizations to benefit from the improved functionality and user experience while requiring relatively low effort. Microsoft has dramatically improved search in SharePoint 2013 in three key areas: User Experience, Relevancy Tuning and Infrastructure. I’m working on a paper that will highlight these enhancements while illustrating the benefits of a search-first approach. In our experience, a good deployment of search can help with adoption of other structured and unstructured collaborative or portal based workloads by providing discovery, findability and refinement for content most important to the enterprise. This article begins with an introduction to the new features and improved look and feel along with other search relevance, and infrastructure flexibility enhancements that demonstrate the support for Search-First approach to migration.

Organizations that are overwhelmed by the thought of migrating the substantial content they house in SharePoint 2016, 2013, 2010 or SharePoint 2007 farms will be encouraged by a Search-First approach. This strategy does not require any changes to the existing infrastructure and provides a mechanism for content to remain in current repository while the technology and search engine for the enterprise takes a leap forward. After understanding the improvements in UI and UX, relevancy and infrastructure it’s easy to see why customers would be looking to implement a Search-First approach to deploying or migrating to SharePoint 2013.

The Search-First Approach to SharePoint 2013 Migration and Upgrade Infographic

Search First Approacht o SharePoint Migration and Upgrade

 

Feel free to share this SharePoint Search First strategy to upgrade infographic in your blogs or in social media.

More to come later!

Enjoy!

Joel

Additional Reading and References on Search and Search-First:

Search-first migration from FAST Search Server for SharePoint 2010 to SharePoint Server 2013

TechNet: What’s New in SharePoint 2013 Search

TechNet: Administer Search in SharePoint 2013

Collabshow.com: What’s New in SharePoint 2013 User Experience?

What’s New in Search in SharePoint 2013?

Essential Guide to Enterprise Search in SharePoint 2013