TopCount not working?

[rohinMVP]

I have a flow where I get items from a SPO list and run an 'apply to each' on the fetched items.

My flow has been failing with error messages like below:

Unable to process template language expressions for action 'Apply_to_each' at line '1' and column '4988': 'The number of foreach items limit exceeded for action 'Apply_to_each': maximum '5000' and actual '6034'.'.

I have set a TopCount of 4000 on my Get Items step.

So what could be the issue?

[Jcook]

Hello @rohinMVP 

Can you try:

Enable pagination on the SharePoint Get items action. To do this:

Click the 3 dots on the action.

Now click settings, and enable Pagination.

And set a threshold of 7000.

[rohinMVP]

Hi @Jcook , when I set the pagination, I get the below error:

The pagination policy of workflow run action 'Get_Items' of type 'ApiConnection' at line '1' and column '1124' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '7000'. Maximum: '5000'.

[rsaikrishna]

@rohinMVP 

Due to SharePoint list item threshold, you cannot read more than 5K items by using Get Items directly. There is a work around to read more than 5K or more items.

Here is the solution: https://docs.microsoft.com/en-us/archive/blogs/svarukala/iterate-and-get-all-items-from-a-sharepoint...

Also, make sure all the columns in the SharePoint list which are used in Query, should be indexed. As you have 7K items, you should be able to create Indexed Columns. If it passed 20K, you cannot create them. 

Regards

Krishna

If my reply helps you resolving the issue, please mark the reply as Accepted Solution.

[rohinMVP]

@rsaikrishnaSo doesn't mentioning the TopCount as 4000 restrict the items fetched?

[v-litu-msft · Accepted solution]

Hi @rohinMVP,

So the number of Get items return is 6034, but you have set the top count to 4000, right?

How about set the threshold of the Get items to 4000 instead of set top count to 4000. The maximum is 5000, so 4000 is not over, it supposed to work normally.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rohinMVP]

Somehow, this did not work for me.

I had set both Top Count and Threshold was 4000.

I was still getting the error.

[v-litu-msft]

Hi @rohinMVP,

How about just set Threshold to 4000 and not set any number in Top Count?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.