Problem with Get Files When Ordering By

(0) Share

Report

Posted on by jmr98

Hi all - I am having a problem with the following step that is part of a very large flow:

The step is meant to filter through a folder of files, return only ones with a certain substring in the filename, and bring back only one file - we are ordering by "created" in descending order. Currently this step is throwing an error:

body":{"status":400,"message":"The attempted operation is prohibited because it exceeds the list view threshold

There are only 45 or 50 files in this folder, and even when I remove the files it still errors out. It was working up until now. Is it possible that it is trying to order the entire library? When we remove the "Order By" it works fine, but then I am not guaranteed to get the correct file.

Thanks in advance for any insight you have!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @jmr98

Looking at some other sources - it seems like it occurs last number of items in list which causes longer time of execution- Resolution would be to add a column as index - may be the Created column.

https://support.microsoft.com/en-us/office/add-an-index-to-a-list-or-library-column-f3f00554-b7dc-44d1-a2ed-d477eac463b0?wt.mc_id=MVP_315224

Try to add the Created column as index in sharepoint list and see whether it works for you !

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
Verified answer

narayan225 2,547 Moderator on at

Like (1)

Report
Copy link

Link copied!

You can leverage the list view to create a filter that works for you.

To do this, create a view in SharePoint list and set the sort by to Created.

You can then select the view in Limit Columns by View option in Power Automate action.

This way, you don't have to worry about using Order By in the action.

Hope this helps.

Cheers!

Was this reply helpful? Yes No
jmr98 12 on at

Like (1)

Report
Copy link

Link copied!

Thank you both! @narayan225 yours did the trick for me!

Was this reply helpful? Yes No