web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to use $skipToken ...
Power Automate
Answered

How to use $skipToken to get more than 18000 data out when the limit is 1000-HTTP request

(0) ShareShare
ReportReport
Posted on by 34

I am using Http post request to get Resources out and into storage. However the http request has limitation of 1000 row per request. It does give you skip token which you can use to get more data. I am confused about how do I got about this. I can use the $skiptoken to get another 1000 rows and then will have to use $skiptoken from that run to get another 1000 and so on.  If i create a for each loop, is there way to get $skiptoken from previous run and use it for the next run and carry on doing so until there is no $skip token? What is the best way of approaching this?

Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @meklulose 

     

    is the skiptoken can only accept 1000 as max value?

     

    also could you do any filter query which helps to limit search and be more effiecient ?

     

  • meklulose Profile Picture
    34 on at

    @Nived_Nambiar after using the skiptoken from previous http request and running it again only brings back 1000. This is the documentation I am looking at Resources - Resources - REST API (Azure Azure Resource Graph) | Microsoft Learn Resources - Resources - REST API (Azure Azure Resource Graph) | Microsoft Learn. I need to get all of the data out so can't filter query. 

  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @meklulose 

     

    I think i have understood your question, give me sometime, i will come back with a flow  design 🙂

     

     

     

     

  • Verified answer
    Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @meklulose 

     

    This is the flow design i am taking about, to continue till skiptoken is not avaialble, i would recommend to try do until loop 

     

    Flow design

     

    Step 1:

     

    Nived_Nambiar_0-1684402375723.png

     

     

    we will initialize two variables, first one is array Final_Data, which would storing responses from http request

    second one is a boolean variable skiptokenavailable, which checks skiptoken is available or not in response of API.

     

    Step 2:

     

    will use a do until loop like below

    Nived_Nambiar_1-1684402452770.png

     

    In the loop, we will do as below

     

    we will invoke http request to call that azure resource manager (arm) API using the HTTP Request using below action

     

    Nived_Nambiar_2-1684405325803.png

     

    Now using condition, we will check whether the skiptoken is present or not

    Nived_Nambiar_3-1684405371360.png

     

    expression used on left side

     

    body('Invoke_an_HTTP_request')?['$skipToken']
     
    expression used in right side : null
     
    it is checking whether the skiptoken is present there or not
     
    if it skiptoken is present, in yes branch, do like this 
     
    Nived_Nambiar_4-1684405535824.png

     

    append the details from http request body to final_data variable and set skiptokenavailable variable as true

     

    if the condition is false, do like below

     

    Nived_Nambiar_5-1684405599187.png

     

    append the body of http response to FinalData array variable and set skiptokenavailable variable as false 

     

    if the skiptokenavailable becomes false, then loop will be skipped as it runs until skiptokenavailable becomes false.

     

     

    Hope this helps !

     

    Mark it as solution if it resolves your query !

     

     
     

     

     

  • VictorIvanidze Profile Picture
    13,079 on at

    You request should return the following:

    "@odata.nextLink"

    Just use its value as the URL of the next request.

     

     

  • meklulose Profile Picture
    34 on at

    thank you for the solution!

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    how do you loop through several 

    "@odata.nextLink"

    The first http request will get you one, the next request will get you a different  one and so on.  I would like to avoid manually adding another action to get the next page and so on.

  • VictorIvanidze Profile Picture
    13,079 on at

    Create a value and you don't need to "manually add another action".

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard