Hello guys, I'm trying to find a solution to this:
I'm having a General folder including multiple folders for different week, named as: YYYY.MM.DD and I'm trying to copy the last report (named as Inventory....) to a new created folder each week.
I'm thinking of either 2 these solutions:
1. To "Copy files" named Inventory* from the "Last modified folder" to the new created folder
-> But honestly, I don't know how to "call out" the last modified folder in Power Automate Desktop. The only action that produce a "folder" variable here is the "Get special folder" - which doesn't allow me for "Advanced parameter/selection" like the action "Get files in folder" or "Get subfolders in folder"; but the later 2 produce "a list of folder" which cannot be used with "Copy files"
I believe the "Advanced" here is the answer to my solution, but unfortunately, this action "Get subfolders in folder" produce a "list of folder" as variable; instead of "folder" and thus I cannot refer to it when using "Copy files" action.
2. Use "Get files in folder" to generate a list of files that match the criteria as "Inventory xx"; and then use "copy files" but ONLY COPY THE FIRST FILE in the list (like last modified)
-> But under this, I don't know how I can "copy" only the 1st file in the list, either.
I look for a similar solution here: Solved: Is it possible to copy/move only the most recent f... - Power Platform Community (microsoft.com) but somehow my Action "Copy files" doesn't give me any "advanced parameter" as suggested in the post (as you see in my screenshot above)
I'm very new to Automate so plz forgive if above question is silly 🙂
Thanks & best regards,
