Office 365 is clearly popular. In fact the new Okta 2019 Business at Work report lists it as the clear leader in the cloud SAAS space for the past 5 years. It’s an incredible commanding lead at this point, but while that may help comfort you in your decision to deploy it isn’t enough to call it mission successful as 76% of customers in their report also some have overlapping solutions including duplicates such Box, Google Apps, and Salesforce. In addition, in an AIIM report focused on adoption and enhancing Office 365, has concluded in their summary the need to enhance your implementation
Chart Courtesy of Okta Business at Work 2019 – it’s truly a must read… I’ve been following their annual reports, and they are great.
AIIM Research www.aiim.org/research survey for responses from 124 individual members of the AIIM community during the month of November 2017. In the report, they share Forty-four percent report their users like it. It makes sense why in a subscription model, Microsoft is so focused on adoption and consumption of the workloads. The overlapping solutions also were exposed in the AIIM research, “Fifty-five percent of our respondents agree that getting users to manage and share their content in Office 365 and no place else is their biggest on-going issue [while] Forty-six percent feel that lack of expertise is the biggest issue.”
“Use add-on, and auxiliary products and services to supplement out-of-the-box functionality and lack of in-house to maximize your investment and transition to Office 365 and fill the gaps where they are needed.” – AIIM Research
In my conversations with Apps 365 on their solutions and their success in the ecosystem they shared how they have been addressing Gaps exposed by the product. It’s not unusual in fact Microsoft has a very rich ecosystem and welcomes partners to address gaps in the product. These could be considered enhancements or things that may eventually come on the roadmap, but customers who hold their breath waiting for unannounced features may be disappointed and may want to consider proven solutions. The AIIM research suggested 30% or more customers are looking to implement two or more third party add-ins in the next 12-18 months and more than 20% have already deployed one or more add-ins.
The Conclusion from AIIM research lines up with the emphasis Microsoft has put on it’s rich ecosystem… “Use add-on, and auxiliary products and services to supplement out-of-the-box functionality and lack of in-house to maximize your investment and transition to Office 365 and fill the gaps where they are needed.”
There are really three areas of focus in addressing Gaps in Office 365: Expertise, Staffing Resource, and Tools.
The new certifications can help you with your expertise gaps, as well hope to see you at the SharePoint Conference 2019 use discount code OLESON if you register to save yourself some money, the resources are something the many many partners can help you with, feel free to reach out for local or regional recommendations, and the tools gap is filled by the immense vendor partner network such as in the app store. Consider these gaps in the graph below…
Apps 365 is sponsoring a webinar where we’ll be diving into the Microsoft Roadmap and in helping you understand the Gaps and Solutions.
New Webinar – 2019 YEAR OF THE LIST: Five Top Futuristic SharePoint List Trends to Follow in 2019
“We’re excited to host our first webinar from the ‘Mind The Gap’ webinar series with Joel Oleson, MVP who will be highlighting the Five Top Futuristic SharePoint List Trends to Follow in 2019.”
When: Mar 13, 2019 1:00 PM Pacific, 4:00pm Eastern
Here are the 5 Trends we’ll be covering…
1: Automated Transcription and Enrichment
2: File Sharing Compliance Enhancements
3: Search & Findability Enhancements
4: Client-Side Enhanced & Extensible List UI
5: GPS 1and Location Metadata
Community FlashMob at #SPC19 Ministry of Silly Walks
Join @JoelOleson, @EricaToelle, @HeatherNewman, @PaulSwider, SPCPartyPatrol and a bunch more at the community at the SharePoint Conference Ministry of Silly Walk (click here to register to join us).
Apps 365 is providing a bunch of Monty Python Ministry of Silly Walks T-shirts. You can find out more about that on my post about the Ministry of Silly Walks at #SPC19.
It’s incredible how much effort Microsoft has put into so many new tools. People’s heads have been spinning around all of the new tools in Office 365. The most important tools as it relates to Application development are the Office 365 Power Tools.
This infographic is designed to help you understand which of the Power Tools to use when… Apps, Forms, Workflows, Reporting, and More this simple infographic is designed to make it easier to understand.
If you like this Infographic you can download it and use it in your internal decks and training materials. Simply right click on the image and save it.
Feel free to use it in your SharePoint Saturday and event decks as well. It is shared Creative Commons Share with Attribution… Just let ’em know you got it from Collabshow.com
If you like this Infographic you may also like the companion Infographic on Microsoft Forms Limits and Boundaries
Looking for more? Join the Webinar where I’ll dive deeper into the comparisons between Forms and Forms Pro, Flow and Flow Premium, Power Apps and developmental scale challenges.
This Webinar is not designed for the hard core developer whose been using these tools day in and day out, but for the Power Users and those trying to get their heads around the differences in the Office 365 Power Suite of Tools.
And Now for Something Totally Different… Those who know me know I’m a HUGE fan of community and love to put on silly things. Some remember the Infopath funeral for good or for worse. Others may remember the year we sang our hearts out “Don’t Stop Believing” when we were concerned SharePoint was taking a back seat to things like Yammer and becoming simply “sites” in Office 365.
This year I want to do something totally different and even more Silly.
I’m assembling a Ministry of Silly Walks for a Community March Through the Exhibit hall at #SPC19 on the first day May 21 at lunch time. Eat your lunch quick and meet us at the entrance of the expo hall… don’t miss the music. We start marching at 1:01pm sharp.
What is a Silly Walk? Haven’t heard of Monty Python? It’s an international Phenomena see more on the Monty Python website on International Marches. I want this to be the biggest one ever.
I’m looking to recruit the true Monty Python Fans. For those of the Organizing Committee Ministry I will get us Bowler Hats and Mustaches. I’m working with Apps 365 as sponsor for T-shirts for attendees. They are totally on board and love it. Any other vendors who want to help. Please reach out. We can always use more swag.
When: May 21, 2019 at 1PM Pacific Time (Las Vegas)
Where: MGM Grand SPC Expo Hall Entrance (more details provided to those who register, but registration is not required)
What should I bring: Plan to bring a funny hat, suit coat, umbrella, and whatever other silly props along with your best silly walk
Remember to register on #SPCSillyWalks on Eventbrite or on The Facebook Events for #SPCSillyWalks
Not yet involved at SPC? Get registered and use my invite code for a discount. It’s going to be a blast. I’m speaking on SharePoint Search. More on that in another post.
Want to be part of the Flying Circus Band? I’m looking for Flying Circus style Tuba player, Trombone player, and a whistle chorus etc… (Song is “Always look on the bright side of Life”) various percussion options.
If you’re absolutely confused. It’s probably a problem with your walk and we at the Ministry can help you with that.
Reach out to me email@example.com or on twitter at @joeloleson
Need some practice or inspiration on Silly Walks?
Here’s some history on Silly Walks
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.
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 this infographic on Microsoft Forms Limits from slideshare as a PDF or as a JPG from this blog post, simply right click on the image and choose save.
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 where I will dig into the differences between each of the Power Trio and Forms and Forms Pro (what little we know from recent news).
Webinar on March 7, 2019 at 11am Pacific
Sponsored by Crow Canyon.
Register free << RSVP – register >>
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.
Join Microsoft MVP Joel Oleson with Scott Restivo, CEO of Crow Canyon Software to explore the core of Office 365 tools and dive into the fundamentals of business applications. In this session we’ll: 1). Demystify the tools and reveal limits in application construction and look at when to use what in your biz app lifecycle. 2). Focus on fundamentals and directing when to use what in your tooling and fundamental approaches and provide you with some great take-away’s in the form of Infographics. 3). Finally, we’ll explore the interconnected nature of business solutions from ingestion, business processing, evaluation, reporting, and data analysis in a single platform with integrated tools all in a content services platform. It doesn’t stop there as Hybrid solutions can be constructed with gateways and the power of the cloud allows scale like no other time.
Kudos to Phil Worrell among others who shared their thoughts on things they thought for which people should be aware. I’ve gathered theme here from various social platform (in comments) who had some additional “Feature” differences and things to be aware of…
More Forms Limits or Desired Features
Remember these are subject to change. In fact, have may have heard about Forms Pro? We should hear more about this solution, but as you look at what they’ve shared it doesn’t appear to be focused on addressing the things we’ve called out here. Keep reporting things you care about and voting on User Voice!
Read more about the recent announcement of Microsoft Forms Pro
Microsoft Forms Pro highlights:
“This enterprise survey tool makes it easy for organizations to collect feedback across customer touchpoints using surveys, quizzes, and polls, correlate the feedback with business transactions, and derive actionable insights from the combined data,” wrote Alysa Taylor, Corporate Vice President, Business Applications & Industry at Microsoft.
Microsoft Forms Pro will be available in public preview this spring .”
When I first moved to California, there was one person who made a big impression on my life and it’s never been the same. Tom Castiglia, President of the SharePoint User Group, and Founder of the .NET User Group in San Diego was all about community. The first month I was there I had offered to help Tom and the SharePoint Saturday San Diego event committee. I had some crazy ideas about doing a speaker party on the beach with fusion Hawaiian food and fire and hula dancers. Tom didn’t shut me down despite the fact I accidentally planned a trip to Colombia and Bolivia over the top of that weekend. I heard everyone had a great time, but Tom helped me pull it off without hesitation.
Up bright and early for SharePoint Bloggers breakfast before the keynote and on the second row… Tom had Passion!!
The next month I was at the User group with some rough news. I was in the middle of trying to buy a house with an unknown closing date. It was during the committee meeting for the user group that I brought up I was out of work and looking. I didn’t really have any time to make anything happen… Tom reached out and I believe he stuck his neck out to take a chance on bringing me on at the small San Diego based business. A day later I was talking to Neal and Arjay and the following Monday I was working with him at Hershey. I was able to keep our house and with no drama my prayers were answered.
Some of the Hershey SharePoint team at a recent little reunion.
We’d share a room at the upcoming Ignite event, and nearly every waking moment of that event we were together. My SharePoint friends were his friends, and the San Diego User Group and SharePoint crew got really tight. Haaron Gonzales, Chris Givens, Randy Williams, Galen, Tony, Ron… you couldn’t find a tighter community. We adopted David Leveille when he moved to San Diego. He had a client in San Diego and lived with Tom and Martha for over a month. Who does that? Tom (and Martha). 1
While I was working with Tom at Hershey we had more than a few lunches together. We shared a lot together. I saw his work ethic first hand. A hard worker with a passion for community and friendships. He told me all about his Old Pros group, and I saw it first hand. Those guys would do anything for each other. Very tight knit group.
The next year in Atlanta for Ignite, Tom, Galen and I got glowing light sabers and we fought with our lazer swords under the laser light show. Tom believed in my crazy ideas and backed me up when I was feeling spontaneous. That’s a rare thing.
I went to more baseball games with Tom in the past few years than the rest of my life combined. He sure loved baseball.
Tom knew how to make people feel wanted and how best to organize an event. Last years SharePoint Saturday San Diego Zoiner opened his home for the speaker dinner. It took things to a much more personal level. Something I’ve strove for. This community is more than a bunch of geeks. It’s family. We all know that.
It didn’t take much to convince Tom to join me on a crazy adventure to SharePoint Saturday in Cuba.
Politics doesn’t divide the SharePoint Community. Tom, Rob, Chris and I met with the Cuban SharePoint folks who sacrificed to tell their stories. I cherish the memories of walking through the dark streets of Havana with Tom. He put a lot of trust in me. It was one of the first times they’d left Ben alone and for so long. Tom tells the story that Ben had a secret, but due to their strong relationship, he couldn’t hold it a secret for long and Tom would handle the situation like a good father would.
Tom was the glue that has kept the community here in southern California together. Through ups and downs and thick and thin… Even when Microsoft said we couldn’t keep meeting in San Diego, he pushed to get us what we needed to keep going. He has put his own money into buying pizzas on more than one occasion, traveling to SharePoint events all over the country and beyond. His impact cannot be measured. As a Nintex vTE he helped people for free all over the world, and those developers and engineers are deeply indebted to his graciousness and technical knowledge.
Tom invited me and a few SharePoint friends to his 50th birthday party. This wasn’t the first birthday he invited me to. During the first year we moved here, he invited me into his home and my little boy Dean danced and danced at his party. We all felt comfortable at Tom’s house… We could be ourselves. Being at Tom’s house belt like being at home… being there felt like family.
Only a week ago, Tom helped me do some shopping and helped me throw the biggest party I’ve ever had. I had commitments on Thursday and Friday and he took time out of his week to go shopping mid week. Super nice guy. Tons of Love. He opened his heart and we’ll never be the same. I miss my friend, but know he’ll be waiting for us all for a big party on the other side… with a brass cup and some ginger beer. I’m sure he’s working with the Angels on their Records Management in the meantime.
Tom, I’ll miss your non judgmental smile and your never give up and do what it takes to make it work personality. I promise to do what I can to keep the community together, and I’ll never forget the way you made us all feel… loved.
If you know or were inspired by Tom, I invite you to attend Tom Castiglia’s Funeral which will be on Tuesday February 5th at 10am. http://tomcastiglia.eventbrite.com
Saint Gregory the Great Church, Scripps Ranch, 11451 Blue Cypress Drive, San Diego, CA 92131