SharePoint Diary

SharePoint Online: Delete Alerts using PowerShell

October 30, 2017 Alerts, Client Side Object Model (CSOM), PowerShell, SharePoint Online

Requirement: Delete Alerts in SharePoint Online How to Delete Alerts in SharePoint Online? To delete an alert from SharePoint Online, follow these steps: Login to SharePoint Online >> Navigate to Site Settings page. Under "Site Administration" section, Click on "User A…

SharePoint Online: Find Site Column Usage in Lists and Libraries using PowerShell

October 29, 2017 Client Side Object Model (CSOM), PowerShell, SharePoint Online, Site Columns

Requirement: Find a Site Column usage in SharePoint Online Site Collection SharePoint Online: PowerShell to Get a Site Column's usage in lists and libraries of a Site Collection: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Serve…

SharePoint Online: Create Alerts using PowerShell CSOM

October 28, 2017 Alerts, Client Side Object Model (CSOM), PowerShell, SharePoint Online

Requirement: Create SharePoint Alert using PowerShell How to Create Alerts in SharePoint Online? Alerts in SharePoint Online helps to track changes such as addition/changes/delete to the content E.g. Lists and libraries, pages, etc. To create an Alert for a SharePoint Online document library,…

SharePoint Online: Export Document Library Metadata to Excel

October 27, 2017 Client Side Object Model (CSOM), Column, CSV, Document Library, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Export SharePoint Online Document Library Metadata to a CSV file. Export Document Library Metadata to CSV using PowerShell: To export a document library's metadata into Excel, You can use: "Export to Excel" button on any SharePoint Online library. However, this func…

SharePoint Online: Remove User or Group from Folder Permissions using PowerShell

October 21, 2017 Client Side Object Model (CSOM), Folder, Permission, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Remove user from folder permissions in SharePoint Online. How to Remove user from folder permissions in SharePoint Online? How to restrict access to folder in SharePoint Online? To remove a user or group from SharePoint Online Folder's permissions, follow these steps: Naviga…

How to Create OneDrive for Business Site Collections using PowerShell?

October 21, 2017 Client Side Object Model (CSOM), My Site, Office 365, OneDrive for Business, PnP PowerShell, PowerShell, SharePoint Online, SharePoint Online Management Shell

Requirement: OneDrive sites in Office 356 are typically created when they click on the OneDrive link for the first time. In my case, for a file share to SharePoint Online OneDrive migration project, I had to pre-create OneDrive for Business sites for N number of users. How to Create OneDrive …

SharePoint Online: Remove List from Search using PowerShell

October 18, 2017 Library, List, List Settings, PnP PowerShell, PowerShell, Search, SharePoint Online

By default, all SharePoint Online lists and libraries appear in search results. There are some cases you want to remove a particular list's contents from appearing in search results. Say e.g. You want to hide images library's content from appearing in search results. How to Remove a l…

SharePoint Online: Read / Update Person or Group Field (People Picker) Values using PowerShell

October 18, 2017 Client Side Object Model (CSOM), Column, People Picker, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Get or Set "Person or Group" Field Values in SharePoint Online using PowerShell. Person or Group field provides searchable list of people and groups when they add or edit an item. It acts like a auto complete field when you type the first 4 character of the user names. H…

SharePoint Online: How to Disable Flow (Automate) in Lists and Libraries?

October 14, 2017 Client Side Object Model (CSOM), Microsoft Flow, PnP PowerShell, PowerShell, SharePoint Online, SharePoint Online Management Shell

Requirement: Disable flow in SharePoint Online. Microsoft Flow is a great tool to automate business processes by building workflows . In some cases, to take control over customization, You may want to disable Flows by hiding the "Flow" button in modern lists and libraries in SharePoi…

Create Search Service Application in SharePoint 2016 Multi-Server Farm using PowerShell

October 11, 2017 PowerShell, Search, Service Application, SharePoint 2013, SharePoint 2016

The Search Service Application in SharePoint provides search functionality, as its name implies. We have to use PowerShell scripts to configure search service application from SharePoint 2013 on wards as there is no user interface to configure the Search topology from SharePoint Central Admin - a…

Fix SharePoint Online "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator." in PowerShell

October 10, 2017 Client Side Object Model (CSOM), Known Issues, List, PowerShell, SharePoint Online

Problem: When trying to get list items from a SharePoint Online list through PowerShell, got this error message: Exception calling "ExecuteQuery" with "0" argument(s): "The attempted operation is prohibited because it exceeds the list view threshold enforced by the adm…

SharePoint Online: Rename Files in Document Library using PowerShell

October 09, 2017 Client Side Object Model (CSOM), Document Library, File, Office 365, PnP PowerShell, PowerShell, SharePoint Online

Requirement: Rename files in SharePoint document library using PowerShell How to Rename a Document in SharePoint Online? Renaming a file in the SharePoint Online document library is pretty straight forward. The quickest way to rename a document is: Right-click on your desired File and sele…

Disclaimer