Read and Writing data into excel file when the input contains approximately 10,000 records or data in SharePoint

Feedback StudioX
, , ,
1

Hey All,
I have input data in my local approximately 10,000 records and i need to write it into one excel file which was in SharePoint folder.

If my input contains below 10,000 records my bot has been read the input data and inserted 5000-7000 records successfully without any issues but when the input contains 10,000 records it was unable to read and write into file in SharePoint…

Below is the error screenshot

image
image1691×677 180 KB

3

Hey!

Is there any limitations in SharePoint to store the data?

Instead of looping through the excel .

Use Autofill,LinQ to paste the data

Regards,
NaNi