Advertisements

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

4 Comments

  1. Pingback: How to make a Microsoft Flow mobile button to be emailed Microsoft Forms or SharePoint data as Excel link or attachment – SharePoint Librarian

  2. Pingback: Generate and send reports, files or lists regularly with Microsoft Flow’s “recurrence” trigger – SharePoint Librarian

  3. Pingback: Use Microsoft Flow to create a “today” column for use in SharePoint list calculations – SharePoint Librarian

  4. minhvuongluu

    Reply

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

Leave a Reply

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

%d bloggers like this: