511 total views, 1 views today
In this Power Automate troubleshooting tutorial, we will learn how to fix the error “Flow save failed with code ‘InvalidPaginationPolicy’ and message ‘The pagination policy of workflow run action ‘Get_items_2’ of type ‘OpenApiConnection’ at line ‘1’ and column ‘1354’ is not valid. The value specified for property ‘minimumItemsCount’ exceeds the maximum allowed. Actual: ‘100000’. Maximum: ‘5000’.’.”
Issue Details: Flow save failed with code ‘InvalidPaginationPolicy’
The Flow save will fail with the error code “InvalidPaginationPolicy” and the message “The pagination policy of workflow run action error in Get Items, Get Files (Properties Only), or whichever action has the pagination and threshold limit settings.”
The threshold should be a number greater than 0 and less than or equal to 100000.
If we go to the Get Items settings, enable the pagination, then enter the threshold limit value greater than 5000, we will get the above error, even though the threshold limit configuration clearly says that we can enter a value here from 0 to 0.1 million.
We can enter a number greater than 5000, but while saving the flow, we will get the above error: “Flow save failed with code “InvalidPaginationPolicy”.” This will not allow us to save the flow. This is really frustrating.
By the way, what does this threshold configuration mean?
For example, your list or document library has 60,000 items, and you want to retrieve all 60,000 items for further processing in the loop. As SharePoint has a threshold limit of 5000 items, if we don’t configure the pagination with a threshold limit, we will only get 5000 items by passing the top count as 5000.
However, by configuring the pagination along with the threshold limit, we will get all items from the list or document library (up to a maximum of 0.1 million) with a single query.
Now, coming to the main problem, why does the threshold limit not allow you to configure more than 5000 items?
Flow type that allows or does not allow more than the 5,000 threshold limit
From our experience, we will be able to configure more than the 5000 threshold limit in the manually triggered Power Automate flow but not in the automated cloud flow, where the maximum limit is 5000 due to the license issue.
A higher license is required for threshold limit configurations of more than 5000 items
In order to configure the threshold limit to more than 5000 items in the pagination settings, we need a flow premium plan (Plan 1 or Plan 2).
Power Automate flow Performance profiles
As per Microsoft “Flows have different limits depending on their performance profile. There are three possible values, depending on the flow owner’s plan.”
Exceptional cases where a flow returns all items with the 5000 threshold limit configuration
We don’t know why and how this happened. We have referred to a YouTube video where many people raised this concern about the 5000 limit threshold configuration. The author of the video says even though you are getting this limit, just pass the 4999 and you will get all items from the list.
We have just tried this: we configured the 5000 threshold limit in the pagination where we were getting the threshold limit error (more than 5000) and set the top count as 5000. Then, running the flow, we were able to get all items; it had more than 10,000 items.
We were surprised to see this and really still wonder based on how this 5000 threshold limit works. Still, we will investigate this to determine the technical root cause of the 5000 threshold limit and keep the article updated in the coming days, so follow this article for future reference.
Demo: Microsoft Power Automate Free plan
Let’s verify which plan we have; in our case, it is Microsoft Power Automate Free.
Next, verify your license.
Click on the gear icon in your Power Automate environment, then click on the “view my licenses” link.
You will see all your licenses assigned to you (as a logged-in user).
By now, we had seen the plan and license for our account “GD.” Now we’ll see two flows: one that is manually triggered and one that is automated.
Power Automate, which manually triggers flow, has a threshold limit of more than 5000 items.
We have configured the pagination with the 100000 items threshold limit and top count as 5000.
Let’s run the flow now.
Power Automate’s manually triggered flow gets more than 5000 items with the threshold configuration.
The Get Items query retrieves all items (7100) from the list.
Verify the total item count in the source list
The above-mentioned list contains a total of 7100 items.
Power Automate automated trigger flow doesn’t allow you to configure more than 5000 items in the threshold configuration
Now, using the same account (logged in user), if we try to configure the threshold limit in the pagination settings to more than 5000 items and save the flow, we get the following error:
Alternative method for retrieving more than 5000 items without using pagination or setting a threshold limit
To get all items without the pagination and threshold limit configuration, use the do-until loop. Please refer to our previous article for the same – Get more than 5000 items using Do Until loop in Power Automate.
Summary: Flow save failed with code ‘InvalidPaginationPolicy’ (Power Automate Get Items Threshold limit)
Thus, in this article, we have learned about how to deal with the Power Automate error “Flow save failed with code ‘InvalidPaginationPolicy’ and message ‘The pagination policy of workflow run action ‘Get_items_2’ of type ‘OpenApiConnection’ at line ‘1’ and column ‘1354’ is not valid. The value specified for property ‘minimumItemsCount’ exceeds the maximum allowed. Actual: ‘100000’. Maximum: ‘5000’.’.”
Other forum where this issue is discussed
- Page limitation issue in all Sync flows: The value specified for property ‘minimumItemsCount’ exceeds the maximum allowed. Actual: ‘100000’. Maximum: ‘5000’.” #725
- Pagination Error
See Also: Power Automate Articles Hub (with real-time example)
- You may visit the Power Automate articles hub
- Take care of what’s important. Automate the rest
If you like our articles, please appreciate our efforts by liking and sharing them with your friends and colleagues. Please join the mailing list to get our articles in your inbox as and when we publish them.
Happy automating and learning!