You’re offline. This is a read only version of the page.
Hi
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.]
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
Probably a little late, but if you index the colum you are sorting on, it allows for sorting for lists over 5000
Hi @Anonymous ,
You could turn on this setting.
Best Regards,
Wearsky
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.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
