kwizcom banner advertisement

SharePoint Online: Download Attachments from List using PowerShell

8:15 PM    , , ,
Requirement: Download attachments from SharePoint Online List How to download attachments from SharePoint List Items? Well, to download attachments of a particular list item, you can open the item in either in view or edit mode, right click on each attachment and choose save from browser context menu. In case, you want to download all attachments from a list item or all list items, use "Map Network Drive" feature. Here is how: Go to Windows Explorer (Windows Key + E), Right click on "This PC" from left tree view and choose "Map Network Drive" Select the drive such as "Z:" and enter the URL of your SharePoint list. E.g. http://intranet.crescent.com/Lists/Credit/ This opens Windows explorer view with attachments folder. Attachments are organized with sub-folders under attachment folder. Your list item id become the name of the sub-folder! from here, you can download all attachments by simply copy-pasting to your local machine. PowerSh
SharePoint Online: Download Attachments from List using PowerShell SharePoint Online: Download Attachments from List using PowerShell Reviewed by Salaudeen Rajack on 8:15 PM Rating: 5

SharePoint Online: Copy List Items from One List to Another using PowerShell

6:49 PM    , , , ,
Requirement: Copy List items to another list in SharePoint Online How to copy list items to another list in SharePoint Online? Use Quick Edit (Datasheet view) to copy-paste list items between lists in SharePoint online. Make sure you have matching columns and column order is same in both views. SharePoint Online: Copy List Item to Another List 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" Function Copy-ListItems() { param ( [Parameter(Mandatory=$true)] [string] $SiteURL, [Parameter(Mandatory=$true)] [string] $SourceListName, [Parameter(Mandatory=$true)] [string] $TargetListName ) Try { #Setup Credentials to connect $Cred = Get-Credential
SharePoint Online: Copy List Items from One List to Another using PowerShell SharePoint Online: Copy List Items from One List to Another using PowerShell Reviewed by Salaudeen Rajack on 6:49 PM Rating: 5

SharePoint Online: How to Enable Versioning on a Document Library using PowerShell

9:08 PM    , , ,
What is versioning in SharePoint Online? Version history feature in SharePoint Online tracks every change to the document and creates a copy of it when someone changes a document. Each version of the document has the following: Version No When the version was created Who made the version (change) Size of the version Once the versioning feature is enabled, you can view/restore the previous versions of the document. How to Enable Version History in SharePoint Online Document Library? To Enable or Disable Versioning in SharePoint Online Document Library: Navigate to your document library >> Click on Settings gear >> and then "Library Settings" Menu item. Under Library settings page, Click on "Versioning Settings" Select "Create major versions" option and enter number of versions to track (by default, this is enabled with 500 versions in SharePoint Online). Scroll to the bottom of the page. Click "OK" to apply versioning
SharePoint Online: How to Enable Versioning on a Document Library using PowerShell SharePoint Online: How to Enable Versioning on a Document Library using PowerShell Reviewed by Salaudeen Rajack on 9:08 PM Rating: 5

Explorer View in SharePoint Online

8:13 PM    
SharePoint Online Explorer view provides great flexibility like Windows Explorer functionality to manage Files and folders. Majority of the usage: drag and drop! Where is Explorer View in SharePoint Online? Explorer view in SharePoint online modern UI is moved under View section! To enable explorer view in sharepoint online, Click on the View menu drop down from top-right area ( such as "All Documents")  >> Select "View in File Explorer" Menu item. >> This opens the document library in explorer view for SharePoint Online. SharePoint Online explorer view not working? or Greyed out? Explorer view is available only on 32 bit version of Internet Explorer! You cannot open in explorer view on Google Chrome or Microsoft Edge browsers. Now SharePoint Online modern document libraries also provides drag and drop functionalities. E.g. You can do multiple file upload with drag and drop Create folders and drag and drop files to it with in browser its
Explorer View in SharePoint Online Explorer View in SharePoint Online Reviewed by Salaudeen Rajack on 8:13 PM Rating: 5

How to Disable Quick Edit in SharePoint?

