Created a Flow by using the below REST call and stored the title and Urls in another list


Here the problem is it is returning only 100 items but I have 360 site sollections.

Not sure what I am doing wrong

1 Answer 1


That is indeed default behaviour. SP by default will return 100 items.

If you want more than 100 items, you need to specify that using $top param.

So you can append, for example, $top=1000 to the endpoint.

Modify the endpoint as below:


This will fetch you the first 1000 items. You can do this upto 5000 items.

If there are >5000 items, you will need to implement paging.

Reference - Page through returned items

How to get more than 5000 items from SharePoint Online in Flow

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.