How to Retrieve More Than 15,000 Records from Microsoft Lists
Question details
The user needs to retrieve a large dataset of over 15,000 records from Microsoft Lists without encountering list view threshold errors or action limitations.

- Product
- Microsoft Lists / Power Automate
- Device & OS
- not provided
- Scenario
- Exporting or processing large amounts of list data using a Power Automate flow.
- Observed behavior
- Data retrieval stops at a maximum of 15,000 records, preventing the full dataset from being processed or exported successfully.
Ensure you have Owner or Full Control permissions for the Microsoft List to modify indexing settings, and edit access to the associated Power Automate workflow.
Enable Pagination in Power Automate
Use this solution to force the 'Get items' action in Power Automate to fetch records in batches until it reaches your specified threshold, bypassing the default limits.
By default, Power Automate restricts the number of items retrieved in a single action to improve performance. Enabling pagination allows the system to make multiple underlying requests automatically.
Navigate to Power Automate, open your flow in Edit mode, and locate the 'Get items' action connected to your Microsoft List.
Click the three horizontal dots (ellipsis) on the top right corner of the 'Get items' action card and select 'Settings' from the dropdown menu.
Find the 'Pagination' feature and toggle the switch to 'On'. In the 'Threshold' field that appears, enter a value higher than your total expected records (e.g., 20000 or up to a maximum of 100000).
Click 'Done' to apply the settings, then save and run a test on your flow to confirm it successfully retrieves all records.

Use Indexed Columns and OData Filters
Use this method if you are hitting the 5,000 list view threshold error, by indexing columns and filtering data before it loads.
Manage Massive Datasets Seamlessly with WPS Spreadsheet
While Microsoft Lists and Power Automate have rigid limits for data views and retrieval, managing large datasets locally is much easier. Export your list to a CSV and analyze it using WPS Office, a powerful and highly compatible alternative to Microsoft Office that handles large volumes of data without complex threshold configurations.
- 1. Export your list: In your Microsoft List, click 'Export' from the top command bar and choose 'Export to CSV'.
- 2. Open with WPS Spreadsheet: Launch WPS Office, click 'Open', and select the downloaded CSV file to load your entire dataset instantly.
- 3. Analyze without limits: Use WPS Spreadsheet's built-in pivot tables, advanced filtering, and charting tools to manage your data without worrying about cloud retrieval thresholds.

Frequently Asked Questions
What is the absolute maximum number of items Power Automate can retrieve using Pagination?
Using the default 'Get items' action with pagination enabled, you can retrieve a maximum of 100,000 records. If your list exceeds this number, you must implement a 'Do until' loop to fetch the data in smaller batches.
Why does my flow fail with a List View Threshold error even when pagination is enabled?
Pagination helps bypass the action retrieval limit, but Microsoft Lists still enforces a 5,000-item view threshold at the database level. To fix this, you must apply OData Filter Queries on indexed columns so the server processes a smaller subset before pagination kicks in.
Does exporting directly from the Microsoft Lists UI bypass the 15,000 limit?
Yes, exporting directly to Excel or CSV via the Microsoft Lists web interface allows you to download up to 30,000 items in a single export, which is separate from Power Automate's API restrictions.




