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