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

Get Items from SharePoint List (Limit of items)

Hi I´m making a workflow that get items from a SharePoint List, create an HTML Table and save it as .xls. It works fine but the results of that Table are only 100 elements (there is nearly 2000 in the list).

I have allready checked that there is no limit of elements in the sharepoint view.  Also I have tried to paste the results in a CSV table but the its allways the same.

Anyone can help me?

 

 WF CSV-HTML.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

@ncarrio 

By default, the SharePoint Get items action returns only 100 rows.  To change the default setting, click on settings for the Get Items action, turn on pagination and set the threshold up to a maximum of 5000.  With the license for Power Automate that comes with Office 365, you can retrieve a maximum of 5000 items.  Premium licenses have much higher limits.

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

@ncarrio 

By default, the SharePoint Get items action returns only 100 rows.  To change the default setting, click on settings for the Get Items action, turn on pagination and set the threshold up to a maximum of 5000.  With the license for Power Automate that comes with Office 365, you can retrieve a maximum of 5000 items.  Premium licenses have much higher limits.

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

Hi, @ncarrio 

@ScottShearer deliver you a correct answer, you can check this documentation about the same: https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-g.... Please mark this as resolved if you don't have further questions. Thanks.

 

I cant believe it was so easy (and i Havent seen it)... Thank you very much! It works perfectly!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,006)