Unanswered

HTTP Request to SharePoint limited to 100 results

(0) Share

Report

Posted on by qualle

Hi all,

I'm having a problem with a HTTP request to a SharePoint list. The connector only gives me 100 results back but the list has more than 600 elements.

The URI is a little bit strange because the HTTP request connector couldn't find the list with the regular name. The return of the 100 elemets is totally fine, but it's not returning the 500 missing elements. I've also tried to change the settings of the connector but I can't find a setting that could help me fix this problem.

Could somebody help me with this? Huge thanks in advance.

Best regards!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (5)

Report
try adding
/_api/web/lists/getbytitle('myList')/items?$top=1000
to the URI to retrieve more than a 100 items. See: Solutions to the SharePoint 5000 item limit using Power Automate
Ellis

____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
qualle 9 on at

Like (0)

Report

Hi @ekarim2020 ,

tried this solution like 10 minutes before I made this post, but inserted a '&' instead of a '?'...
Thank you so much for ending my stupidity! 😄

Best regards!

Was this reply helpful? Yes No