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 Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,531)