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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

There is [Get items] from share point action in my Flow which failed due to below error.

The list of share point has 5000+ items, but if I remove Order By from below action, the error will not happen.

Is there any other action to replace order by of Get Items?

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

キャプチャ.PNG

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey Mate @Anonymous

The alternative to Get items will be SharePoint HTTP action - You can find details at - https://www.tachytelic.net/2020/04/use-rest-api-power-automate-get-over-5000-items-from-sharepoint/

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You could turn on this setting.

Best Regards,

Wearsky

Was this reply helpful? Yes No
DrKEWatson1 15 on at

Like (1)

Report
Copy link

Link copied!

Probably a little late, but if you index the colum you are sorting on, it allows for sorting for lists over 5000

Was this reply helpful? Yes No
ericwhitley 137 on at

Like (0)

Report
Copy link

Link copied!

Indexing the column you sort on and enabling Pagination helps but if the list is too large you also have to specify a Filter Query. If you want all items returned you can use something that will never be false, ie: Created ne null

If you don't do this you will still get the "The attempted operation is prohibited because it exceeds the list view threshold" error

Was this reply helpful? Yes No