Export SP Calendar List Items to csv with results showing only items over next 30 days with specified column values

Question

Hi, I'm trying to adapt https://www.sharepointdiary.com/2013/04/export-sharepoint-list-items-to-csv-using-powershell.html for a calendar, defining the Where-Object and limiting column output to

$list.Items | Where-Object { $["ContentTypeId"] -eq "0x0123456789"} | foreach {
$ExportItem = New-Object PSObject
$ExportItem | Add-Member -MemberType NoteProperty -name "EventDate" -value $["EventDate"]
$ExportItem | Add-Member -MemberType NoteProperty -Name "EndDate" -value $["EndDate"]
$ExportItem | Add-Member -MemberType NoteProperty -name "fAllDayEvent" -value $["fAllDayEvent"]
$ExportItem | Add-Member -MemberType NoteProperty -name "UID" -value $_["UID"]

for items occurring within the next 30 days.

So far I'm not getting results. No errors either.

Any guidance appreciated.

Thanks

Answer 1

Hi @sco gordo

You could try the code as following:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue  
   
#Get the Web  
$web = Get-SPWeb -Identity "url"  
   
#Get the Target List  
$list = $web.Lists["listname"]  
  
#Array to Hold Result - PSObjects  
$ListItemCollection = @()  
  
#Today's date  
$To = Get-date  
  
#Date+30  
$Date = (Get-date).AddDays(30)  
  
 $list.Items | Where-Object { $_["EventDate"] -le $Date -and $_["EventDate"] -ge $To}| foreach {  
 $ExportItem = New-Object PSObject  
 $ExportItem | Add-Member -MemberType NoteProperty -name "Title" -value $_["Title"]  
 $ExportItem | Add-Member -MemberType NoteProperty -Name "EventDate" -value $_["EventDate"]  
  
   
 #Add the object with property to an Array  
 $ListItemCollection += $ExportItem  
 }  
 #Export the result Array to CSV file  
 $ListItemCollection | Export-CSV "c:\Listluyi.csv" -NoTypeInformation                         
   
#Dispose the web Object  
$web.Dispose()  

Please change the paremeter as your need.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Much thanks, YiLu!