Unable to import more than 256 items from Excel to Sharepoint List

(0) Share

Report

Posted on by FMontesRNX1

147

Hi.

I've created a flow that basically imports excel rows as items on a SP List.

It works, the problem is that stops after create 256 items only, this is a technical limitation? I've created the flow to avoid create items slowly 1 by 1, we're talking about more than 1000 registries per day (5000 in some cases) on our requirements.

I've tried also create the flow now with another file template and another SP List on a different site and the problem is the same.

Thanks and regards

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report

Hello @FMontesRNX1 ,

did you try the pagination settings? https://powerusers.microsoft.com/t5/Connecting-To-Data/Excel-Business-List-rows-present-in-a-table-256-row-limit-any/td-p/116355

Was this reply helpful? Yes No
FMontesRNX1 147 on at

Like (0)

Report

Yes, it seems that setting was the cause, do you know the limit per file? (To know how many rows I can add each time).
Thanks a lot!
PD I'm not sure if we can still commenting here if I mark as solution your comment, will be closed when marked?
Sorry, this is my first post.

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

When you mark a topic as solved, it'll stay open, you can still add replies.

Regarding the limit, I don't know what's the number, I never searched for that.

Was this reply helpful? Yes No