SharePoint Online: Add Calculated Column to List using PowerShell

December 27, 2016    , , ,
Requirement: Add Calculated Column to SharePoint Online List How to Add Calculated column to SharePoint Online List? Calculated columns in SharePoint Online is used to manipulate other columns in the list item. Instead of entered by a user, these field values are automatically calculated based on the formula. Calculated fields will not appear on the New Form or Edit forms but visible on View Forms and in SharePoint views. To add a calculated column to SharePoint Online list, Browse to your SharePoint Online site and Navigate to the target list in which you want to create calculated column. Under the List tab, click on "Create Column" button in the ribbon. Provide the Name to your new column, specify the type as "Calculated (calculation based on other columns)" Enter the Formula for your calculated column in "Formula" field and specify the return type of the data.  Scroll down and set other parameters such as decimal places and format of the dat
SharePoint Online: Add Calculated Column to List using PowerShell SharePoint Online: Add Calculated Column to List using PowerShell Reviewed by Salaudeen Rajack on December 27, 2016 Rating: 5

SharePoint Online: Add Managed Metadata Column to List using PowerShell

December 26, 2016    , , , , ,
SharePoint Online: How to Add Managed Metadata Field to List or Library: Managed Metadata in SharePoint uses Term set from term store as the source for its allowed values. Term set defines set of values. E.g. Department is a Term set and "Sales" is a Term. So when the term set "Department" is used to as the source for a Managed Metadata column, the term "Sales" can be selected as its value. Here is how to add a managed metadata column to SharePoint Online list. Browse to your SharePoint Online site and Navigate to the target list in which you want to add Managed Metadata column. Under the List tab, click on "Create Column" button in the ribbon. Provide the Name to your new column, specify the field type as "Managed Metadata"  Scroll down and select the appropriate Term set or Term from the taxonomy store. Fill other optional values and Click on "OK" to create Managed Metadata field in SharePoint Online list. Pow
SharePoint Online: Add Managed Metadata Column to List using PowerShell SharePoint Online: Add Managed Metadata Column to List using PowerShell Reviewed by Salaudeen Rajack on December 26, 2016 Rating: 5

SharePoint Online: Add Multiple Lines of Text Column to List using PowerShell

December 26, 2016    , , , ,
The Multiple Lines of Text column in SharePoint Online is used to store Multiple rows of Text value. Based on the field settings, it can contain Rich text, including text, images, HTML formatted values, etc. How to Add Multiple Lines of Text Field to List in SharePoint Online? Browse to your SharePoint Online site and Navigate to the target list in which you want to add Choice column. Under the List tab, click on "Create Column" button in the ribbon. Provide the Name to your new column, specify the type as "Multiple lines of text" Fill other optional values such as Number of lines, Type of text, append changes to existing text, etc. and Click on "OK" to create Multiple lines of text column in SharePoint Online list. PowerShell to Create Multiple Lines of Text Column in SharePoint Online List: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint
SharePoint Online: Add Multiple Lines of Text Column to List using PowerShell SharePoint Online: Add Multiple Lines of Text Column to List using PowerShell Reviewed by Salaudeen Rajack on December 26, 2016 Rating: 5

SharePoint Online: Create Date and Time Column in List using PowerShell

December 26, 2016    , , , ,
How to Add Date and Time Column to SharePoint Online List? The Date and Time column in SharePoint Online captures date and optional time values. Browse to your SharePoint Online site and then Navigate to the target list in which you want to create date and time column. Under the List tab, click on "Create Column" button in the ribbon. Provide the Name to your new column, specify the type as "Date and Time"  Fill other optional values and Click on "OK" to create date and time column in SharePoint Online list. Here is the PowerShell script to create date and time column for SharePoint online list or library. PowerShell to Add Date and Time Field in SharePoint Online List: #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\Microsof
SharePoint Online: Create Date and Time Column in List using PowerShell SharePoint Online: Create Date and Time Column in List using PowerShell Reviewed by Salaudeen Rajack on December 26, 2016 Rating: 5

SharePoint Online: Create Site Column using PowerShell

