Add-PnPFile can't write Values Modified & Created

[scottchristian]

Reporting an Issue or Missing Feature

When uploading a file with Add-PnPFile values for Modified & Created are ignored

Expected behavior

PS > $pubdate
Thursday, 19 November 2015 2:47:38 PM

PS > $pubdate.GetType()
IsPublic IsSerial Name BaseType
True True DateTime System.ValueType

PS > Add-PnPFile -Path $path -Folder $folder -Values @{Modified="$pubdate"; Created="$pubdate"}
Name Type Items/Size Last Modified
2015_07 Annual Leave.pdf File 57000 19/11/2015 2:47:38 PM

Actual behavior

PS > $pubdate
Thursday, 19 November 2015 2:47:38 PM

PS > $pubdate.GetType()
IsPublic IsSerial Name BaseType
True True DateTime System.ValueType

PS > Add-PnPFile -Path $path -Folder $folder -Values @{Modified="$pubdate"; Created="$pubdate"}
Name Type Items/Size Last Modified
2015_07 Annual Leave.pdf File 57000 7/05/2018 5:49:01 AM

Steps to reproduce behavior

Happens with every file upload for me, I can't set the modified or created date no matter what I do.
However I can create a new Date & Time column and set that just fine.

Which version of the PnP-PowerShell Cmdlets are you using?

• PnP PowerShell for SharePoint 2013
• PnP PowerShell for SharePoint 2016
• PnP PowerShell for SharePoint Online

What is the version of the Cmdlet module you are running?

SharePointPnPPowerShellOnline 2.25.1804.1

How did you install the PnP-PowerShell Cmdlets?

• MSI Installed downloaded from GitHub
• Installed through the PowerShell Gallery with Install-Module
• Other means

[erwinvanhunen]

I found the issue and merged a fix. It will be available in the next release.

[scottchristian]

I'm honestly really sorry to ask but do you know when another release will be created?
My boss is chasing me about finishing a migration project that I need this fix to do.
Thanks, and sorry again.

[erwinvanhunen]

Normally we do a release at the beginning of every month. However, due to other blocking issues we decided to do an intermediate release which we will start preparing today, most likely PowerShell will be released tomorrow end of day (European time)

[scottchristian]

thank you so so much! 🥇
I would buy you a beer if I could.

[cfanta]

I am using the command as follows
Add-PnPFile -Path $LocalPath -Folder $RemoteLocation -Values @{Modified="1/10/2018"; Created="1/1/2018"}

However it shows Modified and created in SharePoint as today?

[scottchristian]

Pretty sure it needs to be a powershell datetime object, so if you were to use this it should work:
Add-PnPFile -Path $LocalPath -Folder $RemoteLocation -Values @{Modified=$([datetime]"1/10/2018"); Created=$([datetime]"1/10/2018")}

[cfanta]

That does not work in my testing. I did this on the end -Values @{Modified=$([datetime]"1/10/2018")} and it still shows in sharepoint as "modified" - "Just Now"

[scottchristian]

Just double checked some of my old migration script I wrote and that's how I'm pushing the date & time:
$CSV.PubDate = [datetime]::Parse($CSV.PubDate)
$UploadDocument = Add-PnPFile -path $($CSV.FixedName) -Folder $UploadFolder -Values @{Title="$($CSV.OrigName)"; Modified="$($CSV.PubDate)"; Created="$($CSV.PubDate)"}
If you cant get that to work than I did manage to find another way to do it, but it's MUCH slower.
You can get the item after you uploaded it, modify the metadata and then send a 'updateoverwriteversion' command
$UploadedItem = Get-PnPFile -Url "$($objitemInfo.RealPath)/$($objitemInfo.FixedName)" -AsListItem
$UploadedItem["Modified"] = $($objitemInfo.PubDate)
$UploadedItem["Created"] = $($objitemInfo.PubDate)
$UploadedItem.UpdateOverwriteVersion()
Hope that helps.

[cfanta]

Thanks for your time and the info. Have you been able to confirm with current version of the PowerShell that the Modified = for Add-PnPFile is working for you?
I wasn't sure because you mentioned it was old migration script so I wanted to see if you had time or a way to test it recently, possibly a new bug was introduced.

I use this to generate the Date
$ReportDate = [datetime]::ParseExact($ReportDate, 'yyyyMMdd', $null)
And this to upload
Add-PnPFile -Path $ReportItem.FullName -Folder "/Shared Documents/$($Company.Name)/Reports/$ReportYear/$ReportMonth/$($ReportFolder.name)" -Values @{Modified="$($ReportDate)"; Created="$($ReportDate)"}