The behavior you are seeing with the "Get Emails (V3)" action in Power Automate, where the "Search Query" filter limits the result to only 250 emails despite there being more in the folder, is due to the design limitation of the underlying Microsoft Graph API and the connector itself.
Key points:
-
When using "Search Query" with the Get Emails (V3) connector, the maximum number of items returned is capped at 250 because the search API endpoint in Microsoft Graph limits the result set size for query operations.
-
Without "Search Query," the connector can return up to 1000 emails, as it uses the standard list messages endpoint without search filtering, which supports fetching more items.
-
This is not exactly a bug but a known limitation in the service and connector behavior.
-
To work around this limitation, you can consider:-
-
Breaking down your search query into smaller chunks (e.g., search by date ranges or other criteria) and running multiple flows to aggregate results.
-
Using the "Skip Count" and "Top Count" parameters for pagination when feasible, although these have limited support in the search context.
-
Using the Microsoft Graph HTTP action directly in Power Automate with more advanced paging to overcome this limit.
Currently, the limitation is documented as part of the Graph API and Power Automate connector capabilities, so the 250-item cap with search filters is expected behavior.
If this limitation significantly impacts your scenario, consider providing feedback to Microsoft to prioritize enhanced filtering and pagination support with large result sets in connectors.
https://learn.microsoft.com/en-us/connectors/office365/
