Advanced Flow – Daily Service Request Emails with Status Groups and Counts

After my Advanced Flow session at the Microsoft Ignite Hong Kong, an attendee asked me about a specific update that could be done to the demo. What she wanted to do is add some additional information to an auto-generated email, namely not just showing data grouped together, but also showing the count of the items within a group. If you’re curious about the overall demo in general, you can review Details

Study Guide – MS-300 Deploying Microsoft 365 Teamwork

Update 13 May 2019: In case I find other good study guides online, I’ll link to them from here,Here’s another study guide by fellow MVP Vlad Catrinescu. While a good number of links are the same for both our guides, she also linked to a few other resources, so check it out:https://absolute-sharepoint.com/ms-300-study-guide-deploying-microsoft-365-teamwork This week I took the MS-300 Deploying Microsoft 365 Teamwork beta exam. This exam addressed the areas Configure Details

PnP PowerShell script samples for SharePoint & Office 365

Over the past few years, I have been using the PnP PowerShell cmdlets quite regularly. They’re a constant companion in all my projects, and very often they’ve helped me to solve issues, automate tasks, and generally simplify my life. Examples include: Setting SharePoint Online Site Collection Search Settings with PowerShell Exporting SharePoint Online List/Library Detail Get Versioning Details for all Lists in a SharePoint Online Site Getting all Permissions Levels Details

Increased Path Length for Files in SharePoint Online and OneDrive

Update: I added a small script below to create a folder structure in a tenant so that you can test the new limit Yesterday, Microsoft announced another small but great change to SharePoint Online and OneDrive: in previous versions of SharePoint you were limited to a maximum path length of 256 characters. This meant that if you had a very deep folder structure, potentially also with long file or folder names, Details

Setting SharePoint Online Site Collection Search Settings with PowerShell

Today, we’re going to have another quick look at the wonderful world of PowerShell and how the PnP PowerShell cmdlets make our life a lot easier when administrating SharePoint Online. I had a couple of site collections that needed to have their Site Collection Search Settings updated to use a dedicated Search Center. While it would be possible to manually go into each site collection and update the settings, this Details

Office 365 Advent Calendar – 24 Office 365: Overview of Services and Applications

I’ll finish this year’s Office 365 Advent Calendar with a small overview of the Office 365 Services and Applications. Basically, the following document contains all current services and applications with a short description. You can use this document as a starting point for your organization, your customer, or anyone else with whom you want to discuss the Office 365 suite. Office 365 – Overview of Services and Applications (pdf)

Office 365 Advent Calendar – 23 Bulk-updating File Extensions in SharePoint Online with PowerShell

Scenario A short while ago, I had to update a fairly large number of documents in multiple libraries in a SharePoint Online site. Problem was that their file extension was .html which doesn’t display in the browser if stored in SharePoint Online, but rather these files get downloaded upon opening. The workaround – rename them to .aspx. The following scripts does this for all .html files and renames them to Details

Office 365 Advent Calendar – 22 Modern and Classic Experience in SharePoint Online

Earlier this year, Microsoft announced and rolled out the modern experience for lists. They didn’t stop at that, but also introduced modern pages and sites. But what are the differences to the ‘classic experiences’, so the type of lists, libraries, pages, and sites that we’ve been using now for many years? How can you switch between these two experiences? And how can you customise the modern experience items? Luckily, there’s some Details

Office 365 Advent Calendar – 21 Get all Instances of a Web Part in a SharePoint Online Site

Scenario Sometimes you may need to figure out where a specific type of web part has been used. Today, I’ll show you how you can check all pages in your Site Pages library for a specific web part. I’ve had this code for a while as I was looking for some specific web parts (Content Editor) before. Yesterday, I briefly saw a blog post on dev.office.com announcing the deprecation of the Details

Office 365 Advent Calendar – 20 Get notified about new SharePoint Online Site Collection Administrators

If your organization provides business users with the possibility to manage sites themselves by assigning them site collection administrator rights, you may want to know if they add anyone else as site collection administrator. While you could run a script regularly to retrieve a list of all site collection administrators on all sites and then compare this data with previous information, there is also an alternative that you can use. Details