Unanswered

ODATA filtering on files properties

(0) Share

Report

Posted on by annetoal

1,934 Moderator

Thanks to Alex Tofan for most of the steps in this flow. I am using the Get files (properties only) step, and I want to restrict the files I retrieve to those that have a date in a column called "reviewdue" that is before today. Can I use the ODATA filter

reviewdue le utcNow()

in the Get files (properties only) itself? Or is there a better way to filter out everything except the files that have a reviewdue date before today?

Here's the structure of the Flow as it currently stands:

Thank you,

Anne

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yiwenxie-msft Microsoft Employee on at

Like (1)

Report

Hi @annetoal

Yes. you can use filter query to filter out all the files properties that have a reviewdate before today.
But the filter query should look like this:
reviewdate le '@{utcNow()}'

And the 'reviewdate' here should be the column field name rather than the display name. You can find the column field name in the URL of the column:

If the problem still exists, please feel free to let me know.

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

Thank you for the helpful response!

Anne

Was this reply helpful? Yes No