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

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

Advertisements