Unanswered

Not Importing all rows from Excel to SharePoint List

(0) Share

Report

Posted on by StephenGW

583

I made a flow to bring over an excel table to a SharePoint list. It is pretty simple and seems to work but it is only bringing over the first 256 rows and there are over 3000. Is there something I need to change to keep it running until all rows are imported?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

That is the default limit. You need to edit the get Excel rows action and enable pagination and adjust the threshold limit.

Was this reply helpful? Yes No
Suggested answer

StephenGW 583 on at

Like (0)

Report

I figured this out. Default is only to bring over 256 entries. I had to go to the Get Rows settings and under Pagination add a Threshold of 4000 then in the advanced settings I had to set the Top Limit to less than that Threshold which in my case was 3500.

Was this reply helpful? Yes No