• M365 Community Content

    There is a huge amount of great content available at https://docs.microsoft.com/en-ca/microsoft-365/community/ This repository is here for YOU. The goal is to build an open source set of content to help people like Information Architects, Business Analysts, “Makers” (aka Citizen Developers), and Site Owners who want to use the Microsoft 365 platform better. The authors are […]


  • SharePoint Syntex Setup

    Admins can use the Microsoft 365 admin center to set up Microsoft SharePoint Syntex. Consider the following before you start: In which SharePoint sites will you enable form processing? All of them, some, or select sites? What will you name your default content center? You can change your settings after initial setup in the M365 admin center. Prior to […]


  • SharePoint Calculated Columns IF formula builder

    One of my most popular blog posts is originally from 2012 and focuses on SharePoint Calculated Column formulas: SharePoint Calculated Column Formulas & Functions – The Essential Guide – Tuomi Services Ltd. While many of the questions people ask in the comments are asking about esoteric formulas or some weird quirks, a lot actually can […]



  • Office 365 Security – Capabilities & Planning

    Moving to the Cloud can introduce new concerns. In this post, i’ll help you address your unique organizational security standards, framed against the products and capabilities of your Office 365 services. While Microsoft has invested heavily in securing their platforms against cyber attacks, they operate with a shared responsibility model in which the customer is […]


  • Office 365 Internet Zone Settings

    This is a follow-up to my 2015 post about the recommended IE Internet Security Zone settings for maximum user authentication happiness. On the post https://tuomi.ca/2014/06/23/overcoming-sticky-logouts-office-365-azure-windows-intune-web-browser/, I tried to rationalize IE security settings relating to Office 365. Here’s a good explanation of why we should care, as quoted from the more recent MSFT post: “Starting with Windows […]


  • SharePoint Online Search Word Breaking

    Recently I was asked if search in SharePoint Online would return two results for words separated by hyphens, dashes, or other characters. For example, we’d like to know if  entering the search phrase “committal” will return both “noncommittal” and “non-committal” The answer is, it depends on the specific Search scenario and configuration. It’s indeed an […]



  • Preview of smart diagrams for Visio

    Although first announced back in October, i’d like to bring awareness to the following awesomeness coming from the Visio team. They are still looking for people to try out the new smart diagrams feature and provide valuable feedback: Introducing early preview of smart diagrams from Visio for Windows We are pleased to announce an early […]


  • Troubleshooting MS Office Install issues (MSI & Click-to-Run)

    Here’s a shortlist of some useful troubleshooting techniques, divided into two sections according to the two main types of MS Office Installations: MSI: “Traditional” Windows installer Click-to-Run: Office 365 installed MS Office MS Office MSI Install Troubleshooting “Verbose logging” is a setting that exposes more information during the installation process. It will capture “warning” as well […]