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
- Increase PageNumber to 1
- HTTP GET command for Page 1, 15 results
- 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)
