Matthew McDermott’s Blog

Link to Post

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 →

Link to Post

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 →

Link to Post

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 →

Link to Post

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 →

Link to Post

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.

Read More →

Link to Post

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 →

Link to Post

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 →

Link to Post

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 →

Link to Post

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 →

Link to Post

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 →

Let's Get In Touch!


Ready to start your next project with us? That’s great! Give us a call or send us an email and we will get back to you as soon as possible!

+1.512.539.0322