Power Platform Community Forum Thread Details

I know the exact problem you are having, but I only have one workflow that does this, and I cannot find it at the moment. I used Copilot to help figure this out. What you are doing to check if the next link is provided in the response is correct, but instead of a condition, you need to use a Do until action instead. I asked Copilot trying to remember the correct prompt to get what you need. It generated the response below. Unless I can find my flow (I have about 600 in four environments), I cannot confirm it is accurate.

Copilot Resolution:

To handle pagination with the Microsoft Graph API in Power Automate and ensure your flow doesn’t error out on the last link, you can use the nextLink property to check if there are more pages of data to retrieve. Here’s a step-by-step guide to set up your flow:

Initialize Variables:

Initialize a variable to store the nextLink URL.

Initialize a variable to store the results.

HTTP Request to Graph API:

Use the “HTTP” action to make the initial request to the Graph API.

Apply to Each:

Add an “Apply to each” action to process the results.

Condition to Check nextLink:

Add a condition to check if the nextLink property exists in the response.

If nextLink exists, set the variable to the nextLink URL.

If nextLink does not exist, end the loop.

Loop Until No More Pages:

Use a “Do Until” loop to continue making requests until there is no nextLink.

Here’s an example of how you can set this up:

Initialize Variables:

Initialize Variable (nextLink):

Name: nextLink

Type: String

Value: null

Initialize Variable (results):

Name: results

Type: Array

Value: []

HTTP Request to Graph API:

HTTP action:

Method: GET

URI: https://graph.microsoft.com/v1.0/your-endpoint

Headers: Add necessary headers (e.g., Authorization)

Apply to Each:

Apply to each action:

Select the value from the HTTP response.

Condition to Check nextLink:

Condition action:

Condition: @not(empty(body('HTTP')?['@odata.nextLink']))

If true:

Set Variable (nextLink):

Name: nextLink

Value: @body('HTTP')?['@odata.nextLink']

If false:

Set Variable (nextLink):

Name: nextLink

Value: null

Loop Until No More Pages:

Do Until action:

Condition: @equals(variables('nextLink'), null)

Inside the loop:

HTTP action:

Method: GET

URI: @variables('nextLink')

Headers: Add necessary headers (e.g., Authorization)

Append to Array Variable (results):

Name: results

Value: @body('HTTP')?['value']

Condition action (same as above) to check for nextLink.

This setup ensures that your flow will continue to fetch data until there are no more pages, preventing errors on the last link. If you need further assistance or have more questions, feel free to ask!