Office 365 Advent Calendar – 14 Exporting SharePoint Online List/Library Details

Well, this is a bit embarrassing. Yesterday, for the first time, I didn’t verify if my scheduled blog post got published properly. And yesterday, also for the first time, it didn’t get published. I made a small scheduling mistake (it’s not 2017 yet…), so the 14th December post comes a day late: Scenario From time to time you may need an overview of all lists and libraries in your site Details

Office 365 Advent Calendar – 11 Adding sample items with random data to a SharePoint Online List

Scenario Sometimes you want to create some random sample data to be used in a SharePoint Online list. For example, in yesterday’s post I was using a list with some data which I entered manually, but I thought afterwards that I could’ve scripted it to create many more items in my demo list. Today, I show you how you can easily fill a list in SharePoint Online with as many Details

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 – 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

Getting your Office 365 tenant’s SharePoint site structure with PowerShell

Update 12 June 2018: Updated cmdlets to follow the newer PnP naming standards (e.g. Connect-PnPOnline instead of Connect-SPOnline). Introduction From time to time you may want to get an overview of the structure of your SharePoint Online environment. That is, you want to know the number of site collections and subsites, and know how they are organised. While you could review the existing site collections either in the UI (not Details