Create SP list item from Excel with 10K items

[keihimekawa]

Hi everyone,

I'm trying to create items into a SP list from an Excel file. This is working ok in test until we were told that the Excel file will be containing 10K items. Tried our Flow and only 256 lines were copied (perhaps due to timeout?) any advise on how to copy all 10k items into SP list?

[keihimekawa · Accepted solution]

Update: I got this to work by splitting the Excel file with 10k rows to 3 files and modifying the pagination configuration.

1st file - 4k rows

2nd file - 4k rows

3rd file - 2k rows

Items are now all in SP List.