News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Help! Loop through HTT...

Power Automate - Building Flows

Unanswered

Help! Loop through HTTP REST API, collect multiple pages of results and append into a single array

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi all,

Problem: REST API has a limit of 500 results per page, therefore looping through multiple pages to get all results. So far so good, however now I need to store all results into a single array to continue my flow logic. Currently testing with 3 pages of 15 results each, but will need to go up to 10 pages of 500 results each. Hence trying to avoid the apply to each command due to Power Automate limits.

In steps the flow does the following:

Set Pages to 3 (to loop through 3 pages)
Set PageNumber to 0 (used for loop, will be incremented)
Initialize a STRING variable (to append all HTML BODY to later)
Start "Do Until" loop
1. Increase PageNumber to 1
2. HTTP GET command for Page 1, 15 results
3. Append HTML BODY
Parse JSON from KnowBe4Data, this step goes WRONG, it will only show 15 results.. not 45
However, when I create a CSV table of the same JSON, I get 45 results..?

Does anyone know a way to add all pages into a single variable so I can pick that up for the rest of the flow?

Preferable without the 'apply to each' to avoid reaching limits (total 3000+ records)

Categories:

Business Process Flows

All responses Img

All responses (3)

Answers Img

Answers (0)

Pstork1 67,060 Most Valuable Professional on at

Like (0)

Report

Re: Help! Loop through HTTP REST API, collect multiple pages of results and append into a single array

If you can get each array from the HTTP call then you can use union() to combine them in one step. YOu may still need to add comma's after the closing braces to get an array of arrays that you can use union() on.
Community Power Pla... on at

Like (0)

Report
Re: Help! Loop through HTTP REST API, collect multiple pages of results and append into a single array

Update 2: Solved it with a compose action, not the prettiest but it works. Very much open for ideas about improving this.

replace(variables('KnowBe4Data'), '][', ',')
Community Power Pla... on at

Like (0)

Report

Re: Help! Loop through HTTP REST API, collect multiple pages of results and append into a single array

Update: I guess I know why it goes wrong, the parse JSON only picks up the first 15 as there is a closing block ']' before the next set of results.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans