Answered

Move files to a folder based on last modified date

(0) Share

Report

Posted on by igonzalez1

I want to move files that are older than a day to a different folder based on their last modified date.

For example, move File1 that was last modified on Jan 14, 2021 to ...reports\2021\01\14. Repeat this for every file in ...reports\ (not including sub folders). The path structure is simply yyyy\mm\dd (if this subfolder does not exist, create it).

How can I go about that?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

manuelstgomes 6,625 on at

Like (1)

Report
Hi @igonzalez1

I'm going to assume that the files are in your OneDrive, but the process is the same if they are in SharePoint.

For the condition to take one day

addDays(utcNow(),-1)

To get the day, month, and year:

formatDateTime(items('Apply_to_each')?['LastModified'],'dd') formatDateTime(items('Apply_to_each')?['LastModified'],'MM') formatDateTime(items('Apply_to_each')?['LastModified'],'yyyy')

And here's the full Flow:

Can you please check if and let me know if you have any questions?

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
igonzalez1 10 on at

Like (0)

Report
Hi @manuelstgomes
Thank you very much. Yes, it's OneDrive for Business. Couple of questions:
Does 'List files in folder' include subfolders? If so, how to disable it? If it doesn't, how can I make it include subfolders? I don't see an option.
Is 'List files in folder' updated after every loop of 'Apply to each'? I hope not.

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report

Hi @igonzalez1

The "List files in the folder" list the whole contents of a folder (folders and files) and return a flag (isFolder) so that you know if an entry is a file or a folder. It won't drill down if you want to do that; you need to do a more complex Flow where if it finds a folder, it will call another Flow (or the same one) to find information under that directory recursively. I can show you how, but it's a little bit more tricky.

Regarding your second question, no. The Flow fetches all the information in the "List files in folder" step and uses it until the flow. Each action is always like a snapshot. It collects the data as it is at the moment.

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No