Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $startdate = Get-Date -Day 05 -Month 03 -Year 2018 -Hour 16 -Minute 00
- $startDateIsoFormat = [Microsoft.SharePoint.Utilities.SPUtility]::CreateISO8601DateTimeFromSystemDateTime($startdate)
- $emailbody =""
- $web = Get-SPWeb "http://****/kb/info"
- $userfriendlyURL = "http://www.*****.intra/kb/info"
- $list = $web.GetList(($web.ServerRelativeUrl.TrimEnd("/") + "/Pages"))
- $spQuery = New-Object Microsoft.SharePoint.SPQuery;
- $camlQuery = "<Where><Geq><FieldRef Name='Modified'/><Value Type='DateTime'>$startDateIsoFormat</Value></Geq></Where>";
- $spQuery.Query = $camlQuery
- $listItems = $list.GetItems($spQuery)
- foreach ($item in $listItems)
- {
- $emailbody = $emailbody + '<br/> <a href ="' + $userfriendlyURL + '/Pages/' + $item["LinkFilename"].toString() + '">' + $item["Title"].toString() + '</a>'
- Write-Host "found"
- }
- Connect-PnPOnline -Url "https://your-tenant.sharepoint.com/sites/test" -UseWebLogin
- $filterDate = Get-Date -Day 05 -Month 03 -Year 2018 -Hour 16 -Minute 00
- $formattedDate = $filterDate.ToString("yyyy-MM-ddTHH:mm:ss.fffffffZ")
- $caml = "<View><Query><Where><Geq><FieldRef Name='Modified'/><Value Type='DateTime'>$formattedDate</Value></Geq></Where></Query></View>"
- $items = Get-PnPListItem -List "Pages" -Query $caml
- foreach ($i in $items) {
- #do some stuff here
- }
Add Comment
Please, Sign In to add comment