Forum Discussion
Transfer 1 million rows to Sharepoint list
Hi Prasanna_30
firstly, this should work with PnP Powershell and the "Add-PnPListItem" Command (https://pnp.github.io/powershell/cmdlets/Add-PnPListItem.html)
Just call the following command a million timesAdd-PnPListItem -List "Demo List" -Values @{"Title" = "Test Title"; "Category"="Test Category"}(But wait a few seconds every 100 items or so to make sure that you don't get throttled).
Secondly, DON'T DO THIS.SharePoint is not a Database. It can handle that much data, but is not build for that. You will have problems later while acessing the data (i.e. just being able to download at max. 5000 elements per call and massive problems filtering your data if you did not set your indexes perfectly).
If you are using SharePoint Online then try to use a Dataverse table instead
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-intro
Best Regards,
Sven
Hi!
Don't Truely and honestly don't input 1 million rows in to a SharePoint list as the SharePoint list will have a hard time to handle this.
It's better if you split it up to multiple lists. as Querying, breaking permissions and just finding information in the list such as searching will be a pain.
The number of items in this list exceeds the list view threshold, which is 5000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.