Progress Bars with SharePoint Online Column Formatting

Now that Column Formatting has begun rolling out to SharePoint Online tenants, I decided to look at some older use cases and test how they could be achieved with this new functionality. The first use case is a common one: an item’s progress is tracked in a list with a percentage indicator – a project’s total completion so far, an individual task’s progress, etc. This is usually stored as a Details

Office 365 Advent Calendar – 18 Adding a Web Part to a SharePoint Online Page with PowerShell

Scenario You’ve got a Web Part which you want to add to one, but more likely multiple web part pages in a SharePoint Online Site. Or maybe even on multiple pages across multiple sites. You could do this manually, but adding the same web part with the same configuration over and over again may not be a productive use of it. Let’s make use of PowerShell to do this! Code Details

Office 365 Advent Calendar – 17 Overview of the new OneDrive for Business Admin Portal

At the Microsoft Ignite conference in September, it was announced that OneDrive for Business would get its own Admin Portal in Office 365. Yesterday, Microsoft finally made it available, even though it’s in Preview at the moment. See the official announcement here, and access it at https://admin.onedrive.com. So what does it include? Some existing settings, such as configuring your sharing settings, as well as new settings like the possibility to restrict Details

Office 365 Advent Calendar – 04 Moving/Copying files within SharePoint Online Libraries

Scenario You have a couple of files within a SharePoint Online document library which you want to move within the same library, for example to a new folder. Steps Note: The following steps are only available in the ‘Modern Experience’ for document libraries. If you’re still using the ‘Classic Experience’ (for example because your tenant settings have been configured to use Classic), then you can’t make use of this new Details

Office 365 Advent Calendar – 03 Programatically accessing a SharePoint Online Recycle Bin

Scenario You’ve got a big amount of items in the recycle bin of a site which you want to access. For example, a user accidentally deleted hundreds of files, and now you want to restore them back easily. Or you have a thousand items in the recycle bin and you want to export some information (which items are in the recycle bin, who deleted them and when) to Excel Code Details

Office 365 Advent Calendar – 02 Retrieving SharePoint Online Site Collection Sizes

Scenario You want to get an overview of the storage usage of all site collections in your tenant, similar to what you can see in the “SharePoint Administration” section in Office 365. But as you may have hundreds of site collections, or as you want to pass on that information to someone else, you want to extract this information into a spreadsheet Code $cred = Get-Credential Connect-PnPOnline -Url "https://mytenant-admin.sharepoint.com" -Credentials Details

Office 365 Advent Calendar – 01 Getting all Permissions Levels in SharePoint Online

Scenario You want to get an overview of all Permission Levels that are set up in your tenant’s SharePoint Online site collections. Not only the out-of-the-box permission such as “Full Control” or “Read”, but also any custom permission levels which may have been defined by your site collection’s administrators (“Add Only” is a common example). Code A prerequisite for this code are the OfficeDev PnP PowerShell cmdlets. Ensure that you have Details

Office 365 Advent Calendar – 24 Days of Goodies

Christmas is approaching, and I’ve decided to spread some joy and share some knowledge  by running an Office 365 Advent Calendar on my blog from December 1 – December 24 2016! This means that on each of these days in December, I’ll publish a small blog post with some Office 365 goodies – PowerShell scripts, helpful advice, guidance, …. While the content will mainly be focused on SharePoint Online, the other Office 365 Details