I have a flow that creates a number of excel files each day in a folder that also contains python scripts.
At the end of the flow I want to move the excel files created that day into another folder
The Move action variable lists and sorts the files but i can't figure out how to move only those created today
This is a sample list sorted in descending order
Solved! Go to Solution.
Hi @GJH
Option 1:
Once you have a list of files, use "For each" loop and check "CreationTime" for each file
You can access it the following way: %File.CreationTime%
Option 2:
1. At the start of the flow - create list of the files in the fodler
2. At the end of the flow - create second list of the files
3. Find the delta using Subtract Lists
4. Move files
Variables actions reference - Power Automate | Microsoft Learn
I would go with Option 2- cleaner, less code
Hi @GJH
Option 1:
Once you have a list of files, use "For each" loop and check "CreationTime" for each file
You can access it the following way: %File.CreationTime%
Option 2:
1. At the start of the flow - create list of the files in the fodler
2. At the end of the flow - create second list of the files
3. Find the delta using Subtract Lists
4. Move files
Variables actions reference - Power Automate | Microsoft Learn
I would go with Option 2- cleaner, less code
Momlo
Thank you. Yes your List option works well and is the better option - I dislike loops!
User | Count |
---|---|
13 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
20 | |
17 | |
17 | |
12 | |
11 |