Is it possible to copy/move only the most recent file (Last modified) in a folder using Power Automate Desktop? How can I do it?

[Ricardor]

Is it possible to copy/move only the most recent file (Last modified) in a folder using Power Automate Desktop? How can I do it?

[Anonymous · Accepted solution]

You could try this:

1) Use 'Get Files in Folder' with the folder you want to work. In Advanced options, order by 'Last modified'. This will give you a list where the 1st item is the last modified file in the folder ('%Files%' variable).

2) Then use the action 'Copy Files' or 'Move Files' w/ first item of the previous list as parameter - %Files[0]%.
I use PAD in a non-english version, so not sure if I translated the actions' names correctly.

[Ricardor]

Ty my bro!!

[sonam1996sahoo]

Hi, @Anonymous 

I tried this solution but it is not working. It is showing me an error that The query is not valid.
clientRequestId: a8959e0e-a9e7-4cc3-9ca9-ab91b3fc23e2
serviceRequestId: a8959e0e-a9e7-4cc3-9ca9-ab91b3fc23e2

May I know the reason?

[Kamacete]

Hi,

Same problem here.

I need to get the last file created in a share drive folder (folder A) with the name "test_2022-09-15.xlsx" and copy to another folder (folder A) with the name of "test_lastFileUpdated.xlsx", and replace this the file (folder B) every time a new file is added on Folder A

Can someone help please?

[pmmredlana]

Use Modified instead of 'Modified' in the ODATA query.

[Kamacete]

Thank you very much.

But this will copy the file with the same name that we have on the original one. However, I have to copy to a different name.

E.g.:

from: file2022-09-20.xlsx

To: file_final.xlsx

[cpkhoi]

I'm so sorry but can anyone help me?

This is my screen for the "copy files" but there's no "advanced options"? Am I missing something? Or using a different version?

[MichaelAnnis]

It’s in get files.