I need a script to Generate 25000 items in one list for my sharepoint online site. Please help.

@sns You could try to use below PnP PowerShell to add 25000 items in the SharePoint list. $username = "user name " $password = "password" $cred = New-Object -TypeName System.Management.Automation.PSCredential -argumentlist $userName, $(convertto-securestring $Password -asplaintext -force) Connect-PnPOnline -Url site collection URL -Credentials $cred $ListName ="list name" for($i=0;$i –lt 25001;$i++){ Add-PnPListItem -List $ListName -Values @{"Title" = "test";} } I’d like to explain that in SharePoint Online we have a list view threshold limit which is 5000. To learn more, see SharePoint Online software boundaries and limits . When we exceed this limit, it will cause some unexpected behaviors and performance issues. So, we suggest users manage large list referring to the article below: Manage large lists and libraries in Office 365 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.

Script to Generate 25000 items in one list

Accepted answer

Emily Du-MSFT 47,301 Reputation points Microsoft Vendor

2020-11-09T07:14:35.567+00:00
@sns
You could try to use below PnP PowerShell to add 25000 items in the SharePoint list.

$username = "user name " $password = "password" $cred = New-Object -TypeName System.Management.Automation.PSCredential -argumentlist $userName, $(convertto-securestring $Password -asplaintext -force) Connect-PnPOnline -Url site collection URL -Credentials $cred $ListName ="list name" for($i=0;$i –lt 25001;$i++){ Add-PnPListItem -List $ListName -Values @{"Title" = "test";} }

I’d like to explain that in SharePoint Online we have a list view threshold limit which is 5000. To learn more, see SharePoint Online software boundaries and limits. When we exceed this limit, it will cause some unexpected behaviors and performance issues. So, we suggest users manage large list referring to the article below:
Manage large lists and libraries in Office 365

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.
Please sign in to rate this answer.
sns 9,236 Reputation points

2020-11-09T11:11:07.287+00:00

Hi Emily Du,

Although I have installed and imported Module for connecting sharepoint online powershell, coming up with below error message attached.

Please help
38344-error.txt

Emily Du-MSFT 47,301 Reputation points Microsoft Vendor

2020-11-10T03:09:37.547+00:00

1.Usually, this error occurs when you don't have the PnP PowerShell module for SharePoint Online is installed on the local machine. So, to get rid of this error, you must install "SharePointPnPPowerShellOnline" module.

Install-Module SharePointPnPPowerShellOnline

2.In some cases, this error could be because of multiple versions of the SharePoint Online PnP PowerShell module installed and conflicting. Close all running instances of PowerShell and PowerShell ISE, open a new PowerShell window as Administrator and run these steps:
(1)Get all installed versions of SharePoint Online PnP PowerShell

Get-Module SharePointPnpPowerShellOnline -ListAvailable | select Name,Version

(2)Uninstall all installed SharePoint Online PnP PowerShell Modules

Uninstall-Module SharePointPnPPowerShellOnline -AllVersions -Confirm:$False

(3)Install the latest versions of SharePoint Online PnP PowerShell

Install-Module SharePointPnPPowerShellOnline

sns 9,236 Reputation points

2020-11-10T10:03:53.973+00:00

Hi Emily Du,
It got connected this time. But I see below error while executing script from coonect-pnponline…..

PS C:\Windows\system32> Connect-PnPOnline -Url https://bmnagarindirapark.sharepoint.com/sites/test -Credentials $cred $ListName ="LL" for($i=0;$i -lt 25001;$i++){ Add-PnPListItem -List $ListName -Values @{"Title" = "test";} } At line:1 char:119

