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 – 13 Useful Office 365 Sessions from Microsoft Ignite
End of September, the Microsoft Ignite conference took place in Atlanta with hundreds of sessions across a huge rang of Microsoft products. The great news is that these sessions are available on demand for anyone to view! If you’re interested in taking them offline, have a look at the Ignite 2016 Slidedeck and Video downloader script. Today, I’ll share with you some of my favourite sessions: Drive productivity with OneDrive and Details
Office 365 Advent Calendar – 12 Get External Sharing Details for SharePoint Online Sites
Scenario SharePoint Online allows you to share your content with external parties – that is, if sharing is allowed on the tenant level as well as on the site collection level. But if you allow external sharing on the tenant level, how can you easily see for which site collection you have which kind of external sharing level enabled? Code Today’s script doesn’t make use of the PnP PowerShell cmdlets, 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 – 09 Staying up to date on Office 365 Changes
When you use Office 365, there’s on thing that’s certain: change is constant, new functionalities get introduced all the time, and the pace of updates is much higher than in your own environment. In this post, I’m showing you how you can stay up to date on any changes to Office 365 to ensure that you can provide a great service to your users. With your on-premises systems, you are 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 – 07 External Sharing for SharePoint Online FAQ
SharePoint Online provides you with the option to share content (sites, lists/libraries, documents) with externals – partners, vendors, customers, basically anyone outside your organization. Here are some Frequently Asked Question I’ve seen regularly: How do I get started with learning more about External Sharing? To get started, review the following 2 Microsoft support articles: Manage external sharing for your SharePoint Online environment Share sites or documents with people outside Details
Office 365 Advent Calendar – 06 Bulk-Uploading Files with Metadata to SharePoint Online
Scenario A very common scenario is that you have multiple files that need to be added to SharePoint together with some metadata. One way of achieving this is by uploading all files to the target library, and then using the Quick Edit functionality to update the metadata for them. However, this is a bit cumbersome, especially when you do not just have a few documents but potentially hundreds of them. This solution 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