SharePoint Online: Bulk Create Dummy Files using PowerShell

Requirement: For a testing exercise, We had to bulk upload 5000+ documents to a document library in SharePoint Online. PnP PowerShell to Create Dummy Files in Bulk in SharePoint Online This PowerShell script bulk uploads the given file with unique names to the root folder of a specified SharePoint Online document library….

Read more

SharePoint Online: How to See Who has viewed a File?

Requirement: See who has viewed a document in SharePoint Online. How to see who viewed a document in SharePoint? Can we see who has viewed a file in SharePoint or OneDrive? Yes! We can track who has viewed a file in SharePoint Online with this nifty feature, “SharePoint Viewers”. To see who…

Read more

Open a Document in Browser instead of Client Application in SharePoint Online

Requirement: Open documents in the browser in SharePoint Online. How to Force Documents open in Browser instead of the Client Application? The “Open Documents in Client Applications by Default” feature and the library settings “Opening Documents in the Browser” decide whether a document should be opened in the web browser or in…

Read more

SharePoint Online: Download Files from a CSV using PowerShell

Requirement: Download all files from a CSV file in SharePoint Online PowerShell Script to Bulk Download All Files from a CSV in SharePoint Online In this blog post, we will walk you through the process of downloading files from a SharePoint Online site. We’ll be using a CSV file as our source…

Read more

Download SharePoint Documents from CSV File using PowerShell

Requirement: Download files in the SharePoint document library from a CSV file to a local disk. PowerShell Script to Download Documents from SharePoint : If you need to quickly and easily download your SharePoint documents from a CSV file, PowerShell is the tool for you. This quick guide will show you how…

Read more

SharePoint Online: Get File Size using PowerShell

Requirement: Get file size in SharePoint Online using PowerShell How to Get the File Size in SharePoint Online? Have you ever needed to get the size of a file in SharePoint Online? Maybe you need to know how much storage space is occupied by a file in your SharePoint Online document library….

Read more

SharePoint Online: Link to Force Download a Document Instead of Open

Requirement: Force download a file instead of opening in SharePoint Online SharePoint Online: URL to Document Download Instead of Open Documents linked in SharePoint Online pages, navigation menu, lists, etc. open in the browser (or in client application!) directly either in Read-only mode or in Edit mode, based on user permissions. What…

Read more

SharePoint Online: Upload Large Files using PowerShell

Requirement: Upload large files to SharePoint Online using PowerShell PowerShell to Upload a large file to SharePoint Online Suppose you try to upload files with > 250 MB file size to SharePoint Online using CSOM Files.Add method, or PnP PowerShell Add-PnPFile methods you’ll end up in errors: “The remote server returned an…

Read more

How to Add File Size Column to SharePoint Online Document Library?

Requirement: Add file size column to SharePoint Online How to Show File Size in SharePoint Online? You can add the “File Size” column to any list view of the SharePoint Online document library to get the size of each file. Just follow these steps to add the file size column to SharePoint…

Read more

SharePoint Online: Find All Files Exceeding Maximum URL Length Limitation using PowerShell

Microsoft Office Excel files stored in deep Folder, sub-folder structures with long names often result in an error when they exceed the maximum file URL length of 218 characters as in my other article  SharePoint Online: URL Length Limitation of 218 Characters in Excel Files. So, we wanted to proactively scan the…

Read more