Hello Friends, in this article we will learn how to add Geolocation column in SharePoint. Using PowerShell, we can enable a Geo-location column on a custom list in SharePoint online. We will use a PowerShell script to add Geo-location column in our list. The same script can be used for SharePoint 2010/2013.
Add Geolocation column in SharePoint using PowerShell
- Open Windows PowerShell ISE
- Write below PowerShell code and run the same. Make the necessary changes in the below code like: $WebUrl, $EmailAddress, $List.
#Load SharePoint CSOM Assemblies Add-Type -Path "C:\Users\Desktop\Data\Old\Microsoft.SharePoint.Client.Runtime.dll" Add-Type -Path "C:\Users\Desktop\Data\Old\Microsoft.SharePoint.Client.dll" #Define SharePoint URL, login details $WebUrl = 'https://myclassbook.sharepoint.com/teams/TestSite/' $EmailAddress = "mayuresh.joshi@myclassbook.com" $Context = New-Object Microsoft.SharePoint.Client.ClientContext($WebUrl) $Credentials = Get-Credential -UserName $EmailAddress -Message "Please enter your Office 365 Password" $Context.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($EmailAddress,$Credentials.Password) #Define list name where we need to add Geolocation column $List = $Context.Web.Lists.GetByTitle("Project Portals") $FieldXml = "<Field Type='Geolocation' DisplayName='Location'/>" $Option=[Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldToDefaultView $List.Fields.AddFieldAsXml($fieldxml,$true,$option) $Context.Load($list) $Context.ExecuteQuery() $Context.Dispose()
Screenshot of the above code: - Once the script is successfully executed, you can see that the Geolocation columns with Display Name "Location" will be added in your list.
1) Microsoft.SharePoint.Client.Runtime.dll
2) Microsoft.SharePoint.Client.dll
3) PowerShell Script
0 Comments