cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mhan1
Regular Visitor

Get files does not return filtered results past first 5000 records in library

I have the file names and I want to get file ID (to update metadata).

mhan1_0-1608704083136.png

The query is correct, and the file exists in the library, but it doesn't return any results more than the first 5000 files. 

 

Isnt the point of filter query is to work within the 5000 view limit.

 

Wondering what other workarounds there are to select a file based on it's name/FileLeafRef. The library has >70,000 items.

3 REPLIES 3
ScottShearer
Super User
Super User

@mhan1 

As a test, can you hard code the filename with extension in your Flow and see if it works for you (rather than using the output of a previous action)?  

Also, I believe the comparison is case sensitive - can you verify that the filenames match exactly including case?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Already tried the hard-code (with and without extension) case sensitive and all- tried all combinations multiple times.

the same query format returns the 4999th item, but not the 5001st item.

 

I can even copy the "Input" file name, manually search it in the document library, and it will return the correct file.

ScottShearer
Super User
Super User

@mhan1 

Here is a link to a blog post that discusses your issue.

It appears as though this is a known issue and the solution suggested is don't have large libraries which is not a great answer.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,812)