Copy data from one list to another list in SharePoint using PowerShell

In this article we are copying values from one list to another list in SharePoint using PowerShell

Here we are having two list LISTA and LISTB.

Reduce one day in SharePoint list Column using PowerShell
Disable list throttling SharePoint using PowerShell
How to get the date in textbox using JQuery

In both list having field “uniqueid” , using the “uniqueid” only I am updating values from LISTB to LISTA. In LISTB having more fields we need to copy the value from LISTB to LISTA , using camel query we are getting the value from LISTA in to this variable “$item['uniqueid']” and in FieldRef Name  we have to give the LISTB  field name.

Below is the script to update the items.

Add-PSSnapin Microsoft.sharepoint.powershell

      $web =  Get-SPWeb "http://dotnetsharepoint.com /sites/sharepoint/"

      write-host $web

    $Source =$web.Lists["LISTA"]           

     $Dest = $web.lists["LISTB”]

     write-host = $Source

     Write-host = $Dest

                            

    $items = $Source.items

    foreach ($item in $items) {

  

      $camlQuery ="<Where><Eq><FieldRef Name='uniqueid' /><Value Type='Text'>"+$item['uniqueid']+"</Value></Eq></Where>"

        $spQuery = new-object Microsoft.SharePoint.SPQuery

        $spQuery.Query = $camlQuery

        $spQuery.RowLimit = 1

        #check if the item is already present in destination list

         $ditems =  $Dest.GetItems($spQuery)

             $item["UserName"] = $ditems[0]["UserName"] 

 $modifiedBy = $item["Editor"]

$modifieddate =$item["Modified"]

Write-Host $item.ID

$item["Editor"] = $modifiedBy

$item["Modified"] = $modifieddate

$item.Update()

$Source.Update()

#Write-Host $count+1

        }

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Read More»

How to populate today’s date using JQuery in SharePoint

In this article we are able to see how to get the todays date based on condition from another column when we click on save button using JQuery

We are having a requirement with Stats Column with drop down  option, if the status column is in Completed then when we click on the save button it will display the todays date on Date column filed.

function PreSaveAction()

{

if ($("select[Title='Status'] option:Selected").val() == 'Completed') {

var date = new Date();

var datinformat = date.getMonth()+1 + "/" + date.getDate() + "/" + date.getFullYear();

$("input[title = 'DateField']").val(datinformat);

}

else

{

$("input[title = 'DateField']").val("");

}

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Read More»

Enable the calculated value option in SharePoint using PowerShell.

In this example we are able to show how to select the calculated value property using PowerShell, as per our requirement we have to show the X years date while creating a new item using the calculated formula we are unable to the field in NewForm.aspx, but using the Calculated value option we can show the filed in the NewForm.aspx Page.

  Import Data from excel to SharePoint List using PowerShell
 How to add fields to list in sharepoint using powershell 

Copy value from one filed to another field using PowerShell - See more at: http://www.dotnetsharepoint.com/2015/07/copy-value-from-one-filed-to-another.html#sthash.QPHZ7Tjz.dpuf

 Copy value from one filed to another field using PowerShell 

Date formula in SharePoint calculated value

 Date formula in SharePoint calculated value 

Add-PSSnapin Microsoft.SharePoint.PowerShell

$web = Get-SPWeb "http://dotnetsharepoint.com/sites/sharepoint/enableformula"

$list = $web.lists["ListName"]

if($list.Fields.ContainsField("Date") -eq $true)

 {

      Write-Host  "Field Date already avilable in the list"

      }

 else

 {

 $list.Fields.Add("Date","Date",$false)

 $list.Fields["Date"].DisplayFormat = "DateOnly"

 $DateField = $list.Fields.GetField("Date") #Get the field

 $DateField.DefaultFormula = "=DATE(YEAR(Today)+3,MONTH(Today),DAY(Today))"

 $DateField.update();

}

Once this PowerShell is completed we can able to see the Date field Calculated Value as shown below. 

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Read More»