Hello.
I have an automation that creates an Excel file from a Sharepoint list everyday and stores it on one OneDrive folder.
My Sharepoint list has more than 200 lines but the Excel file only has 101.
How can I copy all of the lines from Sharepoint list?
Thank you.
Click on Settings for your Get Items action. Then, turn Pagination on and set the threshold to 5000 (higher of you have a premium license). Your Get items action will now return a maximum of 5000 rows.
Get Items returns just 100 items by default.