Others

How to Retrieve More Than 15,000 Records from Microsoft Lists

Huma Ashraf ChHuma Ashraf Ch Oct 21, 2026 870 views

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.

How to Retrieve More Than 15,000 Records from Microsoft Lists
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.
Before you start

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.

Solution 1Recommended

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.

1
Open flow settings

Navigate to Power Automate, open your flow in Edit mode, and locate the 'Get items' action connected to your Microsoft List.

2
Access action settings

Click the three horizontal dots (ellipsis) on the top right corner of the 'Get items' action card and select 'Settings' from the dropdown menu.

3
Configure Pagination

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

4
Save and test

Click 'Done' to apply the settings, then save and run a test on your flow to confirm it successfully retrieves all records.

Enable Pagination in Power Automate
Performance Tip: While you can set the threshold up to 100,000, retrieving extremely large datasets can increase flow execution time. Only set the threshold slightly higher than your actual list size.
Free Microsoft Office alternative

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. 1. Export your list: In your Microsoft List, click 'Export' from the top command bar and choose 'Export to CSV'.
  2. 2. Open with WPS Spreadsheet: Launch WPS Office, click 'Open', and select the downloaded CSV file to load your entire dataset instantly.
  3. 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.
Process and analyze massive spreadsheets with over 1 million rows effortlesslyFully compatible with Microsoft Excel (.xlsx, .xls, .csv) file formatsLightweight architecture ensures fast load times even on older devicesCompletely free to use with a familiar, easy-to-navigate tabbed interface
microsoft office alternative - wps office

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.