0

I have this Get All Items where i define the threshold to be 100,00 as follow:-

johnjohn123_0-1687898162992.png

johnjohn123_1-1687898204890.png

now on runtime >> i will get this error , any advice how to fix this error?

The attempted operation is prohibited because it exceeds the list view threshold.

johnjohn123_2-1687898273352.png

any advice please?

Improve this question
3
  • 1
    The Pagination and 100'000 is Ok. try to remove "Order By" and "Filter Query" and see if it works. It can not sort more then >5000 items but 'Get' should work with pagination..
    – Gennady G
    Commented Jun 28, 2023 at 17:06
  • @GennadyG thanks .. i can Order by single field such as "DesignTypeOrder asc" but if i define 2 Order By fields i will get the threshold error again. not sure what is going on
    – microsoftdeveloperdesigner
    Commented Jun 28, 2023 at 17:14
  • Then think You should store results in some temporary table and then sort them there. Something like "power automate sort results more then 5000" in google might help. p.s.: Also sp admin account should work with 20'000 items. Best regards, Gennady
    – Gennady G
    Commented Jun 29, 2023 at 8:02

1 Answer 1

Reset to default
1

It seems your query is returning over 5000 items, and the Get Items action is unable to return more than this (regardless of the Power Automate pagination setting). You may need to use the SharePoint API directly, using the "Send HTTP request to SharePoint" action and the "nextLink" property that is returned, to fetch large datasets in pagination. This has been discussed in a Power Automate community thread here:

SharePoint GetItems TopCount

Improve this answer
5
  • so you mean the Get item can not retrieve more than 5000 regardless of the pagination we define ? is this dure to multiple filter we are using or something else?
    – microsoftdeveloperdesigner
    Commented Jun 28, 2023 at 16:31
  • It seems it's not able to return more than 5000 items, you'll need to paginate using the "Send HTTP request to SharePoint" action.
    – Callum Crowley
    Commented Jun 28, 2023 at 16:36
  • now i removed the Order by fields and the Get Item worked well .. not sure why
    – microsoftdeveloperdesigner
    Commented Jun 28, 2023 at 16:39
  • The fields are probably indexed, but can't be sorted because you're returning more than 5000 items.
    – Callum Crowley
    Commented Jun 28, 2023 at 16:42
  • yes all the filter and order by fields are index, i can Order by single field such as "DesignTypeOrder asc" but if i define 2 Order By fields i will get the threshold error again.not sure what is going on
    – microsoftdeveloperdesigner
    Commented Jun 28, 2023 at 16:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.