Schedule Cloud Flow - Recurrence Pagination more than 5,000

Lim, Junyi 0 Reputation points
2024-02-15T03:36:42.1+00:00

Hi, When I schedule the cloud flow, it appears a message as shown below Flow save failed with code 'InvalidPaginationPolicy' and message 'The pagination policy of workflow run action 'List_rows_present_in_a_table' of type 'OpenApiConnection' at line '1' and column '1936' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '10000'. Maximum: '5000'.'. User's image

Anyone can help on this matter? As I want to create a recurrence flow with specific date on sending message from Ms excel to Microsoft Teams. Thanks!

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,087 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Vahid Ghafarpour 21,085 Reputation points
    2024-02-27T02:54:21.67+00:00

    If your list contains more than 5000 items, you’ll need to adjust your workflow to handle pagination correctly. Split the data into smaller chunks (pages) to avoid exceeding the limit and set the threshold to less or equal to 5000.

    ** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **


  2. Lim, Junyi 0 Reputation points
    2024-02-27T07:25:50.3933333+00:00

    my data cannot split into more pages. Is there any way or other workflow to solve this? I need to use schedule cloud flow to Teams me from excel list (in table format) to check the status of the excel

    0 comments No comments

  3. Mike Urnun 9,801 Reputation points Microsoft Employee
    2024-03-01T03:57:35.4966667+00:00

    Hello @Lim, Junyi - We received your recent feedback that your experience on the Q&A community platform was not helpful. Thank you for taking time to share your feedback.

    The threshold value means the number of records that can be fetched at a single iteration of multiple pagination requests. Let's say you needed to fetch a total of 15000 records, then the pagination will fetch them in 3 separate requests as follows:

    • 1st request will pull records 1-5000
    • 2nd request will pull records 5001-10000
    • 3rd request will pull records 10001-15000

    As such, you'll want to specify a value of 5000 or less to the threshold field which represents the minimumItemsCount property behind the covers. I hope this helps provide clarity to your question. If I misunderstood in any way, feel free to tag me in the comments below and share more info.


    Please "Accept Answer" if the answer is helpful so that others in the community may benefit from your experience.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.