kwizcom banner advertisement

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? 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 data and Click on "OK" to create Calculated field in SharePoint Online list. PowerShell to Create Calculated Column to List 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
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: 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. PowerShell to Create Managed Metadata 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.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\C
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    , , ,
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.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Custom function to add column to list Function
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? 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\Microsoft.SharePoint.Client.Runtime.dll" #Custom function to add column to list Function A
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 #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.GetFolderByServerRelativeUrl($FolderURL) $Ctx.Load($Folder)
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? 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. PowerShell to delete column from list 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" #Variables for Processing $SiteURL="https://crescent.sharepoint.com" $ListName= "Projects"
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 Content Type using PowerShell

December 17, 2016    , , ,
What are content types 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
SharePoint Online: Create Content Type using PowerShell SharePoint Online: Create 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 site 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: #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="C:\Temp\TermStoreData.csv" Try { #Get Credentials
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. PowerShell to Generate Version History Report for SharePoint Online: #Import SharePoint Online module Import-Module Microsoft.Online.SharePoint.Powershell Function Generate-VersionHistoryReport() { param ( [Parameter(Mandatory=$true)] [string] $SiteURL, [Parameter(Mandatory=$true)] [string] $ReportOutput ) Try { #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = $Credentials #Get all subsites and Lists from the site $Web = $Ctx.Web $Ctx.Load($Web) $Ctx.Load($Web.Webs) $Lists = $Web.Lists $Ctx.Load($Lists) $Ctx.ExecuteQuery() #Exclude system lists $ExcludedLists = @("Access Requests","App Packages","appdata","appfiles","Apps in Testing&quo
SharePoint Online: Version History Report using PowerShell SharePoint Online: Version History Report using PowerShell Reviewed by Salaudeen Rajack on December 14, 2016 Rating: 5

Open this link on a Phone - QR Code Feature in SharePoint 2016

December 14, 2016    
SharePoint 2016 introduces a new feature to open links on your phone or tablet using QR codes. Here is how this feature works: Go to any of your SharePoint 2016 library such as document library. From the document's context menu, click on the tiny phone icon. This takes you to a page with QR code generated for the document URL. By default, every document is assigned with a Unique QR code. From your phone, use QR reader app to read the QR code and navigate to the document URL. This makes easier to share documents on mobile devices.
Open this link on a Phone - QR Code Feature in SharePoint 2016 Open this link on a Phone - QR Code Feature in SharePoint 2016 Reviewed by Salaudeen Rajack on December 14, 2016 Rating: 5

SharePoint Online: Versioning Analysis on All Lists and Libraries using PowerShell

December 14, 2016    , , , , ,
Requirement: Audit versioning settings for all lists and libraries in SharePoint online site collection. PowerShell to Generate Versioning Settings Analysis for SharePoint Online Site Collection: #Import SharePoint Online module Import-Module Microsoft.Online.SharePoint.Powershell Function Audit-VersioningSettings() { param ( [Parameter(Mandatory=$true)] [string] $SiteURL, [Parameter(Mandatory=$true)] [string] $ReportOutput ) Try { #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = $Credentials #Get all subsites and Lists from the site $Web = $Ctx.Web $Ctx.Load($Web) $Ctx.Load($Web.Webs) $Lists = $Web.Lists $Ctx.Load($Lists) $Ctx.ExecuteQuery() $VersioningData = @() Write-host -f Yellow "Processing Site: "$SiteURL #Iterate through each list in a site and
SharePoint Online: Versioning Analysis on All Lists and Libraries using PowerShell SharePoint Online: Versioning Analysis on All Lists and Libraries using PowerShell Reviewed by Salaudeen Rajack on December 14, 2016 Rating: 5

SharePoint Online: Export Term Set to CSV using PowerShell

December 13, 2016    , , , ,
Requirement: Had to extract all terms in a term set to CSV format in SharePoint Online. Unfortunately, there is no way to export sharepoint online export term set from UI. But PowerShell can help! SharePoint Online PowerShell to Export Term Set PowerShell to export all terms from a given term set in Term store of 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" 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/" $TermGroupName = "Regions" $TermSetName = "East Africa" $CSVFile="C:\Temp\Term
SharePoint Online: Export Term Set to CSV using PowerShell SharePoint Online: Export Term Set to CSV using PowerShell Reviewed by Salaudeen Rajack on December 13, 2016 Rating: 5

How to Create State Service Application in SharePoint 2016

December 08, 2016    , ,
Lot of components like InfoPath Form services, Visio, Search Service, workflows, etc relies in State Service Application of SharePoint to store the application sessions. If its not configured already, you'd probably see error messages such as: "The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator." How to Create State Service application in SharePoint 2016? State service application can't be created through new service application page. If you go to New dialog of Central Administration >> Manage Service Application page, you won't find it! here is how to create state service application in SharePoint 2016. Go to Central Administration site >> Click on "Configuration Wizards" link from the bottom In Configuration Wizards page >> click Launch the Farm Configuration Wizard link >> and then click "Start
How to Create State Service Application in SharePoint 2016 How to Create State Service Application in SharePoint 2016 Reviewed by Salaudeen Rajack on December 08, 2016 Rating: 5
Powered by Blogger.