Unanswered

Filter Get file data based on condition date

(0) Share

Report

Posted on by Joesstlouis1

For some reason my condition isn't working. I have a date column in my document library labeled ExpirationDate and I'm trying to filter the output before it gets to the Create an HTML table step. Essentially It's not filtering anything, it's creating a table with every entry from the document library in it, regardless of the expiration date. I want the table to only show expired files and nothing else.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

sudharsan1985 1,325 on at

Like (0)

Report
Copy link

Link copied!
Hi @Joesstlouis1

Can you please use the below in the 'Condition' action instead of using 'utcnow()' alone and try

addDays(utcNow(), 0, 'yyyy-MM-dd')

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No
Joesstlouis1 24 on at

Like (0)

Report
Copy link

Link copied!

I'm using the above with UTCNOW and it's only calculating against the date the flow was created, not the current date that the flow is being run.

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like (0)

Report
Copy link

Link copied!

Hi @Joesstlouis1

I am not sure why you are using 'Apply to each' and then 'Condition' inside that, instead you can use the 'Filter Query' property of the 'Get Files (properties only)' action to filter the expired documents. I just ran a sample scenario and it worked fine.

1. Document library with the field named 'Expiry Data (Internal Name as 'ExpiryDate')'.

2. Uploaded 2 documents as shown below

3. One document has a past date and another as a future date as an expiry date.

4. Get Files action with the filter query shown below

5. The flow returns only one result as shown below

Note: For security reasons, I had cut down the tenant name in the screenshots.

I am sure the condition should work for the actions inside the 'Apply to each' too.

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No