Working with expression in Microsoft Flow

In Microsoft Flow, you can use expressions for every action, switch, or condition and to manipulate data. Using this in combination with variables allows you to do some cool and very useful things (calculating dates, manipulating strings, extracting parts of a string and a lot more). A small tip upfront, I like to write the expression in notepad. The input field…

OCR email attachments and store them on SharePoint

Microsoft Flow is a great tool to automate a lot of you daily, repetitive tasks. I stumbled on such a task at one of my clients. They receive an email with an attachment in a shared mailbox. One of the employees downloads the attachment and stores in a SharePoint folder. Nothing really special and easy to create with Microsoft Flow. But…

Exchange Online and Apple Mail

Most Apple users really like the Apple Mail application and don’t want to switch to Outlook when they buy Office 365 or Exchange Online. And that is not necessary either, but connecting the Exchange Online mailbox in Apple Mail can be tricky sometimes. On some clients, the autodiscovery feature is not working correctly. Also adding a shared mailbox is a little…

Office 365 Business Plans – What you need to know

For small and mid-size business are the Office 365 Business Plans the best fit. There are three business plans within office 365, Business Essentials, Business and Business Premium. But which plan do you need, what are the important differences and how do you decide which one you should buy? This article will explain the differences between the Office 365 Business…

Office 365 F1 vs E1 Plans Compared

Microsoft replaced the Office 365 Kiosk version for the Office 365 Firstline workers. With this new option now available, should you buy the F1 license or it better to spend the few extra dollars and go for the E1? So let’s compare Office 365 F1 vs E1 and figure out when you should buy the one or the other. This…

Office 365 E1 vs E3

What are the differences between Office 365 E1 vs E3? Below you will find the major differences to help you choose between the two enterprise version. I added a comparison chart at the end of this article so you get a nice overview of the major differences. If you want to compare all the Office 365 version, make sure you…

Get Team sites & Create Document Library in SharePoint with PowerShell PnP

I needed to create a new document library to all our project related SharePoint Team sites. We use Office 365 Teams for both business units as for our projects, so first we need to get a list of all Team sites within the tenant, then check if the site is a project related Team site to finally add a new…

Managing email addresses with PowerShell

One of the most common tasks as an administrator is to find, change or add an email address to a user mailbox.  PowerShell makes this tasks a lot easier, you can easily find the users where the e-mail address belongs to and add or remove an alias. In this article I will show you some tips howto find an e-mail…

Office 365 Comparison chart – Business Plans vs F1, E1, E3 and E5

Selecting the right Office 365 version is an important step before migrating to the cloud. There are many Office 365 plans available, so it can be hard to find the right plan for your situation. There are multiple options for business and enterprise organisations, bringing different features and limitations. This Office 365 Comparison Chart reveals the different options that are available…

Export Yammer user profile photos with PowerShell

Yammer allows you to export the users to a CSV file, but that comes without there profile picture. But there is a Yammer API, so with PowerShell and the data from the CSV file we are able to get the profile pictures as well. Export the Yammer Users CSV file First we need a CSV file with all the users,…