12:07 PM    , , , ,
Requirement:   Disable quick edit in SharePoint 2016 list. How to disable quick edit in sharepoint 2013 or SharePoint 2016? Bit background: We've a project tracking list with field "Project Health" which is updated by an event receiver based on certain parameters and business logic. So, we made the field hidden in SharePoint online using: SharePoint Online: How to Hide a Column from NewForm/EditForm? Now the problem is: users can go to "Quick Edit" mode of the list and they get hidden field there! Although the column was hidden from Edit and New Forms, SharePoint quick edit (which replaced Datasheet view in previous versions of SharePoint) still displays the hidden field and we decided to disable quick edit mode for the SharePoint list. SharePoint how to disable quick edit: To disable quick edit mode in SharePoint 2013/2016 or in SharePoint online, Go to the list settings >> Click on "Advanced settings" link In Advanced Settings link,
How to Disable Quick Edit in SharePoint? How to Disable Quick Edit in SharePoint? Reviewed by Salaudeen Rajack on 12:07 PM Rating: 5

SharePoint Online: Loop Through All Subsites in a Site Collection using PowerShell

7:21 PM    , , ,
Requirement: Often while working with SharePoint Online using Client Side object model, we need to loop through each site site under a site collection and here is the PowerShell script to iterate through each subsite and get its title. PowerShell-CSOM script to get all subsites from a site collection in SharePoint Online: This script iterates through each subsite and list all subsites #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" #Variables for Processing $SiteCollUrl = "https://crescent.sharepoint.com/sites/test/" #Get Credentials to connect $Cred= Get-Credential $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password) #Custom function to get all
SharePoint Online: Loop Through All Subsites in a Site Collection using PowerShell SharePoint Online: Loop Through All Subsites in a Site Collection using PowerShell Reviewed by Salaudeen Rajack on 7:21 PM Rating: 5

SharePoint Online: Change Storage Quota of Site Collection using PowerShell

