Power Automate - Filter 'Search for users (V2)' by Account Enabled to reduce the number of results

Anonymous
2024-11-08T04:56:54+00:00

I built a flow to retrieve user information from Office 365 and create items in a SharePoint list.

I added a condition to filter users with “Account Enabled = true” to get all active users after obtaining the full list of users.

However, the “Search for users (V2)” action does not return the complete list of users. I would like to ask if there is a limit on the number of users it can output?

If so, are there any methods to filter users with “Account Enabled = true” directly within the “Search for users (V2)” action to reduce the number of results?

Thanks.

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2024-12-12T07:40:58+00:00

Dear H.Y.Chan,

To help the other community members who are experiencing the similar issues, I'd like to summarize the issue as follows.

The Search users connector will return the users at a maximum API call as 1000. So you can only get users' number at 1000 when using the connector by default. If you have more than 1000 users, you need to enable Pagination.

Office 365 Users - Connectors | Microsoft Learn

The max number of Pagination is 10,000.

Use lists of rows in flows - Power Automate | Microsoft Learn

If you want to reduce the number of the users, you can type the number in Top in the connection.

Hope that the information above helps.

If it is convenient, please also send your feedback as follows as it may benefit the community process.

![Image](https://learn-attachment.microsoft.com/api/attachments/974db0b7-94b8-41e6-98a0-665778d3aa15?platform=QnA

.

Welcome to post a new thread at your convenience on our forum if you encounter any issues in your environment.

Thanks for your time and effort.

Sincerely

Cliff | Microsoft Community Moderator

Was this answer helpful?

3 people found this answer helpful.
0 comments No comments

5 additional answers

Sort by: Most helpful
  1. Anonymous
    2024-12-06T14:56:45+00:00

    Hi,

    Can you share the link to your question in the Power Automate Community please?

    Thanks,

    Manuel

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-11-15T01:42:44+00:00

    Thanks. I posted the question on Microsoft Power Automate Community according to the above recommendation. It has been solved by using pagination.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2024-11-08T20:23:05+00:00

    H.Y.Chan

    Can you share all the entries/commands in each part of your flow please?

    Thank you

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2024-11-08T06:03:32+00:00

    Dear H.Y.Chan,

    Good day! Thank you for posting your query in our community.

    Per your description, you have questions when creating a Power Automate flow.

    However, I’d explain that, because this problem is related to Power Automate, we suggest you post on the dedicated Microsoft Power Automate Community, the members and engineers in this community are more experienced in this area. You will get a more detailed and professional answer to your problem there.

    We appreciate your understanding.

    Sincerely,

    Sophia

    Was this answer helpful?

    0 comments No comments