Mass Uploading from Excel into SharePoint list

[newgirlflow]

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. 

[v-LilyW-msft · Accepted solution]

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.

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.

[newgirlflow]

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?

[v-LilyW-msft]

Hi @newgirlflow 

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

Best Regards.

[newgirlflow]

Thank you so much for the reply!