December 25, 2016    , , , ,
Site columns in SharePoint Online Site columns provides great re-usability in SharePoint without having to recreate fields every time  you need them in lists and libraries. They save a lot of time especially when you have to standardize columns, create columns with data (such as choice fields) or assign default values to them. Once created at the top site, a site column can be utilized in any list or library or even content types throughout your site collection (or across site collections with content type hub). How to Create Site Column in SharePoint Online? To create site column in SharePoint online, follow these steps: Login to SharePoint online site. Click on Site Settings Gear and select Site Settings. On Site Settings page, Click on "Site Columns" link under "Web Designer Galleries" group.  In Site Columns page, Click on "Create" Link at the top. In create column page, Enter the name for your site column. Select the column type, Specify se
SharePoint Online: Create Site Column using PowerShell SharePoint Online: Create Site Column using PowerShell Reviewed by Salaudeen Rajack on December 25, 2016 Rating: 5

Fix "Another site or list is still using this content type. If you would still like to delete it, please remove the content type from all sites and lists and then try again" in SharePoint

December 21, 2016    , , , ,
Problem: When trying to delete a content type from List or site, received below error in SharePoint online site " Another site or list is still using this content type. If you would still like to delete it, please remove the content type from all sites and lists and then try again. " Solution: Find the references where a particular content type is being used and remove the content type association from the list. (You may have to delete the items of the particular content type or change the content type of the items, in order to remove the content type association from list). Also remove the items from both 1st stage (End-user) Recycle bin and 2nd stage (Administrator) recycle bins! PowerShell to Find a Content Type Usage in SharePoint Online: This PowerShell script scans get exports a content type references with in a given site collection. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16
Fix "Another site or list is still using this content type. If you would still like to delete it, please remove the content type from all sites and lists and then try again" in SharePoint Fix "Another site or list is still using this content type. If you would still like to delete it, please remove the content type from all sites and lists and then try again" in SharePoint Reviewed by Salaudeen Rajack on December 21, 2016 Rating: 5

Add Links to Resources List in SharePoint Central Administration

December 20, 2016    , , , , , ,
The Resources list in SharePoint Central Administration site lets you to keep frequently accessed links to the home page. Say for e.g. To access User profile service application, you'll have to navigate through: Central Administration >> Application Management  Manage Service Applications >> Search and pick your user profile service Application in some other cases, you'll find a difficulty in navigating To-And-Fro in SharePoint Central Administration. So, Resources list comes handy to manage this hassle. Just add your frequently accessed links to it! When you log into SharePoint Central Administration site, you'll see the Resources link list in right pane. Consider Resources list as your Favorites or Bookmarks List! To Add a link/remove links in resources list: Click on "Resources" link from SharePoint Central Admin home page (or your can Click the gear icon and click Site Contents >>  Find the Resources list) From here you can add o
Add Links to Resources List in SharePoint Central Administration Add Links to Resources List in SharePoint Central Administration Reviewed by Salaudeen Rajack on December 20, 2016 Rating: 5

Get All Available Cmdlets in SharePoint Online Management Shell

December 20, 2016    , , ,
Here is a nifty trick to find all available cmdlets in SharePoint online management shell. Open SharePoint Online Management Shell and Enter: Get-Command | ? { $_.ModuleName -eq "Microsoft.Online.SharePoint.PowerShell" } This lists down all cmdlets from SharePoint Online Management Shell.
Get All Available Cmdlets in SharePoint Online Management Shell Get All Available Cmdlets in SharePoint Online Management Shell Reviewed by Salaudeen Rajack on December 20, 2016 Rating: 5

SharePoint Online: Rename Folder using PowerShell

December 19, 2016    , , , ,
Requirement: Rename a Folder in SharePoint Online. PowerShell to Rename Folder in SharePoint Online Here is the SharePoint Online PowerShell to rename a folder #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 $SiteURL="https://crescent.sharepoint.com" $FolderURL="/Project Documents/Active" #Relative URL $FolderNewURL="/Project Documents/InActive" Try { $Cred= Get-Credential $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password) #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = $Credentials #Get the Folder $Folder = $Ctx.Web.GetFol
SharePoint Online: Rename Folder using PowerShell SharePoint Online: Rename Folder using PowerShell Reviewed by Salaudeen Rajack on December 19, 2016 Rating: 5

SharePoint Online: Delete Column from List using PowerShell

