Invoke-PnPBatch does not create items - what am I doing wrong?

[evlo]

When i'm using Add-PnPListItem with -Batch $batch it does not create any items, after running Get-PnPException I get
Message : Property ServerRelativeUrl was not yet loaded
Stacktrace : at PnP.Core.Model.TransientObject.GetValue[T](String propertyName)
at PnP.Core.Model.SharePoint.Web.get_ServerRelativeUrl()
at PnP.PowerShell.Commands.Base.PipeBinds.ListPipeBind.GetList(PnPBatch batch, Expression`1[] selectors)
at PnP.PowerShell.Commands.Lists.AddListItem.ExecuteCmdlet()
at PnP.PowerShell.Commands.PnPSharePointCmdlet.ProcessRecord()

Any idea what I could be doing wrong? It is creating about 1000 items in that batch.

[veronicageek]

Can you post your code (not sensitive info though) and your OS (Windows/MacOS/Linux) + the version of PnP PowerShell you're using. You can get it by running Get-Module -Name PnP.PowerShell -ListAvailable.

[evlo]

• 1.3.0
• windows 10

$batch = New-PnPBatch
ForEach($Row in $CSVData)
{
	$ItemValue = @{}           
	$CSVFields = $Row | Get-Member -MemberType NoteProperty | Select -ExpandProperty Name
	Foreach($CSVField in $CSVFields)
	{
		$MappedField = $ListFields | Where {$_.InternalName -eq $CSVField}
		$FieldName = $MappedField.InternalName
		$FieldType  = $MappedField.TypeAsString
		If($FieldType -eq "User" -or $FieldType -eq "UserMulti") #People Picker Field
		{
			$PeoplePickerValues = $Row.$FieldName.Split(",")
			$ItemValue.add($FieldName,$PeoplePickerValues)
		}
		Else
		{
			#Get Source Field Value and add to Hashtable
			$ItemValue.Add($FieldName,$Row.$FieldName)
		}
	}
	Write-host "Adding List item with values:"
	Write-host ($ItemValue | Format-Table | Out-String)
	Add-PnPListItem -List $ListName -Values $ItemValue -Batch $batch | Out-Null
}
Invoke-PnPBatch -Batch $batch

without batching it creates list items so $ItemValue is set up correctly

[veronicageek]

@evlo - I can reproduce your error when the value for -List is not formatted correctly. And as you're using variables when running the Add-PnPListItem, it might be worth checking what values they give you first.

When formatted correctly, it's working fine on my side.

[evlo]

Value passed was ie "Lists/someListName"
Changing code to

$List = Get-PnPList -Identity $ListName
Add-PnPListItem -List $List -Values $ItemValue -Batch $batch | Out-Null

Still results in Get-PnPException

Message          : Specified argument was out of the range of valid values.
                   Parameter name: lcid
Stacktrace       :    at Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream)
                      at Microsoft.SharePoint.Client.ClientRequest.ProcessResponse()
                      at Microsoft.SharePoint.Client.ClientRequest.<ExecuteQueryToServerAsync>d__53.MoveNext()
                   --- End of stack trace from previous location where exception was thrown ---
                      at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
                      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                      at Microsoft.SharePoint.Client.ClientRequest.<ExecuteQueryAsync>d__39.MoveNext()
                   --- End of stack trace from previous location where exception was thrown ---
                      at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
                      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                      at Microsoft.SharePoint.Client.ClientRuntimeContext.<ExecuteQueryAsync>d__65.MoveNext()
                   --- End of stack trace from previous location where exception was thrown ---
                      at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
                      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                      at Microsoft.SharePoint.Client.ClientContext.<ExecuteQueryAsync>d__28.MoveNext()
                   --- End of stack trace from previous location where exception was thrown ---
                      at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
                      at Microsoft.SharePoint.Client.ClientContextExtensions.<ExecuteQueryImplementation>d__6.MoveNext()
                   --- End of stack trace from previous location where exception was thrown ---
                      at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
                      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
                      at Microsoft.SharePoint.Client.ClientContextExtensions.ExecuteQueryRetry(ClientRuntimeContext clientContext, Int32 retryCount, String use 
                   rAgent)
                      at PnP.PowerShell.Commands.Utilities.ListItemHelper.GetFieldValues(IList list, IListItem existingItem, Hashtable valuesToSet, ClientConte 
                   xt clientContext)
                      at PnP.PowerShell.Commands.Lists.AddListItem.ExecuteCmdlet()
                      at PnP.PowerShell.Commands.PnPSharePointCmdlet.ProcessRecord()

So I tried even with list title

$List = Get-PnPList -Identity $ListName
Add-PnPListItem -List $List.Title -Values $ItemValue -Batch $batch | Out-Null

And then I get same
Message : Specified argument was out of the range of valid values.
Parameter name: lcid

Again, without batching it works

I guess it is something related to the manage metadata columns as I do not what other column type could be related to LCID.

[erwinvanhunen]

The managed metadata columns indeed had a bug in them if the current UI culture you're running (say you're running Windows in English, e.g. LCID 1033) but the managed metadata store does not have labels available for that language. We fixed that in the latest available nightly builds.

[evlo]

I tried with 1.3.15-nightly and got the same error.

[evlo]

Wo with verified same locale set with

[System.Threading.Thread]::CurrentThread.CurrentUICulture = $culture
[System.Threading.Thread]::CurrentThread.CurrentCulture = $culture

Now I get

Message          : Access to the cloud file is denied
Stacktrace       :
ScriptLineNumber : 12733

which is confusing to me, as it seems to be some onedrive related issue, and my script does not have 12000 lines :) maybe because I installed powershell module as an user to my work account onedrive?
I tried Connect-PnPOnline again and different powershell session, but I'm still getting same error message.

I'm trying on 1.3.15

[evlo]

After uninstalling all versions and installing 1.3.0 as administrator so it is installed in program files and not my user profile

I kept

[System.Threading.Thread]::CurrentThread.CurrentUICulture = $culture
[System.Threading.Thread]::CurrentThread.CurrentCulture = $culture

In the code

It does work for 700+ items in batch.

I then had issues testing as i accidentally created my testing list url /lists/lists/listName instead of /lists/listName which caused file not found errors.

I can also confirm batching works correctly for trems with ＆ (as & can't be in term name), it gets correct term guid for the request and creates item correctly.

On 1.3.15 I still get lcd id error if i don't have

[System.Threading.Thread]::CurrentThread.CurrentUICulture = $culture
[System.Threading.Thread]::CurrentThread.CurrentCulture = $culture

[evlo]

Hmm I just noticed then on each Add-PnPListItem with managed metadata column value to batch, query is run to get guid from term store, also in my last run about 2000 items imported correctly and then i got error An error occurred while sending the request. This happens kinda randomly and might be issue with my internet connection.
I did set StopOnException parameter

I have created #363 for the taxonomy fields in batch but I dunno how realistic it is.

[veronicageek]

Issue #363 now resolved & closed - Adding this for ref only and future viewers.