Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

get item from invoke a http request in graph limit to 100 rows

(0) ShareShare
ReportReport
Posted on by 6

Hello everyone,

I have created a flow to export data from a graph to an excel file in sharepoint, I run the query, but I only get the first 100 rows,

How can I set the limitation, I saw a similar topic to my case, but I can't find the setting option for HTTP request

  • AD-04031040-0 Profile Picture
    6 on at
    Re: get item from invoke a http request in graph limit to 100 rows

    Hi SanmeshG, Sure and in the output file an excel worksheet I only have 266 records,

    I dig a bit and i think my issue is with the odata link that I need to implement in my query and I do not know how can I implement it to read all pages in Graph

  • SanmeshG Profile Picture
    1,947 Super User 2025 Season 1 on at
    Re: get item from invoke a http request in graph limit to 100 rows

    Are you sure that it should return more than what it is currently returning I also see that you have mentioned the top count

  • AD-04031040-0 Profile Picture
    6 on at
    Re: get item from invoke a http request in graph limit to 100 rows

    Hi SanmeshG

    Anto5130_0-1694591982791.png

    Anto5130_1-1694592165652.png

     

    For info I have more or less 70 000 rows that I am trying to get from Microsoft Graph and I put in an excel file

  • SanmeshG Profile Picture
    1,947 Super User 2025 Season 1 on at
    Re: get item from invoke a http request in graph limit to 100 rows

    Hi @Anto5130 ,

     

    Can you add the screenshot of your flow?

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492