Get Items from SharePoint List (Limit of items)

[ncarrio]

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?

 

[ScottShearer · Accepted solution]

@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.

[danvarga]

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.

[ncarrio]

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