SharePoint "Get items" action returning Bad request - max page count exeeded

(0) Share

Report

Posted on by Caddy

I would like to check if there is at least one entry in SharePoint list available that meets the filter condition. Therefore I have a top count of 1.

I set the pagination threashold to 100,000 items (with Power Automate per user plan).

The list hast 70000 items and the following error messagt is displayed:

Would be great if anybody could help me avoiding the error message? I have set the threashold to 100000 before without problems. Is the limit of 1000 new?

Kind regards

Caddy

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Caddy，

Here is the thing, the Top Count parameter sets the limit number of resulted records. By default, the item limit is 100. If we will work on a large dataset, we need to increase the item limit up to 5000. If we will use the item limit more than 5000 power automate get failed or it will show an error message.

So, to avoid the error message, please remove the input from the Top count and add a condition, write the following expression within the left tab:

length(body('Get_items')?['value'])

And assign the number 1 to the right tab of the condition.

Was this reply helpful? Yes No