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…

Restore Recycle bin SharePoint Online with PowerShell

One of my users deleted a whole document library containing more than 12000 items. He synced the folder to his desktop, to find out it was way too big. Unfortunately, he deleted the items from his desktop without stopping the synchronization first. You can restore items from the recycle bin in SharePoint Online, but this many items can easier be done…

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…

Manage Office 365 Group Members and Owners with PowerShell

With PowerShell UnifiedGrouplinks cmdlet we can easily manage the Office 365 Group member- and ownerships. The UnifiedGroupLinks cmdlet is part of the Exchange Online PowerShell session. So before we can start adding Office 365 Group Members or change them to Owner we first need to connect to Exchange Online. Connecting to Exchange Online First we need to connect to Exchange Online, you…

Copy Sharepoint list items to another list with Powershell and PnP

You can easily copy Sharepoint list items to another list with Powershell and PnP. First connect to the source Sharepoint site. You can use one of mine connector scripts for it here at Technet. Or connect to Sharepoint with:

Get the list items Now we need to retrieve the list items that we want to copy:

Copy the items…

Share Sharepoint files and folders from a Office365 Group

Sharing files in Sharepoint, that shouldn’t be that hard right? Well if you are using Office 365 Groups you might have noticed that you are not able the share a file or folder from the Groups Sharepoint site to external users. When you try to use the Invite People option you will get the following error: Your organization policies do…

Show duplicate content in SharePoint Online Search Results

Are you not seeing all results when searching for documents in Sharepoint? Are you confident that there is another, newer version? Then probably it’s filtered out by Sharepoints duplicate content removal in the search results. A document does not have to be 100% similar to be flagged as duplicate, similar documents or sites seems to be removed also. You can’t…