AzCopy Introduces File Synchronization As a photographer I needed an inexpensive way to protect my image files. AzCopy now has a sync option that works well. Here is how to set it up. This is the “nuts and bolts” approach to get you up and running one time. Later, I’ll show you how I schedule the synchronization. There are 4 steps. I assume that you already have an Azure tenant and know how to create an Azure Storage Account for your Blobs. Read More →

The Problem Working with PowerApps and Managed Metadata Columns in SharePoint online can be a huge pain. Turns out custom sort order in the Managed Metadata is not supported, but you can force a sort order in your app. Limited Support for Managed Metadata I have tried several solutions to the apparent issue that Custom Sort Order in Managed Metadata Fields is not supported. Here I have a list of Payment Methods sorted in the Managed Metadata term store using a custom sort order. Read More →

Generate a PDF from Microsoft Flow Recently I have been asked by a few clients how to create PDF files from SharePoint Online List Items. At first, I was perplexed by this request, it is not something I ever need to do. After a few probing questions, I found that they were using SharePoint in very cool ways and one, in particular, was tracking trouble tickets and then generating an “after action report” for distribution to their customer as a PDF via email. Read More →

Jeremy Thake and a bunch of search geeks got together and produced a great guide for creating an Employee Directory. Get your copy from Hyperfish at: https://www.hyperfish.com/employee-directory-signup This will get you a copy of the guide and a link to download the files. He and Mark Anderson also did a whole podcast on the topic. (https://blog.hyperfish.com/employee-directory-in-office-365-and-sharepoint-) There is a ton of great information in the guide and a step by step walk-through of the process. Read More →

I was asked to have a look at an old unanswered question on Stack Exchange: “Can you create a Query Rule that matches in the middle of the query?”. Challenge accepted. I looked at all of the other options and they either match the beginning, the end, or the entire query. This was SharePoint Enterprise. Good thing. SharePoint Online does not support RegEx in Query Rules, but SharePoint Enterprise does.

I have been working on a client’s project using Azure Automation and Flow to stitch together a solution for easily managing default column metadata in SharePoint Online. (More on that later.) I am using the PnP PowerShell to handle the heavy lifting in my automation scripts. One component I was struggling with was writing complex values back to the list that originates the flow. Specifically, I encountered issues when setting the value of a SPUrl field when the URL contains a comma. Read More →

I have a client who is transitioning from SharePoint on-premises search to hybrid search with Office 365 and SharePoint Online. They are looking forward to removing several servers from their farm that are currently dedicated to the Indexing and Content Processing roles. They plan to collapse their Search Topology down to two redundant crawlers. This simpler topology is one of the big benefits of Hybrid Search with the SharePoint Cloud Index. Read More →

This is part 5 of a multi part series on how to use Content Types and SharePoint Search to build search solutions. In this series, I am using the case of a Site Directory as the example. If you are looking for the entire series, start with “Stop Using the Property Bag” to understand my point of view. Then read Search Based Site Directory: Part 1, Search Based Site Directory: Part 2, Search Based Site Directory: Part 3, and Search Based Site Directory: Part 4 to build your content type and prepare the Managed Properties for this article. Read More →

This is part 4 of a multi part series on how to use Content Types and SharePoint Search to build search solutions. In this series, I am using the case of a Site Directory as the example. If you are looking for the entire series, start with “Stop Using the Property Bag” to understand my point of view. Then read Search Based Site Directory: Part 1, Search Based Site Directory: Part 2 and Search Based Site Directory: Part 3 to build your content type and prepare the Managed Properties for this article. Read More →

This is part 3 of a multi part series on how to use Content Types and SharePoint Search to build search solutions. In this series, I am using the case of a Site Directory as the example. If you are looking for the entire series, start with “Stop Using the Property Bag” to understand my point of view. Then read Search Based Site Directory: Part 1 and Search Based Site Directory: Part 2 to build your content type for this article. Read More →