December 18, 2016    , , , , , ,
Requirement: SharePoint Online delete column from list How to remove a column from SharePoint Online List? We can delete Columns from lists or libraries when they are no longer needed. To delete a list column, follow these steps: Go to List settings by going to List tab >> Under Settings group, click on List Settings button in the ribbon. Under the List Settings page, in the Columns section, click on the column title you wish to delete. Scroll down and Click on Delete button. Confirm the deletion prompt by clicking OK. This deletes SharePoint Online list column. Please note, When you delete a column in SharePoint, all the data saved in the column is also deleted! We can't restore this column data from recycle bin! SharePoint Online: Delete List Column using PowerShell Here is the PowerShell to delete a column from List in SharePoint Online #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensio
SharePoint Online: Delete Column from List using PowerShell SharePoint Online: Delete Column from List using PowerShell Reviewed by Salaudeen Rajack on December 18, 2016 Rating: 5

SharePoint Online: Create a Content Type using PowerShell

December 17, 2016    , , , ,
What is Content Type in SharePoint Online? Content types are set of columns grouped together to serve a specific purpose. Think about a Invoice template! Instead of you and your users end up creating different templates each time from the scratch, you can define an Invoice template once and your users can start consuming it at any number of lists or document libraries! By this way, you force standardization in your collaboration environment. Or think of "Project Tracking" list with columns required to track projects for your organization. Instead creating and adding each column for Project tracking list every time, you'll be able to simply utilize project tracking content type template in any number of lists in few clicks. SharePoint Online lists or document libraries can contain multiple content types. E.g. You can add multiple content types such as "Invoice", "Proposal", "Purchase Order", etc to a library to organize everything related t
SharePoint Online: Create a Content Type using PowerShell SharePoint Online: Create a Content Type using PowerShell Reviewed by Salaudeen Rajack on December 17, 2016 Rating: 5

SharePoint Online: Export Term Store Data to CSV using PowerShell

December 15, 2016    , , , , ,
Requirement: Export Term store data from SharePoint Online to a CSV file Solution: There is no out of box way to export complete term store data in SharePoint online. However, we can utilize PowerShell to export term store data including all term groups, term sets and terms to a CSV file. Here is the script. PowerShell to Export Term Store data to CSV: Let's export term store in SharePoint Online 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" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Taxonomy.dll" #Variables for Processing $AdminURL = "https://crescent-admin.sharepoint.com/" $ReportOutput=&quo
SharePoint Online: Export Term Store Data to CSV using PowerShell SharePoint Online: Export Term Store Data to CSV using PowerShell Reviewed by Salaudeen Rajack on December 15, 2016 Rating: 5

How to Create SharePoint 2016 Farm using PowerShell?

December 15, 2016    , , ,
Creating SharePoint 2016 farm using PowerShell is almost as same as in its previous version. In SharePoint 2016 there is an additional parameter -LocalServerRole added as SharePoint 2016 introduced MinRoles. Pre-Requisites: SQL Server is already installed and ready to use. You have created a Farm account for SharePoint 2016. You have logged in to the server (Setup account) which has Administrator access on all SharePoint servers and DB_Creator, Security_Admin Server roles in SQL Server. Step 1: Install SharePoint 2016 prerequisites and binaries to each server in your proposed SharePoint 2016 farm. On completing the installation, Uncheck "Run the SharePoint Products Configuration Wizard now" and close the wizard. Step 2: PowerShell Script to Create SharePoint 2016 Farm: Save the below script as "Create-Farm.ps1" or something like that, change the configuration settings parameters as per your environment. Open SharePoint 2016 Management Shell as A
How to Create SharePoint 2016 Farm using PowerShell? How to Create SharePoint 2016 Farm using PowerShell? Reviewed by Salaudeen Rajack on December 15, 2016 Rating: 5

SharePoint Online: Version History Report using PowerShell

December 14, 2016    , , , , , ,
Requirement: Generate version history report for all sites in a SharePoint site collection. SharePoint Online PowerShell to Get Version History Details of a Document Library #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 Parameters $SiteURL="https://crescenttech.sharepoint.com/sites/marketing" $LibraryName="Documents" $ReportOutput = "C:\Temp\VersionHistory.csv" Try { #Setup Credentials to connect $Cred= Get-Credential $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password) #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = $Credentials
SharePoint Online: Version History Report using PowerShell SharePoint Online: Version History Report using PowerShell Reviewed by Salaudeen Rajack on December 14, 2016 Rating: 5
Powered by Blogger.