Insert/Add Current Date item to SharePoint Online using PowerShell
ADR Tutorials
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.UserProfiles.dll"
$SiteURL = "https://CompanyName.sharepoint.com/sites/DesarrolloSharepoint/"
$ListName="Datos"
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
$securePassword=ConvertTo-SecureString "Password" -AsPlainText -Force
$Context.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials("user@CompanyName.onmicrosoft.com", $securePassword)
$Web = $Context.Web
$List = $web.get_lists().getByTitle($ListName)
$itemCreateInfo = New-Object Microsoft.SharePoint.Client.ListItemCreationInformation
$CurrentDay = Get-Date -Format "dd"
$CurrentMonth = Get-Date -Format "MM"
$CurrentYear = Get-Date -Format "yyyy"
$currentThread = [System.Threading.Thread]::CurrentThread
$dateToStore = $CurrentThread.CurrentCulture.Clone()
$dateToStore.DateTimeFormat.ShortDatePattern = 'dd-MM-yyyy'
$dateToStore_temp = $CurrentDay + "-" + $CurrentMonth + "-" + $CurrentYear
$dateToStore = Get-Date $dateToStore_temp
$listItem = $list.addItem($itemCreateInfo)
$listItem.set_item('Title', 'Item Title' + 'Day: ' + $CurrentDay1 + ' Month: ' + $CurrentMonth)
$listItem.set_item('Description', $CurrentDay + $CurrenttMonth)
$listItem.set_item('CurrentDay', $CurrentDay )
$listItem.set_item('CurrentMonth', $CurrentMonth )
$listItem.set_item('Date', $dateToStore )
$listItem.update();
$Context.Load($listItem)
$Context.ExecuteQuery()
