How to change Microsoft Flow’s default limit of 100 items for “Get Items” and “Get Rows” actions

1–2 minutes

100itemlimit

The first time I created a flow for a list with over 100 items, I noticed an “Apply to Each” block stopping at 100 items. It’s a simple fix:

  1. Click the ellipses on the “Get items” item
  2. Settings
  3. Under Pagination:
    1. Toggle on pagination if your list uses pagination
    2. Enter the new limit of items
  4. Click Done
  5. Update Flow

You can also just click “advanced settings” on the action step to enter a new “top total” but will still need “settings” to toggle pagination.

2017-11-11_18-56-49.gif


Discover more from Nate Chamberlain

Subscribe to get the latest posts sent to your email.

10 responses to “How to change Microsoft Flow’s default limit of 100 items for “Get Items” and “Get Rows” actions”

  1. […] AVERTISSEMENT Seul les 100 premiers fichiers sont corrigés. How to change Microsoft Flow’s default limit of 100 items for “Get Items” and “Get Rows” a… […]

  2. Christian Avatar
    Christian

    Is there a maximum number that the limit of number of items can be set to?

  3. Sreenu Marneedi Avatar

    How to change Microsoft Flow’s default limit of 100 items for “Get Files (Properties only)” . for this we don’t have opting pagination(Limit). Please help me here !

    1. Kim S Avatar

      Yeah, I’m having trouble with this too.

  4. C P Champion Avatar
    C P Champion

    Fantastic, great help. I was only getting a return of 100 items deleting an SP list.

  5. simonjhudson Avatar

    All of which would be fine, except that I have the issue with Get Files (Properties) and that doesn’t seem to have been fixed.
    Anyone any workaround for that?

  6. minhvuongluu Avatar
    minhvuongluu

    Just 1 question: can I set the limit to 1,048,576 (max. no of rows in Excel) ?

  7. […] your list has (or will have) more than 100 items, increase the item limit on this […]

  8. […] If your SharePoint list (or other data list) has more than 100 items/rows, you’ll need to adjust settings for the “get” step to allow a higher […]

  9. […] items (SharePoint list) (adjust action settings if you have more than 100 items in your […]

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from Nate Chamberlain

Subscribe now to keep reading and get access to the full archive.

Continue reading