Pagination error

(3) Share

Report

Posted on by AD-15090620-0

Could anyone give some advice? The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '10000'. Maximum: '5000'.'.
I maybe could get all excel rows from run script and delete list rows, right now all the script is doing -> creating a table and renaming it. But then still would get this error for get items in sharepoint. I have roughly around 8k rows on excel and 8k on sharepoint.

For clearance what the flow is doing -> When an excel file is created in sharepoint documents, it will compare ID's with sharepoint list. If there is the same ID in sharepoint list and excel, then it will update row in sharepoint with the new information from excel, If there are new ID in excel, then it will create a completely new row in Sharepoint list.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Ellis Karim 12,163 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AD-15090620-0,

Scheduled (and triggered flows) enforce a 5,000-row pagination limit.

For a possible workaround or solution use Parent Flow + Instant Child flow. Please see: Power Automate Flows WON’T SAVE if Excel Pagination is over 5,000 – Ellis Karim's Blog

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
AD-15090620-0 41 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ellis Karim thank you for response. Yeah i checked your blog first, but i cant find an action such as "Run a child flow" anywhere

Was this reply helpful? Yes No
Suggested answer

Valantis 6,735 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @AD-15090620-0,

The "Run a Child Flow" action is only available when both flows are inside the same solution. Here's how to set it up:

1. Make sure both your parent flow and child flow are inside a solution (not in My flows)
2. In the parent flow, add action > search "Run a Child Flow" (under the Power Automate connector)
3. Select the child flow from the dropdown

If you can't find it, your flows are probably not in a solution. Create a solution in make.powerautomate.com, add both flows to it, and the action becomes available.

For your specific use case with 8k rows, the pattern is:

- Parent flow: gets the first 5000 rows from SharePoint using Get items with pagination enabled (up to 5000), passes them to child flow
- Child flow: processes the batch, runs the compare and update logic
- Parent flow: calls child flow again for rows 5001-8000 with a skip token or offset

Alternatively for Excel specifically: instead of List rows in Excel (limited to 5000), run an Office Script that returns the data as JSON. Office Scripts can return all 8k rows in one payload with no pagination limit. This bypasses the Excel connector limitation entirely.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
The error is occurring because one of your actions is trying to process 10,000 items in a single request, while the connector only supports 5,000.

For your scenario (~8,000 rows in both Excel and SharePoint), I would recommend:

Enable pagination, but do not set the threshold above the connector limit.

Avoid deleting and recreating all rows.

Retrieve SharePoint items once and build an in-memory lookup/dictionary.

Compare IDs and perform only:

Updates for existing records

Creates for new records

Ensure your SharePoint ID column is indexed.

This incremental synchronization pattern is significantly more scalable and reliable than deleting and reloading all 8,000 records every time a file is uploaded.

Was this reply helpful? Yes No
Suggested answer

Assisted by AI

RaghavMishra 261 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi there,

Thanks for sharing the details and the screenshots - that error points to a specific cause.

Why you're seeing this error

The message 'minimumItemsCount' exceeds the maximum allowed. Actual: '10000'. Maximum: '5000' means a Pagination threshold on your Get items (SharePoint) action is set to 10,000. Per Microsoft documentation, Get items can only retrieve up to the SharePoint list view threshold of 5,000 items - anything above that fails.

How to fix it

Open the Get items action → Settings → Pagination → set the Threshold to 5000 (not 10000). Going above 5,000 is not supported.

For your List rows present in a table (Excel) action, also turn on Pagination in settings - by default it only returns 256 rows, so with ~8k rows you'd otherwise miss most of them.

Getting past 5,000 rows (your ~8k scenario)

Since a single call caps at 5,000, retrieve the data in batches rather than one large request - for example use a Filter Query on an indexed column (such as your ID column) to pull ranges (IDs 1-5000, then 5001-8000), or page through with $skiptoken. Make sure the column you filter/index on is set as an indexed column in SharePoint to avoid throttling on large lists.

A reliable pattern: read the Excel rows (pagination on), build a lookup, then for each batch of SharePoint items compare IDs and only update matches and create new ones - rather than deleting and reloading everything.

References:

In-depth analysis into 'Get items' and 'Get files' SharePoint actions

Excel Online (Business) connector - known issues and limitations

SharePoint connector reference

Found this helpful? Please mark ✅ "Does this answer your question?" so others searching for the same issue can find it quickly. A 👍 on "Was this reply helpful?" or a ♥ Like is also much appreciated!

Raghav Mishra - LinkedIn | PowerAI Labs

Was this reply helpful? Yes No
Ellis Karim 12,163 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RaghavMishra

I don't think the info in your response is correct. Please re-check your response.

The $skiptoken parameter you mentioned is used when interacting directly with the SharePoint REST APIs (or Graph API) and is not available as a configuration option within the SharePoint "Get items" action.

Also, the SharePoint Get Items action pagination setting allows the retrieval of up to 100,000 items, as far as I know. I was able to read a SharePoint list containing 16,716 items with a pagination threshold value of 20,000.

Please read more here: Power Automate: How to Quickly Count Items in Any SharePoint List or Library – Ellis Karim's Blog

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No