cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
newgirlflow
Helper II
Helper II

Mass Uploading from Excel into SharePoint list

Hi! I created a flow that would upload the contents of an Excel into a SharePoint list.

 

The flow works perfectly when I test it for a few rows. Then, I tried inputting 5000 rows in the Excel and ran the flow. When I check the SharePoint list, only the first 256 rows from the Excel were uploaded into the SharePoint list. What when wrong and how could I improve this?

 

The Excel is stored in a SharePoint site. 

upload1.JPGupload2.JPGupload3.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @newgirlflow 

By default Microsoft Power Automate limits to fetching the first 256 rows when read excel files, you can increase this limit in the following way and try again.

  1. Click Setting
  2. Enable Pagination
  3. Set the Threshold 5000.

vLilyWmsft_0-1629883910693.png

vLilyWmsft_1-1629883936223.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
v-LilyW-msft
Community Support
Community Support

Hi @newgirlflow 

By default Microsoft Power Automate limits to fetching the first 256 rows when read excel files, you can increase this limit in the following way and try again.

  1. Click Setting
  2. Enable Pagination
  3. Set the Threshold 5000.

vLilyWmsft_0-1629883910693.png

vLilyWmsft_1-1629883936223.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Thanks @v-LilyW-msft ! This fixed it. Can I just ask, is it possible that people are editing the list items in grid view (Ex. inputting values in some columns) while this flow of uploading rows to the same list is running?

Hi @newgirlflow 

While this flow of uploading rows to the list, you can edit existing items or add new items.

Best Regards.

Thank you so much for the reply!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,934)