Skip to main content

Update list metadata Created By,Modified By, Created,Modified Field using PowerShell

In this article, we are going to learn "How to update list metadata using PowerShell".

In some cases  we want a particular person to be the created by and modified by and we also want to update the time stamp of modified at and created. We can achieve this using PowerShell.

Power shell to update Created By,Modified By, Created,Modified field values

--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"

--Replace the tenantName and listName with your site name and list name--
$SiteUrl = ""
$ListName= "listName"
----Replace the Username and Password with your one--
$Username = "userId"  
$Password = "pwd" |  ConvertTo-SecureString -AsPlainText -Force
#Get Credentials to connect
$Cred = New-Object pscredential -ArgumentList ($Username , $Password)
#$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 User
$User = $Ctx.Web.EnsureUser($UserID)
#Get the list Item
$List = $ctx.Web.Lists.GetByTitle($ListName)
$Query = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery()
$Item = $List.GetItemById($ID);
 --Replace the UserID with the your user Id which you want to be as Modified and Created by--
$UserID="[email protected]"
$TimeStamp = "2019/03/16"
$Item['Editor'] = $User
$Item['Author'] = $User
$Item["Created"] = $TimeStamp



Popular posts from this blog

How to create list from template in sharepoint

In this article, we are going to learn how to create a list from list template or using(.stp) file or we can say create list from existing list. Once you save the list as a template, It appears into List template option under the web designer gallery on site setting page. Steps to create list from list template: 1 Move to the site setting section where you have saved the list template. 2. When you click on the List templates, you will redirect to the List template gallery and from the list template gallery. 3. Now click on the File in ribbon and click on the upload document. 4. Browse the location where your list template is downloaded. I am uploading the template of an address list. 5.  After browsing the template, now you can give the name what you want to give to the list template and click on save. 6. Now the list template file appears into the list template gallery. Now click on the gear  icon and click on the Add an app. 7. On clicking add an app,

Content editor web part missing in SharePoint/Modern SharePoint.

Media and content editor web part missing in SharePoint online. At Some Point, you need to add content editor web part into the modern site but the content editor web part did not appear on the page, to appear content editor web part on page you need to follow the below steps. 1 Log in as the SharePoint Global Administrator or SharePoint Administrator. 2.  Log in and navigate to your site collection ("") and under the site settings activate the below features.   Site settings – site features – SharePoint Server Publishing .   Site Settings – Site Actions – Manage site features- SharePoint Server Publishing Infrastructure.                For this, you also need to enable Custom site scripts on your site collection(But In Modern SharePoint Its not recommended to enabling custom site scripting)  For this go to the  SharePoint Admin center – Settings -  Classic settings page (option mentioned on page)- Scroll the page you found an optio

Save site as template option in sharepoint online

In this article, we are going to learn about "save site as template option missing in sharepoint". When  you want  to replicate a site that you have already created and to do this you want to save site as template. To save site as template,  you go  on  Site setting   and then   move to  Site  action,   but you did not  find  the option “ Save site as template ” option.    In the modern sharepoint "save site as template" option is not enable by default. There are several option available to enable "save site as template".   Optione 1: Custom script is not allowed  on tenant  : On the new office 365 tenants or we say in Modern SharePoint experience by default the custom scripting is not allowed  on the tenant. If custom script is not allowed on your tenant some features will not work  o n your tenants. In common terms you may not able to  save site as template , options to create web part page will not appear on, some web parts  ( like media and