Power Platform Community Forum Thread Details

I am trying to get a list of all distribution lists to be used in a Power App to send emails.

I have a way to get all groups by using a previous answer I found:

But I believe it is only returning the first 100 DLs - my organisation has around 3000. I noticed each list has a link to the next page of DLs, so I am wondering if it is possible to use Power Automate to extract a big list of all 3000 DLs and return that to be used in my PowerApp?

Categories:

General topics

Hi,

You have to include a do while logic here which runs the above http request until the @data.nextLink is not present in http response.

Try something simmilar as shown below

1. Initialize an array variable which helps to collect details from http response

2. use send http request action to get details

3. Use initialize variable to initialize a string variable which stores nextlink if present

Expression:

body('Send_an_HTTP_request')?['@odata.nextLink']
 
4. use append to array variable to store the data from the http response , note that for demo purposes, i have stored body object to the array.
 
5. use Do Until action which runs the child actions until next link is not present.
Below actions would be present in do until
Use a condition which checks nextlink value is null or not ?
 
5.1 - use send http request to send the request to next link url as shown below
 
5.2- Use append to array variable to append details from http response
 
5.3- use set variable to set the next data link from above http response
 
Expression: 
body('Send_an_HTTP_request_2')?['@odata.nextLink']
 
So this is how you can capture required details from API which would have paginated results.
 
Thanks & Regards,

Nived N
Stay connected:

LinkedIn | YouTube | Blogs
Was this answer helpful?

If yes, please mark it as the solution by selecting the checkbox in the discussion thread.

Your feedback motivates me to keep contributing. Thank you!