Having Issues with a Flow

(4) Share

Report

Posted on by MattPackwood

I have a flow (attached) that I want to have detect and email files that have not been updated / edited in the last 14 days AND do not have the word "Archive" in the filename or folder path.

TimelineChecker_2...

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Michael E. Gernaey 53,932 Moderator on at

Like (1)

Report
Copy link

Link copied!

HI

I dont see a question at all.

Was this reply helpful? Yes No
Suggested answer

abm abm 32,981 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi

Please see below flow:

Above Compose 14 days expression is as follows:

formatDateTime(addDays(utcNow(),-14),'yyyy-MM-ddT00:00:00Z')

Get Files (Properties Only) Filter Query

FSObjType eq 0 and Modified lt '@{outputs('Compose_14_Days')}'

Let me know how it goes.

Thanks

Was this reply helpful? Yes No
MattPackwood 21 on at

Like (1)

Report
Copy link

Link copied!

This gives me a list of the files that are more than 14 days old, but I want to remove the ones that contain the string "Archive" in the files name or path...

Was this reply helpful? Yes No
MattPackwood 21 on at

Like (1)

Report
Copy link

Link copied!

I went back to basics to try to sort this out...

This detects "old files" but I can't figure out how to "ignore" files with "Archive" in the filename or path...

Was this reply helpful? Yes No