Check length (duration) of Microsoft Teams meetings

Microsoft Teams admin center user call history report

Want to track how long you spend in Microsoft Teams meetings or have a request from a user for some stats? Luckily, it's actually quite easy to get the meeting durations for any user in your tenancy. Common scenarios for needing meeting duration Ok, some of these might not be common but I have seen … Continue reading Check length (duration) of Microsoft Teams meetings

Enable ‘+’ plus addressing in Exchange Online

M365 Roadmap - Support for plus addressing in Exchange Online

One of the most requested features on Microsoft's UserVoice forum was the Support for Dynamic '+' Email Aliases in Office 365. This has been pending since 2017 and Microsoft finally implemented it in September 2020. Woohoo! However, it's not enabled by default in Exchange Online, so we'll have to turn it on. What is '+' … Continue reading Enable ‘+’ plus addressing in Exchange Online

SharePoint – Extending app only secret lifetime

Perhaps you need an app principal to be able to access a particular SharePoint site? You could be using the great SharePoint PnP PowerShell module and you want to connect via an AppId and AppSecret. You've got two choices: Grant access using Azure AD app-only Microsoft's preferred method when using SharePoint Online. All you have … Continue reading SharePoint – Extending app only secret lifetime

Exchange – Connect via PowerShell using Modern Authentication

connect to exchange via powershell

Microsoft announced a while back that they are going to end support for basic authentication in Exchange Online from Oct 13, 2020. This includes connecting via remote PowerShell. So what do we need do in order to connect to Exchange Online using PowerShell? Answer: Use Modern Authentication. Modern authentication is based on the use of … Continue reading Exchange – Connect via PowerShell using Modern Authentication

SharePoint – Automatically set the time zone on all new sites

By default, all SharePoint sites created in SharePoint Online are set to the United States time zone and locale. In the past, you had to either manually or programmatically set the timezone, region and locale for every site including all sites generated by the creation of an Office 365 group. The good news is now … Continue reading SharePoint – Automatically set the time zone on all new sites

Office 365 – Getting groups a user is an owner/manager of

Recently I've been building an SPFx app that allows a user to see what groups they manage and allow them to bulk update the membership via CSV. One of the first hurdles was to get all the groups the user is an owner/manager of. This needed to work with all group types: Office 365Distribution *Mail-enabled … Continue reading Office 365 – Getting groups a user is an owner/manager of

Exchange Online – Enable group moderation and sending restrictions

Exchange Online - Group Moderation

Whether it be a large group or one that has restricted users, you may need to limit who can send to these mail enabled security groups. In addition, you may even want to enable moderation to allow specific users to approve/deny messages from reaching the members. The good news is that all this can be … Continue reading Exchange Online – Enable group moderation and sending restrictions

Exchange – Application cannot be started when installing Exchange Online PowerShell Module

We've recently enforced MFA for admin accounts that connect to Exchange (and other O365 Services). This means that in order to connect via PowerShell we need to install the Exchange Online PowerShell module. Instructions provided by Microsoft can be found here: https://docs.microsoft.com/en-us/powershell/exchange/exchange-online/connect-to-exchange-online-powershell/mfa-connect-to-exchange-online-powershell?view=exchange-ps However, when I tried to install the module I kept receiving the error … Continue reading Exchange – Application cannot be started when installing Exchange Online PowerShell Module

Microsoft Teams & OneDrive – Fix issue with Excel date formats

I work in a UK based company and we've recently been using Microsoft Teams more and more, which for the most part has been great. However, whenever someone edits an Excel workbook within the Teams web (or desktop) app, they realise that datetime values are in the US format (MM/DD/YYYY). This seems to happen even … Continue reading Microsoft Teams & OneDrive – Fix issue with Excel date formats

Exchange PowerShell – Get calendar folder permissions in any language

Getting a user's calendar folder permissions in Exchange via PowerShell is pretty straight forward as you can just use the standard ':\Calendar' naming convention like below: Get-MailboxFolderPermission -Identity [email protected]:\Calendar This works fine if the user's mailbox language is set to English but what if they have it set to something else, like perhaps German? Well … Continue reading Exchange PowerShell – Get calendar folder permissions in any language