Power Platform Community Forum Thread Details

Hi All,

I am trying to export a large number of emails from a shared mailbox to Excel using the “Get Emails (V3)” action in Power Automate.

Although the action allows a Top value of up to 1000, I consistently receive only around 245 records per run. To troubleshoot, I also attempted to split the query by date (daily batches), but even then, the maximum number of emails retrieved is approximately 250 per run.

Based on my filters, there are significantly more emails (around 1900+) that should be returned.

Has anyone encountered this limitation before or found a reliable way to retrieve all matching emails? Any guidance or best practices would be greatly appreciated.

Thanks in advance!

Categories:

Building flows

@AV-22050440-0

You can use the below approach to retrieve more than 1000 emails using the Microsoft Graph API and Microsoft Power Automate pagination with @odata.nextLink.

Create one String type variable at the top named VarEmailOdataNextLink.
Use the Send an HTTP request (Outlook connector) action in Power Automate and call the Graph API to get emails with $top=1000.

Example:

GET /me/messages?$top=1000
&$filter=receivedDateTime ge 2026-05-01T00:00:00Z
&$select=id,subject,receivedDateTime

Check the condition:
- If @odata.nextLink is null, then pagination is not required.
- If @odata.nextLink contains a value, proceed to the next step.
Set the @odata.nextLink value into the variable VarEmailOdataNextLink.
Use a Do Until loop and run it until VarEmailOdataNextLink becomes null or empty.
Inside the Do Until loop:
- Use another Send an HTTP request (Outlook connector) action.
- Directly pass the variable VarEmailOdataNextLink in the request URI.
Again, inside the loop:
- Update VarEmailOdataNextLink using the latest @odata.nextLink value from the current HTTP response.
- Append the current response emails into your main array/object variable.
The Do Until loop will continue until all emails are extracted.
At the end, your main variable will contain the complete email list JSON.

Please let me know if this helps. Otherwise, I can share the video for better understanding.

If the issue is resolved, click the "Mark as Answered" button on the helpful reply so others facing the same issue can find the solution quickly.

Thanks