Others

How to Fix Incomplete Results in Power Automate Search for Users (V2)

John Wilson Sep 25, 2026 869 views

Question details

The user needs to retrieve a complete list of enabled Microsoft 365 users using Power Automate, but the results are unexpectedly truncated.

How to Resolve Incomplete Results in Power Automate Search for Users (V2)

Product: Microsoft Power Automate
Device & OS: not provided
Scenario: Retrieving Microsoft 365 users to populate SharePoint list items using the Search for users (V2) action.
Observed behavior: The flow fails to return the complete list of users because the default action settings restrict the output to a maximum of 1,000 records.

Before you start

Ensure you have the necessary Microsoft 365 permissions to read user profiles and that your flow is open in edit mode.

Solution 1Recommended

Enable Pagination in Action Settings

Bypass the default 1,000-user limit by enabling pagination to retrieve up to 10,000 users.

By default, the Search for users (V2) action in Power Automate restricts the number of returned records to 1,000 to optimize performance. To fetch a larger directory of users, you must manually enable the pagination feature in the action's background settings.

Access Action Settings

Open your flow in the Power Automate editor, locate the 'Search for users (V2)' action, click the three dots (ellipses) in the top-right corner of the action card, and select 'Settings'.

Toggle Pagination

In the Settings pane, locate the 'Pagination' feature and toggle the switch to the 'On' position.

Set the Threshold

Enter a value in the 'Threshold' field corresponding to the maximum number of users you need to retrieve (up to 10,000), then click 'Done' to apply the changes.

Maximum Threshold Limits: The maximum supported threshold for pagination in this connector is 10,000 results. If your organization exceeds 10,000 users, you will need to utilize Microsoft Graph API queries instead.

Solution 2

Adjust the Top Parameter Value

Increase the explicit result limit defined in the Top parameter to ensure it does not artificially restrict your user list.

Free Microsoft Office alternative

Enhance Your Daily Productivity with WPS Office

While Power Automate manages your complex Microsoft 365 background workflows, WPS Office provides a free, lightweight, and highly compatible alternative for your daily document processing tasks. Enjoy a familiar interface and comprehensive editing tools without the heavy subscription costs.

1. Download the Software: Visit the official WPS Office website and download the free installation package tailored to your operating system.
2. Run the Installer: Open the downloaded file and follow the straightforward on-screen instructions to complete the setup process.
3. Open Your Files: Launch WPS Office to instantly open, edit, and save your existing Microsoft Office documents with complete layout preservation.

Fully compatible with Microsoft Office file formats (.docx, .xlsx, .pptx) to ensure seamless workflow integration.Lightweight architecture that loads quickly and runs smoothly on older devices.Free built-in PDF editing, merging, and conversion tools.Familiar ribbon-style user interface requires zero learning curve.

Frequently Asked Questions

Why does Search for users (V2) only return 1,000 results?

By default, the Power Automate connector enforces a 1,000-record limit to optimize flow performance and prevent timeout errors. You must explicitly enable pagination in the action settings to fetch additional records.

Can I filter Search for users (V2) to show only active accounts?

Yes, you can use the 'Search term' field for basic queries. However, the most reliable method is to retrieve the users first and then pass the output through a 'Filter array' action, setting the condition to check if 'Account Enabled' is equal to true.

What is the absolute maximum number of users I can retrieve with pagination?

The Search for users (V2) action supports pagination up to a hard limit of 10,000 results. For enterprise environments with datasets larger than this, you will need to bypass the standard connector and utilize the Microsoft Graph API via the HTTP connector.

Office Quick Solutions