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

[FMontesRNX1]

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

[tom_riha · Accepted solution]

Hello @FMontesRNX1 ,

did you try the pagination settings? https://powerusers.microsoft.com/t5/Connecting-To-Data/Excel-Business-List-rows-present-in-a-table-2...

[FMontesRNX1]

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.

[tom_riha]

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.