... nt.com/sites/test -Credentials $cred $ListName ="LL" for($i=0;$i –lt ...

~
Missing closing ')' in expression.
At line:1 char:137

... Credentials $cred $ListName ="LL" for($i=0;$i –lt 25001;$i++){ Add-Pn ...

~
Unexpected token ')' in expression or statement.

CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException

FullyQualifiedErrorId : MissingEndParenthesisInExpression

Emily Du-MSFT 47,301 Reputation points Microsoft Vendor

2020-11-11T03:09:48.8+00:00

@sns
Error message shows that there are missing closing and wrong closing in the PowerShell.

Please provide the screenshot of complete running PowerShell.

sns 9,236 Reputation points

2020-11-11T07:50:40.843+00:00

HI Emily Du,

Please find attached done from beginning in the PowerShell, it is same error.
38996-errorpss.txt

sns 9,236 Reputation points

2020-11-11T07:54:19.93+00:00

HI Emily Du,

Please find attached done from beginning in the PowerShell, it is same error.
38996-errorpss.txt
also find attached screenshot as well

Emily Du-MSFT 47,301 Reputation points Microsoft Vendor

2020-11-11T10:15:51.487+00:00

@sns
Please pay attention to branch when running the PowerShell.

You should run PowerShell as following picture shows.

sns 9,236 Reputation points

2020-11-11T10:29:23.98+00:00

Hi Emily Du,
Though I gave correct credentials, It is giving below error message. What I have to do to sort out this

PFA
39113-df.txt

Emily Du-MSFT 47,301 Reputation points Microsoft Vendor

2020-11-12T02:43:18.043+00:00

@sns

Check whether the account name and password are correct. Also check whether the site collection URL is correct.

Check whether the account has enough permission for the site collection.

Try to use another authorized account, have a test, compare the result.

sns 9,236 Reputation points

2020-11-12T07:22:10.307+00:00

Hi EMily Du,

I see still I same error even though account is there and active in AD and sharepoint
I tested adding new account, but still the same error. Please see below screenshots
Please let me know what is wrong going on here.

site collection URL also correct.

Emily Du-MSFT 47,301 Reputation points Microsoft Vendor

2020-11-12T08:55:38.713+00:00

@sns
1.Make sure the password is correct.
2.Your account may be MFA (Multi-factor authentication) enabled. If yes, either MFA must be turned-off or run following PnP PowerShell.

Connect-PnPOnline -Url site collection URL -UseWebLogin $ListName ="list name" for($i=0;$i –lt 25001;$i++){ Add-PnPListItem -List $ListName -Values @{"Title" = "$i";} }

sns 9,236 Reputation points

2020-11-12T09:32:12.24+00:00

Yes password is correct.

Yes MFA is enabled. WIth out which I could not log in / open the site, so I had enabled multi factor
However with the help of above command that is using -useweb log in method I could connect, but I see below error now. Please help

PS C:\Windows\system32> Connect-PnPOnline -Url https://bmnagarindirapark.sharepoint.com/sites/test -UseWebLogin PS C:\Windows\system32> $ListName ="LL" for($i=0;$i -lt 25001;$i++){ Add-PnPListItem -List $ListName -Values @{"Title" = "$i";} }
At line:1 char:18

$ListName ="LL" for($i=0;$i –lt 25001;$i++){ Add-PnPListItem -List $ ...

~~~
Unexpected token 'for' in expression or statement.

CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException

FullyQualifiedErrorId : UnexpectedToken

Emily Du-MSFT 47,301 Reputation points Microsoft Vendor

2020-11-12T09:52:07.07+00:00

Please pay attention to branch when running the PowerShell. Each line of PowerShell must be run separately.

You should run PowerShell as following picture shows.

If you encounter an error, please provide the error message and screenshot at the same time.

sns 9,236 Reputation points

2020-11-12T10:02:22.243+00:00

It worked. Thank you for your support.

Bijay Kumar Sahoo 1 Reputation point MVP

2024-07-26T06:47:10.77+00:00

In case anyone want to still add more than 5000 items to a SharePoint list, you can check out here https://powershellfaqs.com/add-more-than-5000-items-to-a-sharepoint-online-list-using-pnp-powershell/
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Script to Generate 25000 items in one list

0 additional answers

Your answer