cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nickliau
Frequent Visitor

Move files to an archived folder after 7 days

I'm trying to move file that is older than 7 days to an archived folder by following online guide. but it keep showing me error..

 

the setting as shown below

 

nickliau_0-1642217518542.png 

nickliau_3-1642217632317.png

 

Below is the error, when i try to run the flow. 

nickliau_4-1642217800483.png

 

Anyone know how to fix this error?

 

thanks

7 REPLIES 7
ekarim2020
Super User
Super User

You shouldn't need to use the Get File metadata action. Please try:

Snag_6c3d1a4.png


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

Hi @ekarim2020 , Thank you for the reply.. 


I have try your recommended solution.

 

The flow seems like ran successfully. However, the file do not move to the archived folder. May i know what is the reason?

nickliau_0-1642380813940.png

No file moved to the archieved folder after ranning successfully:

nickliau_3-1642381241826.png

 

This is the file that i need to move:

nickliau_1-1642380989623.png

 

This is how I count the day and limit the entries to the respective folder only:

nickliau_2-1642381141035.png

 

Can you assist for the problem?

 

Thank you.

 

 

From the runtime output, how many files did the flow try to move?

For example, 29 files moved:

ekarim2020_0-1642497025111.png

Check the runtime for the Move file action to see WHERE the files were moved to

 

Or if no files were moved you will see:

ekarim2020_1-1642497056306.png

 

Please check the date calculation in Get Files query filter.

 

To simplify the find process you could hardcode a date into the query:

ekarim2020_2-1642498605325.png

If the flow works, then look at the data calculations.

 

Ellis

 

 

 

@nickliau 

Can you post a screen shot of your loop and the actions in the loop?

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

Scott

Hi, @ekarim2020 

 

I tried to run the flow but No file is moving. below is the screenshot:

nickliau_0-1642552252466.png

 I did try to hardcode the date as per following

nickliau_1-1642554655839.png

but still no file is moving

nickliau_2-1642554734552.png

 

Hi @ScottShearer 

 

Currently my flow action as below:

nickliau_3-1642555115769.png

 

nickliau_4-1642555171811.png

 

Below is how its look like after the flow run:

nickliau_6-1642555320049.png

 

Flow ran successfully but actually no file is moving.

It looks like your Get files action is not returning any values (files):

Snag_727d63.png

Please check the filter query and confirm that it does return a valid set of files.

 

Ellis

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (4,084)