Answered

Move files older than 30 days to another SharePoint library

(0) Share

Report

Posted on by Goose05

Hi Guys,

I am new to flow and I am trying to achieve the following. I need to create a flow that will run on a schedule. The flow needs to identify files in a document library, whose modified date is older than 3 years. It then needs to grab these files and move them to another document library called Archived.

Any advice would be greatly appreciated

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Goose05,

You could refer to screenshot below to create the flow to move file from library1 to library2 when the file is older than 30 days:

The expression in the Condition as below:

@lessOrEquals(items('Apply_to_each')?['Modified'], addDays(utcNow(), -30))

If you want to move file from library1 to library2 when the file is older than 3 years, the expression should as below:

@lessOrEquals(items('Apply_to_each')?['Modified'], subtractFromTime(utcNow(), 3, 'Year'))

Best regards,

Alice

Was this reply helpful? Yes No
CSIDavids 2 on at

Like (0)

Report
Copy link

Link copied!
I am getting an error that the expression is not valid. I am using this one:
@lessOrEquals(items('Apply_to_each')?['Modified'], subtractFromTime(utcNow(), 3, 'Year'))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi I have attempted the same solution on my side and I am getting a "Action 'Get_file_content' failed" error. I am trying to archive files from one library to a another library within the same share point. The flow does work if I try to archive within the same library.

{
"status": 404,
"message": "File not found\r\nclientRequestId: "
}

Was this reply helpful? Yes No
gapparicio 2 on at

Like (0)

Report
Copy link

Link copied!

I would like to add a parameter: EMAILS THAT THE SUBJECT CONTAINS "ABC123".
Can you help me please?

Was this reply helpful? Yes No
abrarali 8 on at

Like (0)

Report
Copy link

Link copied!

I have tried recreating the flow, but getting the error: {
"status": 404,
"message": "File not found\r\nclientRequestId: 9d411da1-1aa1-4a0d-a8af-e4ac594a3933\r\nserviceRequestId: 9d411da1-1aa1-4a0d-a8af-e4ac594a3933"
}

Can someone provide any suggestions?

Was this reply helpful? Yes No
CU29071423-0 134 on at

Like (0)

Report
Copy link

Link copied!

Everything looks easy, however PA copy or move for files have known problems in Sharepoint as of Aug 2025, in my case I never get same number of rows on target vs source Excel file, some rows just got lost.

Was this reply helpful? Yes No