1:11 PM    , , , ,
Requirement: Increase storage quota in SharePoint Online How to set the storage quota of a site collection in SharePoint Online: To set storage quota of SharePoint site collection, Follow these steps: Login to your SharePoint Online Admin Center (https://tenant-admin.sharepoint.com) Click on "Site Collections" link in left navigation. From the available site collections, Select the target site collection to change storage quota Click on "Storage Quota" button from the ribbon.  From the storage quota page, enter the new quota for your site collection. You can optionally enable Email notification to the site administrators when storage reaches particular threshold. Click on "Save" to commit apply new storage quota to your SharePoint Online site. How to Change storage quota using PowerShell in SharePoint Online ? To set storage quota in SharePoint Online, use: Set-SPOSite cmdlet. Here is how: Step 1: Connect to SharePoint Online $Admin
SharePoint Online: Change Storage Quota of Site Collection using PowerShell SharePoint Online: Change Storage Quota of Site Collection using PowerShell Reviewed by Salaudeen Rajack on 1:11 PM Rating: 5

SharePoint Online: Update User Profile Properties using PowerShell

11:05 AM    , , ,
Requirement: Update User Profile Property in SharePoint Online using PowerShell How to Update User Profiles in SharePoint Online? To update SharePoint Online user profile properties, follow these steps: Login to SharePoint Online Admin Center >> Click on "User Profiles" link from the left navigation In User Profiles, Click on "Manage User Profiles" under People tab. Use Search to find the user profile of the user to update >> Click on "Edit My Profile" link from the context menu drop down of the user result. Update any allowed user profile property and click on "Save and Close" button. SharePoint Online: Update user profile using PowerShell Lets update "Department" field of SharePoint user profile. Here is the PowerShell for SharePoint Online to set User profile properties. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Micros
SharePoint Online: Update User Profile Properties using PowerShell SharePoint Online: Update User Profile Properties using PowerShell Reviewed by Salaudeen Rajack on 11:05 AM Rating: 5

SharePoint Online: Get User Profile Properties using PowerShell

5:46 PM    , , , , ,
Requirement: SharePoint Online Get All User Profiles and export to CSV. How to Get All user Profiles and User Profile Properties in SharePoint Online? A user profile property is the field that holds user data such as "First Name", "Last Name", "Department", "Skills", etc. By default, SharePoint already has a rich set of user profile properties. Here is Login to SharePoint Online Admin Center >> Click on "User Profiles" link from left navigation In User Profiles, Click on "Manage User Profiles" under People tab. Use Search to get the user profile of the user. This interface helps us to get individual user profiles and properties one by one. Lets use PowerShell to get all user profiles in SharePoint Online. SharePoint Online PowerShell to Get User Profile Properties This PowerShell gets the specific property "Department" of the particular user from given site collection. #Load SharePoint CSOM Asse
SharePoint Online: Get User Profile Properties using PowerShell SharePoint Online: Get User Profile Properties using PowerShell Reviewed by Salaudeen Rajack on 5:46 PM Rating: 5

SharePoint Online: How to Make a Site Collection Read Only?

12:22 AM    
Requirement: SharePoint Online Make Site Collection Read only. How to make a SharePoint Online Site Read Only? We've a business requirement to set a SharePoint online site collection into read-only mode, in order to prevent any further addition/modification of content but make the existing content available as read-only to the end users. Unlike SharePoint On-premises, there are no direct ways (Central Admin/PowerShell) to make a SharePoint Online site or site collection read only. However, we can use site policies in SharePoint Online to make site collection read only. You can set the SharePoint online site collection lock status to "NoAccess" - But it defeats the purpose of Read-only mode! SharePoint Online: Make a Site Collection read only using  site policies Here is how to use SharePoint site policies for SharePoint Online to make site collection read only: Navigate to the site collection that you want to make Read Only >> Click on Settings Gear and th
SharePoint Online: How to Make a Site Collection Read Only? SharePoint Online: How to Make a Site Collection Read Only? Reviewed by Salaudeen Rajack on 12:22 AM Rating: 5

Get User Account By Display Name in SharePoint

6:59 PM    , , , , ,
Requirement: Get user by display name in SharePoint We have a CSV file with list of projects and their Team leads information. This list to be updated on a SharePoint list. But the challenge is 'Team Lead' field has display names of users instead of account name (Domain\LoginID). So prior updating to SharePoint list, we need the Login ID of the user from his display name. Solution: Lets Query Active directory for the given display name to get the user's Login ID. Prerequisites: You need to have PowerShell module for Active directory installed to use: Import-Module ActiveDirectory ! Use PowerShell cmdlet: Add-WindowsFeature RSAT-AD-PowerShell to add AD Module for PowerShell to your server/desktop! Otherwise, you'll get an error message: "Import-Module : The specified module 'ActiveDirectory' was not loaded because no valid module file was found in any module directory" PowerShell script to get user accounts from display name and update SharePoi
Get User Account By Display Name in SharePoint Get User Account By Display Name in SharePoint Reviewed by Salaudeen Rajack on 6:59 PM Rating: 5

SharePoint 2016: Cannot Find "Start" or "Stop" Options in Services on Server?

8:21 PM    ,
Problem: On creating service applications, like in SharePoint 2013, tried starting service instances from "Services on Server" page of SharePoint 2016 Central Admin site, But couldn't find any option to start any service instances. This is because: We are using MinRoles farm topology! MinRole in SharePoint 2016 starts necessary services on respective servers automatically! We don't have to start service instances manually! Creating service applications automatically starts necessary service instances on required servers. So, We don't need to start any service instance from "Services on Server" page of SharePoint 2016 Central Administration site. MinRole service controls them all. Instead of specific MinRoles (like WFE, Application, Search, Cache) if you use "Custom" MinRole, you'll find "Start" and "Stop" links next to each service instance according to their current status.
SharePoint 2016: Cannot Find "Start" or "Stop" Options in Services on Server? SharePoint 2016: Cannot Find "Start" or "Stop" Options in Services on Server? Reviewed by Salaudeen Rajack on 8:21 PM Rating: 5
Powered by Blogger.