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 III
Super User III

@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 III
Super User III

@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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (88,869)