Answered

Move Files

(0) Share

Report

Posted on by Abalderas

Hello I am trying to create a flow that moves files depending on their creation date (greater than a month for example) In advance, I really appreciate your attention and support.

Categories:

General topics

All responses (5)

Answers (1)

Sort by

eric-cheng 5,171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Abalderas ,

Will the files be in SharePoint or OneDrive?

I am asking as I don't think you can get Created Date in OneDrive.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
Abalderas 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eric-cheng

They are files that are in SharePoint, which depending on the date they were uploaded I need to transfer them to a folder in OneDrive

That is, I have images that were uploaded to SharePoint in June, July and August and I want everything that is before the current month (August) to be moved to the OneDrive site (not only copied I want to delete what is moved in SharePoint

I really appreciate your support
Verified answer

eric-cheng 5,171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Abalderas ,

Give this flow a go.

1) Use a subtract from time to get the date for last month

2) Use a Get Files (properties only) action and specify the following filter query. The right condition needs to be an expression.

Created lt 'startOfMonth(body('Subtract_from_time'))'

The rest of the flow looks like the below

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
Abalderas 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eric-cheng

I am testing your solution and I have managed to move all the files in a path, but I cannot do the test to move the ones that are older than a month

For example I have this folder with three files, how can I delete the file that was created yesterday and leave the two from today?

Again, thank you very much for your support, your information is helping me a lot
eric-cheng 5,171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Abalderas ,

Can you screenshot and past the query you are using in Get Items?

The following steps i posted earlier should have returned 1st July 2021 and when used with Get Items, should return all files created prior to 1st July 2021. The delete is part of the same loop so whatever files are returned in Get Items will be deleted.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn