cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nickliau
Regular 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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,523)