Answered

Filter query stopped working

(0) Share

Report

Posted on by Keesl

Hi all,

A flow I have been using for some time now and has ben working fine is suddenly no longer working properly. Part of the flow uses the get files function and uses a simple query to filter files through a column I added to the document library. The filter is simply as follows:

This was working fine but now it no longer picks up any files, even though they are in the library with correct CropReportID tags. The column is a single line of text. Do I need to add quotes around my ID field?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Keesl please try adding quotes at the beginig of ID propertie and at the edn like this ' ID '

Was this reply helpful? Yes No
tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @Keesl ,
yes, you need to add quotes around the ID dynamic content, just quotes, no spaces.

Was this reply helpful? Yes No
Verified answer

Keesl 19 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks @tom_riha and @ChristianAbata for your suggestions. I already tried those and it made no difference. I did look at other possible issues and left it for a day or so. When I got back to it I realised that I had reached the magic 5000 file limit. I added the following to the Get files action, Order by Modified desc and Top count 500 as below:

This goes through the latest 500 files only, rather than 5000.

Thanks for your replies.

Was this reply helpful? Yes No