Office 365 Advent Calendar – 10 SmartFilters and Grouping in SharePoint Online Modern Lists

Microsoft has just started rolling out a new feature called Smart Filters to SharePoint Online tenants with First Release enabled, all tenants will see it in January. Smart Filters are available in Modern Lists, and allow you to filter from a sidebar pane to easily and quickly find items you’re looking for. What’s the difference to the existing filtering functionality on columns? Smart Filters are not just shown for a Details

Office 365 Advent Calendar – 08 Get Versioning Details for all Lists in a SharePoint Online Site

Scenario By default, libraries in SharePoint Online keep the last 500 major versions of a item, but lists have no versioning turned on. And while you can easily finetune the settings for all lists and libraries in a site, it may be good to know how versioning is set on each library before you look at changing those settings. Today’s post provides you with a script that retrieves all versioning related Details

Office 365 Advent Calendar – 05 Exporting large SharePoint Online List to Excel

Scenario You have a list in SharePoint Online with more than 5,000 items, potentially much more than that. And you now plan to export all that data into Excel, for example for further analysis. The question now is – how do you get all that data out of SharePoint and into Excel? When you create a view to show all items, you’ll get a “The number of items in this list exceeds the 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