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 / Do Until Loop through ...
Power Automate
Unanswered

Do Until Loop through Sharepoint List

(0) ShareShare
ReportReport
Posted on by 153

3cdoug_0-1693334964184.png

 

3cdoug_1-1693334964187.png

 

So I am trying to loop through my sharepoint list. Since there is a maximum of things that can be looped through I want to use the Do Until to loop through 500 items at a time, until the entire list has been read through. So I intiliaze all my variable and set my list item count (The Send HTTP) to count the amount of items within my Sharepoint. From there I am comparing the counter to the items in the Sharepoint to continue my loop. What do I need to set my increment to in order to keep iterating through the list adding 500 each time?

Categories:
I have the same question (0)
  • wskinnermctc Profile Picture
    6,519 Moderator on at

    This site shows how to get more than 5000 items and it uses the item ID to compare until it runs out. There isn't a need to have total count of items.

     

    https://www.tachytelic.net/2020/04/get-more-5000-items-sharepoint-power-automate/ 

     

    Doesn't answer your question, but it's another method.

  • wskinnermctc Profile Picture
    6,519 Moderator on at

    How many items are you trying to retrieve from the SharePoint list?

  • 3cdoug Profile Picture
    153 on at

    its an ever growing list, but i am trying to use this as a method to delete items from my sharepoint list that dont correlate to the excel roster

     

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!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 60 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 54

#3
Expiscornovus Profile Picture

Expiscornovus 47 Most Valuable Professional

Last 30 days Overall leaderboard