SharePoint Online: Delete Alerts using PowerShell

October 30, 2017    , , ,
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 Alerts" link This page lists alerts of all users in the particular site (web). Pick the user from the drop down and click on "Update" button to retrieve all alerts of the user. Once alerts are listed, can select either single alert or multiple alerts and then click on "Delelte Selected Alerts" link. SharePoint Online: Delete All Alerts of a User using PowerShell We can use PowerShell to delete all alerts of a particular user in SharePoint Online site. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common
Read More
SharePoint Online: Delete Alerts using PowerShell SharePoint Online: Delete Alerts using PowerShell Reviewed by Salaudeen Rajack on October 30, 2017 Rating: 5

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

October 29, 2017    , , ,
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 Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Function to get a particular Site column usage in Lists and Libraries Function Find-SPOSiteColumnUsage([String]$SiteURL, [String]$SiteColumnInternalName) { Try{ Write-host -f Yellow "Processing Site:" $SiteURL #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password) #Get All Lists and
Read More
SharePoint Online: Find Site Column Usage in Lists and Libraries using PowerShell SharePoint Online: Find Site Column Usage in Lists and Libraries using PowerShell Reviewed by Salaudeen Rajack on October 29, 2017 Rating: 5

SharePoint Online: Create Alerts using PowerShell CSOM

October 28, 2017    , , ,
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, follow these steps: Go to your SharePoint Online site, Navigate to the document library for which you want to create an alert From the Toolbar, Click on the ellipses and select "Alert Me". In the new alert creation page, Type the alert title, enter users who will receive notifications,  Select E-mail or SMS for "Delivery Method". Select the condition for this alert (e.g. "Anything changes") and when to send alerts. Scroll to the bottom of the page and click "OK" to create an alert for the document library. Now, Lets create SharePoint online alert using PowerShell! SharePoint Online: PowerShell to Create Alert We want to add an alert program
Read More
SharePoint Online: Create Alerts using PowerShell CSOM SharePoint Online: Create Alerts using PowerShell CSOM Reviewed by Salaudeen Rajack on October 28, 2017 Rating: 5

SharePoint Online: Export Document Library Metadata to Excel

October 27, 2017    , , , , ,
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 functionality doesn't give you details such as: Number of Versions, File size, etc. Here is the PowerShell CSOM script to extract the metadata of all documents under a specific document library and export to Excel. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Function to get all files of a folder Function Get-FilesFromFolder([Microsoft.SharePoint.Client.Folder]$Folder) { Write-host -f Yellow "Processing Folder:&qu
Read More
SharePoint Online: Export Document Library Metadata to Excel SharePoint Online: Export Document Library Metadata to Excel Reviewed by Salaudeen Rajack on October 27, 2017 Rating: 5

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

October 21, 2017    , , ,
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: Navigate to your SharePoint Online list or library where the target folder is located.  Click on "Details" from the specific Folder's context menu >> In the Details pane, Click on "Manage Access" and then "Advanced" links. This takes you to the "Advanced Permissions" page From the ribbon, Click on "Stop Inhering Permissions" button and confirm the prompt. Now, You'll get the list of users and groups who have permissions on the folder. When you break the permission, SharePoint copies permissions from its parent (List/library in our case!) . Select the users and groups you want to remove permission from folder and confirm the prompt.
Read More
SharePoint Online: Remove User or Group from Folder Permissions using PowerShell SharePoint Online: Remove User or Group from Folder Permissions using PowerShell Reviewed by Salaudeen Rajack on October 21, 2017 Rating: 5

How to Create OneDrive for Business Site Collections using PowerShell?

October 21, 2017    , , , , ,
Requirement: OneDrive sites in Office 356 are typically created when they click on 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 Sites using PowerShell? OneDrive for Business sites can be pre-created using a PowerShell cmdlet "Request-SPOPersonalSite". Open SharePoint Online Management Shell, Connect as SharePoint Online Administrator by entering the appropriate credentials to the prompt. $AdminSiteURL="https://crescent-admin.sharepoint.com" #Get Credentials to connect to SharePoint Admin Center $Cred = Get-Credential #Connect to SharePoint Online Admin Center Connect-SPOService -Url $AdminSiteURL –credential $Cred #sharepoint online create mysite powershell Request-SPOPersonalSite -UserEmails "peter@crescent.com","john@crescent.com" -NoWait $True Wait for new Minutes, SharePo
Read More
How to Create OneDrive for Business Site Collections using PowerShell? How to Create OneDrive for Business Site Collections using PowerShell? Reviewed by Salaudeen Rajack on October 21, 2017 Rating: 5

SharePoint Online: Remove List from Search using PowerShell

October 18, 2017    , , , ,
By default, all SharePoint Online lists and libraries appears 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 list from SharePoint Online Search: To exclude a list or library from search index using user interface, go to : List Settings >> Click on "Advanced Settings"  Scroll down and under Search section, select "Yes"  for "Allow items from this document library to appear in search results?" Option. Click OK to commit changes. This setting allows or disallows SharePoint Online crawler to index the list. Wait for 4 to 6 Hours and this list should be removed from search results. How to Remove SharePoint Online List from Search using PowerShell: Lets use PowerShell to exclude the list or library from SharePoint Online search. #Load SharePoint CSOM Assembl
Read More
SharePoint Online: Remove List from Search using PowerShell SharePoint Online: Remove List from Search using PowerShell Reviewed by Salaudeen Rajack on October 18, 2017 Rating: 5

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

October 18, 2017    , , ,
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. Here is my collection PowerShell scripts to retrieve and update person or group field values. SharePoint Online - Get People Picker Field Value using PowerShell: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Set parameter values $SiteURL="https://crescent.sharepoint.com/sites/pmo" $ListName="Projects" $FieldName= "ProjectManager" #Internal Name $ListItemID="5" #Get Credentials to conn
Read More
SharePoint Online: Read / Update Person or Group Field (People Picker) Values using PowerShell SharePoint Online: Read / Update Person or Group Field (People Picker) Values using PowerShell Reviewed by Salaudeen Rajack on October 18, 2017 Rating: 5

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

October 14, 2017    , , , ,
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 SharePoint Online. How to Disable Flow in SharePoint Online? There is no way to disable Microsoft Flow Out-of the box through browser. We've to use PowerShell. Assuming you have the latest SharePoint Online Management Shell installed in your machine, here is how to disable or enable Flow in SharePoint Online site collection via SharePoint Online Management Shell. #Set parameter values $AdminSiteURL="https://crescent-admin.sharepoint.com/" $SiteURL="https://crescent.sharepoint.com/" #Connect to SharePoint Online Admin Site Connect-SPOService -Url $AdminSiteURL -Credential (Get-Credential) # Disable flows on a site collection Set-SPOSite -Identity $SiteURL -DisableFlows D
Read More
SharePoint Online: How to Disable Flow in Lists and Libraries? SharePoint Online: How to Disable Flow in Lists and Libraries? Reviewed by Salaudeen Rajack on October 14, 2017 Rating: 5

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

October 11, 2017    , , , ,
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 - although we can create new search service application instance. Configuring SharePoint 2016 Search Service Application for Multi-Server Farm: While my earlier article addresses How to create search service application in SharePoint 2013 - Single Server farm , for Standalone SharePoint 2013 or SharePoint 2016 installations, In a production environment we may have to distribute and load balance search components to different servers in a multi-server farm. Here is the proposed Farm search topology in high level: I've the below servers in my SharePoint 2016 environment using Shared MinRoles: Web Front End + Distributed Cache Servers - 2 Application + Search Servers - 2 Since w
Read More
Create Search Service Application in SharePoint 2016 Multi-Server Farm using PowerShell Create Search Service Application in SharePoint 2016 Multi-Server Farm using PowerShell Reviewed by Salaudeen Rajack on October 11, 2017 Rating: 5

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

October 10, 2017    , , , ,
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 administrator." At line:26 char:5 +     $Ctx.ExecuteQuery() +     ~~~~~~~~~~~~~~~~~~~     + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException     + FullyQualifiedErrorId : ServerException Actually I was simply trying to delete all list items: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Config Parameters $SiteURL= "https://crescent.sharepoint.com/Sites/Projects" $ListName="ProjectD
Read More
Fix SharePoint Online "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator." in PowerShell Fix SharePoint Online "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator." in PowerShell Reviewed by Salaudeen Rajack on October 10, 2017 Rating: 5

SharePoint Online: Rename Files in Document Library using PowerShell

October 09, 2017    , , , , , ,
Requirement: Rename files in SharePoint document library using PowerShell PowerShell CSOM Script to rename a file in SharePoint Online: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Set Variables for Site URL, Old File Name and New File Name $SiteURL= "https://crescent.sharepoint.com/sites/sales/" $OldFileURL="/sites/Sales/Documents/Legal.docx" $NewFileURL="/sites/Sales/Documents/LegalTemplate.docx" #Setup Credentials to connect $Cred = Get-Credential $Cred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password) Try { #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = $
Read More
SharePoint Online: Rename Files in Document Library using PowerShell SharePoint Online: Rename Files in Document Library using PowerShell Reviewed by Salaudeen Rajack on October 09, 2017 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.