Answered

Move files based on .CreationTime

(0) Share

Report

Posted on by garthh

138

I have created a List of files successfully and need to move only those based on .CreationTime that = a FormatedDateTime variable, into another folder. The variables created are shown below.

What are the Desktop Actions needed to Move only the files that have this FormatedDateTime?

I have tried many options but get an error each time

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @garthh

Try something like this

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Nived
Thank you
I was on the right track with For each and If but didn't have the first operands format correct. I'll get back once I have the time to try it

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Nived
I believe these Actions are correct, no error appeared when run however, the files were not moved.
I used the default CurrentItem variable name
The first and second operands FormattedDateTime4 are shown
Thoughts?

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Nived
I notice Month have different formats
In the file list Month is 6
In FormattedDateTime4 Month is 06
Is this the issue? A solution for this?

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

for the formmated date, could you change that to M/dd/yyyy type and the compare, i think that would work
something like below

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(1)

Report
Copy link

Link copied!

Nived
Found that myself and Move works
Thank you again for the helping

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Nived
Can you help?
This PAD flow worked well but doesn't now!
Can you see why?
I have checked the CreationTime dates in Files2 against FormattedDate4

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What's the format of your %FormattedDate4%? If it uses either MM or dd in the format, it will have leading zeros in the month and/or day (as in 08/03/2023), whereas doing %CurrentItem.CreationTime.Month% and %CurrentItem.CreationTime.Day% will not (as in 8/3/2023). Try using M/d/yyyy when formatting the date.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No