cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Leduc
Frequent Visitor

Impossible to have more than 196 rows in list with the create item SharePoint

Thanks for your help, I would like to be able to copy all rows from my Excel table (1080) to SharePoint list. But I'm stuck at 196 rows.recensement.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

@Leduc 

Go the the settings for the List rows action.  Turn on pagination and set the threshold to 5000.  Re-run your Flow and let me know if this resolves your issue please.

image.pngimage.png

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

3 REPLIES 3
ScottShearer
Super User
Super User

@Leduc 

Go the the settings for the List rows action.  Turn on pagination and set the threshold to 5000.  Re-run your Flow and let me know if this resolves your issue please.

image.pngimage.png

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Yes I had found in the meantime, but my Excel file is too big, I will have to reduce it.

thx Yes I had found in the meantime, but my Excel file is too big, I will have to reduce it. @ScottShearer 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,609)