Today I tried to upload a document to SharePoint Online using the Add-PnPFile command from the PnP PowerShell.

Add-PnPFile -Path $path/DocumentTemplates/MyTemplate.docx -Folder DocumentTemplates -Web $web -Values @{Title="MyTemplate";FileLeafRef="MyTemplate.docx"}

This resulted into

format-default : The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.

OfficeDev/PnP

Then when I ran the script again with a breakpoint set on the Add-PnPFile. When my PowerShell ISE waited I ran the Add-PnPFile command manually. No errors would appear. 

The above error means that some data can’t be displayed, but why not if it can display it when I run the command manually.

Then Erwin van Hunen gave me the answer.

$spfile = Add-PnPFile -Path $path/DocumentTemplates/MyTemplate.docx -Folder DocumentTemplates -Web $web -Values @{Title="MyTemplate";FileLeafRef="MyTemplate.docx"}

Now the object is set in the variable $spfile and the error doesn’t appear anymore.

Avatar for Pieter Veenstra

By Pieter Veenstra

Business Applications Microsoft MVP working as the Head of Power Platform at Vantage 365. You can contact me using contact@sharepains.com

4 thoughts on “Add-PnPFile – format-default : The collection has not been initialized”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from SharePains by Microsoft MVP Pieter Veenstra

Subscribe now to keep reading and get access to the full archive.

Continue reading